Salesforce Analytics-DA-201 問題集

質問 1：
You have the following two datasets:
* A Microsoft Excel worksheet that has two columns named Employee Name and Department
* A Microsoft SQL Server table that has three columns named Employee Name. Pay Grade and Team Size.
You want to use Tableau Prep to join the two datasets.
Which three actions should you perform in order? (Place the three correct options in order.)

正解：

Explanation:
The correct order of the three actions is:
* From the connections pane, connect to both data sources
* Join both datasets and select the join type
* Specify Employee Name as the join key
The first action is to connect to both data sources from the connections pane in Tableau Prep. The connections pane is where you can access and add data sources to your flow. You can connect to various types of data sources, such as Excel, SQL Server, or Tableau Server. In this case, you want to connect to an Excel worksheet and a SQL Server table.
The second action is to join both datasets and select the join type. A join is a way of combining data from two or more tables based on a common field. You can join datasets by dragging one table to the canvas and dropping it on top of another table. This will create a join step in your flow. You can select the join type from the drop-down list on the join step. The join type determines which rows are returned from the tables.
The third action is to specify Employee Name as the join key. A join key is a field that is used to match rows from different tables. You can specify the join key by clicking on the field name in each table and dragging it to the center of the join step. This will create a join clause that shows the field name and the operator. In this case, you want to use Employee Name as the join key, because it is a common field between the two datasets.
The other options are not relevant for this scenario. Specifying Department and Team Size as a join condition will not work, because they are not common fields between the two datasets. Opening both data sources in Tableau Desktop will not help you join them in Tableau Prep. Adding a step to aggregate the data in the SQL Server table will not affect the join, but it may change the level of detail of your data. References: https://help.
tableau.com/current/prep/en-us/prep_connect.htm https://help.tableau. com/current/prep/en-us/prep_join.htm
https://help.tableau.com/current/prep/en-us/prep_join_types.htm

質問 2：
You have a Tableau workbook.
You want to make the workbook available in Tableau Online.
What should you do?
A. From the Server menu, select Publish Data Source.
B. From the Server menu, select Tableau Public, and then select Save to Tableau Public.
C. From the Server menu, select Publish Workbook.
D. From the File menu, select Export Packaged Workbook.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You have a blank dashboard.
You want to add two sheets to the dashboard. The sheets must support the Show/Hide button.
To which two objects can you add the sheets? (Click the two appropriate Options in the Answer Area.)

正解：

Explanation:

To add two sheets to the dashboard that support the Show/Hide button, you can add them to either a horizontal or a vertical container. A container is an object that can hold one or more sheets or other objects and allow you to arrange them in a layout. A Show/Hide button is a feature that lets you hide or show a container and its contents on the dashboard. You can add a Show/Hide button to any container, whether it is tiled or floating, by using the drop-down menu of the container and selecting "Add Show/Hide Button." You can also customize the appearance and behavior of the button.
To add a horizontal or a vertical container to the dashboard, you can drag them from the Objects pane to the dashboard. A horizontal container will arrange the sheets or objects horizontally, while a vertical container will arrange them vertically. You can then drag the sheets you want to add from the Sheets pane to the container. You can resize and reorder the sheets or objects within the container by using the handles and arrows.
The other objects in the Answer Area, such as text, image, web page, blank, navigation, download, and extension, do not support the Show/Hide button. They are either static elements that cannot hold other objects, or dynamic elements that require user interaction or external sources. You can add them to the dashboard as well, but they will not have the same functionality as a container with a Show/Hide button.
References:
Add Show/Hide Buttons - Tableau
Layout Containers - Tableau

質問 4：
The following table displays the row-level data in a Tableau data source:

A Data Analyst creates this calculated field:
SUM(IF [Item] = ' A ' THEN [Sales] END) / COUNT([Order ID] )
What is the result of this aggregate calculation?
A. An error
B. 50
C. 12
D. 15
正解：C

質問 5：
A Data Analyst has the following worksheet in a dashboard that has a hierarchy from Market to Market Size in the view.
A stakeholder wants to see the total sales for each Market/Market Size depending on which hierarchy level is in the view.
Which calculation should the analyst use to get the Market and/or Market Size total?

A. { EXCLUDE [State] : SUM([Sales] ) }
B. { EXCLUDE [State] : TOTAL([Sales] ) }
C. { FIXED [Market] : { FIXED [Market Size] : SUM([Sales]) } }
D. { FIXED [State] : SUM([Sales] ) }
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You need to change the values of a dimension without creating a new field.
What should you do?
A. Rename the fields
B. Create groups
C. Transforms the fields
D. Create aliases
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
What is a key benefit of using parameter actions in Tableau?
A. They allow users to turn parameters into filters on the dashboard.
B. They create a static view of the data without any interactivity.
C. They restrict user interaction to predefined filters.
D. They allow users to dynamically change calculated fields based on selections.
正解：D
解説: (Topexam メンバーにのみ表示されます)