Salesforce Analytics-DA-201 問題集

質問 1：
You are subscribed to several views.
You need to unsubscribe from the views.
What should you use?
A. The Shared with Me page
B. The Data Source page of Tableau Desktop
C. The My Content area of Tableau web pages
D. The Notifications area of Tableau Prep
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You have the following two tables.


Table A is the primary table.
Which type of join is established when a blend is created by using the join key of Category?
A. Inner join
B. Right join
C. Outer join
D. Left join
正解：D

質問 3：
You connect to a database server by using Tableau Prep. The database server has a data role named Role1.
You have the following field in the data.

You need to apply the Role1 data role to the Material field.
Which two actions should you perform? Choose two.
A. From the More actions menu of Materials, select Group Values, and then select Spelling.
B. From the More actions menu of Materials, filter the selected values.
C. From the More actions menu of Materials, select Valid in the Show values section.
D. For the data type of the Material field, select Custom, and then select Role1.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the future Which three actions should you perform m order?
(Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)

正解：

Explanation:
The correct order of the three actions is:
* Add the date to the Columns shelf. Add the segment and the sales to the Rows shelf.
* Aggregate the date to month and year.
* From the Analytics pane, drag Forecast to the worksheet.
The first action is to add the date to the Columns shelf and the segment and the sales to the Rows shelf. This will create a line chart that shows the daily sales by segment over time. You can use the Show Me menu to choose a line chart if it is not selected by default.
The second action is to aggregate the date to month and year. This will group the daily sales into monthly sales and show the yearly trend. You can right-click on the date field on the Columns shelf and select Month (January 2017) from the menu. You can also drag Year from the Dimensions pane to the Columns shelf before or after Month.
The third action is to drag Forecast from the Analytics pane to the worksheet. This will add a forecast that predicts future sales by segment based on historical trends. You can customize the forecast by clicking on it and using the options on the Marks card.
The other options are not relevant for this scenario. Adding a trend line would show a linear or nonlinear relationship between two measures, but not a prediction of future values. Creating a calculated field that uses the model quantile function would return a value from a statistical model based on a given quantile, but not a forecast.
References: https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current
/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/dates.htm
https://help.tableau.com/current/pro/desktop/en-us/analytics_forecast.htm https://help.tableau.com/current/pro
/desktop/en-us/functions_functions_statistical.htm#MODEL_QUANTILE

質問 5：
A Data Analyst has the following dataset.

The analyst wants to create a parameter to dynamically filter the data to produce the following results based on quantity being above X value.

Which two types of parameters should the analyst use to produce the results? (Choose two)
A. Date
B. Float
C. Integer
D. Boolean
正解：B,C

質問 6：
You have the following box plot that shows the distribution of average profits made in every state by region.

Which region has the smallest distribution of profits?
A. South
B. Cast
C. Central
D. West
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 7：
A Data Analyst needs to analyze the financial performance of the sales team. In order to make the dashboards easier to understand, the analyst needs to format the financial values to show the dollar symbol ($) in front of the value.
How should the analyst enable this formatting across the workbook?
A. Right-click on the measure in the data pane, then click on Create and Calculated Field to convert to a string and add the $ symbol.
B. Right-click on the measure in the data pane, then click on Default Properties and Number Format.
C. Click on the Analysis tab and select Forecast.
D. Click on the Format tab and select Workbook Theme.
正解：B