最新的Tableau Certified Data Analyst - TDA-C01免費考試真題
問題1
You have the following dashboard.
When a user selects a only on the map the data on the bar chart must show only the data for the selected city.
The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)
When a user selects a only on the map the data on the bar chart must show only the data for the selected city.
The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)
正確答案:
Explanation:
To configure the dashboard action, you should select Filter as the action type, Select as the run action on option, and All Fields as the target filters option. This will ensure that when a user selects a city on the map, the bar chart will show only the data for the selected city based on all fields in common between the two worksheets. The action will run only when the user selects a different city. References: https://help.tableau.
com/current/pro/desktop/en-us/actions.htm https://help.tableau.com/current/pro/desktop/en-us/actions_filter.htm
問題2
A Data Analyst is using containers on a dashboard.
How should the analyst make sure multiple objects within a container are always taking up the same width or height, even if the container is resized?
How should the analyst make sure multiple objects within a container are always taking up the same width or height, even if the container is resized?
正確答案: B
問題3
A Data Analyst has the following primary data source that contairis a dimension named Dorm_Code.
The analyst receives the following secondary data source that contains updated dorm codes.
The analyst needs to bring the updated dorm codes into Tableau and use the codes in existing visualizations.
The new dorm codes must use the existing field name of Dorm_Code.
What should the analyst do?
The analyst receives the following secondary data source that contains updated dorm codes.
The analyst needs to bring the updated dorm codes into Tableau and use the codes in existing visualizations.
The new dorm codes must use the existing field name of Dorm_Code.
What should the analyst do?
正確答案: B
問題4
A Data Analyst creates the following story that contains two story points.
The analyst wants 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 the analyst use?
The analyst wants 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 the analyst use?
正確答案: B
問題5
You want to create the following table in a view.
Which function should you use to create the Position column?
Which function should you use to create the Position column?
正確答案: B
說明：（僅 VCESoft 成員可見）
問題6
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?
How should the analyst enable this formatting across the workbook?
正確答案: D
問題7
How are the colors configured for the map?
正確答案: D
問題8
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.)
* 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.)
正確答案:
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
* 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
問題9
You have 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.
You want to improve the performance of the views by including only animals of a particular type.
To which filter should you add the Type field on the worksheet?
The following is a sample of the data.
You want to improve the performance of the views by including only animals of a particular type.
To which filter should you add the Type field on the worksheet?
正確答案: D
