Salesforce Analytics-DA-201 問題集

質問 1：
You create the following story that contains two story point.

You want to change the story point format to show the current story point number out of the total number of story points.
Which Layout option should you use?
A. Dots
B. Numbers
C. Caption boxes
D. Arrows only
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A Data Analyst has a data source that has two tables named Table1 and Table2. Table1 is the primary table and Table2 is the secondary table.
The analyst wants to combine the tables by using Tableau Prep. The combined table must include only values from Table1 that do not match any values in Table2. The field values from Table2 must appear as null values.
Which type of join should the analyst use?
A. Union
B. Left only
C. Full outer
D. Left
E. Inner
正解：B

質問 3：
You have a line chart on a worksheet.
You want to add a comment to March 2020 as shown in the following visualization.
What should you do?

A. Add a tooltip
B. Annotate March 2020
C. Drag the growth rate to Text on the Marks card
D. Enable captions
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A Data Analyst has a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.
The following is a sample of the data.

The analyst wants to ensure that every calculation is affected by including only animals of a particular type.
Which type of filter should the analyst create on the worksheet?
A. Measure
B. Context
C. Table calculation
D. Extract
正解：B

質問 5：
You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.

You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?
A. Condition filter
B. General filter
C. Top filter
D. Wildcard filter
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
A Data Analyst has the following dashboard.

Currently, the map is used as a filter that affects the data on the other sheets of the dashboard.
The analyst needs to configure the dashboard to ensure that selecting a data point on the map only filters the Detail table.
What should the analyst do?
A. Deselect Use as Filter from drop-down menu of Profits by State
B. Select Remove Dashboard Item from the drop-down menu of Sales over time.
C. Select Ignore Actions from the drop-down menu of Sales over time.
D. Select Deselect from the drop-down menu of Sales over time.
正解：C

質問 7：
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. RTRIM
B. SPLIT
C. REPLACE
D. LTRIM
正解：A

質問 8：
A Data Analyst needs to calculate the percent of regional sales that each state contributes to. As a first step, the analyst needs to calculate total sales per region.
Which calculation should the analyst use to do this?
A. {FIXED [State], [Region]: SUM([Sales])}
B. {FIXED [Region]: SUM([Sales])}
C. {FIXED [State]: SUM([Sales])}
D. [FIXED [Region]: TOTAL([Sales])]
正解：B

質問 9：
You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis.
You need to configure be shapes to be much larger than the line.
What should you do?
A. For the second axis select Shape on the Marks card From Select Shape Palette select Custom and then select Reset
B. Change Population to a discrete dimension
C. Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository
D. Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently
正解：D
解説: (Topexam メンバーにのみ表示されます)