最新なSalesforce Analytics-DA-201問題集（214題）、真実試験の問題を全部にカバー！

質問 1：
You subscribe to a view that delivers a daily email to your inbox.
You want to make the subscription available to other stakeholders.
What should you do?
A. From the worksheet, modify the subscription.
B. From the dashboard overview page, modify the subscription.
C. From the My Content overview page, modify the alert.
D. From the My Content overview page, modify the subscription.
正解：D

質問 2：
In a dataset, a Data Analyst has a string field named Category that contains unnecessary trailing spaces.
Which function should the analyst use to remove the trailing spaces from the Category field?
A. REPLACE
B. LTRIM
C. RTRIM
D. SPLIT
正解：C

質問 3：
A Data Analyst has the following dataset:

The analyst wants to create a new calculated dimension field named Category that meets the following conditions:
When Subject is Computer Science or Science, the Category must be Sciences.
When Subject is English or Social Studies, the Category must be Humanities.
Which two logical functions achieve this goal? (Choose two.)
A. IIF((CONTAINS([Subject], ' Science ' ) = TRUE), ' Humanities ' , ' Sciences ' )
B. IF ENDSWITH([Subject], ' Computer Science ' ) THEN ' Sciences ' ELSE ' Humanities ' END
C. IF [Subject] = ' Science ' THEN ' Sciences '
ELSEIF [Subject] = ' English ' THEN ' Humanities '
ELSEIF [Subject] = ' Social Studies ' THEN ' Humanities '
ELSEIF [Subject] = ' Computer Science ' THEN ' Sciences '
END
D. CASE [Subject]
WHEN ' Computer Science ' THEN ' Sciences '
WHEN ' English ' THEN ' Humanities '
WHEN ' Social Studies ' THEN ' Humanities '
END
正解：C,D

質問 4：
A Data Analyst wants to create the following table in a view:

Which function should the analyst use to create the Position column?
A. RANK
B. LAST
C. INDEX
D. FIRST
正解：D

質問 5：
You have the following dataset

You need to create the following visualization.

Which quick table calculation should you drag to Text on the Marks card?
A. Compound Growth Rate
B. Percent Difference
C. Percentile
D. Percent of Total
正解：D
解説: (Pass4Test メンバーにのみ表示されます)

質問 6：
Which function should a Data Analyst use to aggregate total regional sales for a dataset regardless of what is in the view?
A. SUM
B. EXCLUDE
C. FIXED
D. INCLUDE
正解：C
解説: (Pass4Test メンバーにのみ表示されます)

質問 7：
You have a dataset that contains sates data. The following is a sample of the data.

You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false.
Which two formulas achieve the goal Choose two
A. IIF(SUM < [Sales] ) > 50000, TRUE, FALSE)
B. MAX < [Sales], 50000)
C. [Sales] > 50000
D. SUM{[Sales]) IN (50000)
正解：A,C
解説: (Pass4Test メンバーにのみ表示されます)