TDA-C01問題集、Tableau実際の試験問題

質問 1

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?

A. Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source.

B. Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name, select Replace References, and then select Dorm Name New.

C. Bring in the secondary data source as a union.

D. Bring in the secondary table as a left join to the primary data source. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dorm_Name_New] in the calculation window.

正解: B

質問 2

You want to create the following table in a view.

Which function should you use to create the Position column?

A. RANK

B. INDKX

C. LAST

D. FIRST

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 3

You have a data source that contains the following columns.

You want to sort customers based on the most expensive orders.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

正解:

質問 4

You have a dashboard than contains two sheets named Sheet 1 and Sheet 2.
You want to add an object to the dashboard that users can click to switch to a different dashboard in the workbook.
Which object should you add to the dashboard?

正解:

The object that you should add to the dashboard to allow users to switch to a different dashboard in the workbook is Navigation.
Navigation objects are used to create links between dashboards or sheets in a workbook. You can add a navigation object to a dashboard by dragging it from the list of objects and dropping it on the dashboard. You can then configure the navigation object to specify the destination dashboard or sheet that you want users to navigate to when they click on it.
You can learn more about navigation objects and how to use them in this article: https://help.tableau.com
/current/pro/desktop/en-us/dashboards_navigation.htm

質問 5

Which function should a Data Analyst use to average sales at a less-granular level of detail than is in the view?

A. AVG

B. RUNNING_AVG

C. EXCLUDE

D. INCLUDE

正解: C

質問 6

A Data Analyst is given the following table and asked to create a flow that adds a date field to the data. This field should automatically update as new dates (months) are added to the original table.

Which technique should the analyst use as the first step to achieve this in Tableau Prep?

A. A Rows to Columns Pivot step

B. A wildcard search to pivot in the Pivot step

C. An Aggregate step to reshape the data

D. A wildcard search for multiple tables in the Input step

正解: B

質問 7

You have the following worksheet.

You want to create a table calculation that shows sales growth over each year.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

正解:

Explanation:
There are different ways to create a table calculation that shows sales growth over each year, but one possible answer is:
* SUM([Sales])
* LOOKUP(SUM([Sales]), -1)
* PREVIOUS_VALUE(0)
To calculate the sales growth over each year, you need to compare the current year's sales with the previous year's sales and divide the difference by the previous year's sales. You can use the SUM, LOOKUP, and PREVIOUS_VALUE functions to achieve this. The SUM function returns the total sales for each year. The LOOKUP function returns the value of an expression in a target row, specified as a relative offset from the current row. The PREVIOUS_VALUE function returns the value of the expression in the previous row, or a specified value if there is no previous row. The formula for the table calculation is:
(SUM([Sales]) - LOOKUP(SUM([Sales]), -1)) / PREVIOUS_VALUE(0)
This formula subtracts the sales of the previous year (LOOKUP(SUM([Sales]), -1)) from the sales of the current year (SUM([Sales])) and divides the result by the sales of the previous year. If there is no previous year, the formula uses 0 as the denominator (PREVIOUS_VALUE(0)) to avoid division by zero errors.
References:
Tableau Certified Data Analyst Exam Prep Guide, page 11, section "Creating Calculated Fields" Tableau Help: SUM Function Tableau Help: LOOKUP Function Tableau Help: PREVIOUS_VALUE Function

質問 8

in which three formats can you export a worksheet from the Worksheet menu? Choose three

A. .txt

B. .png

C. .csv

D. .html

E. .pptx

F. .xlsx

正解: B,E,F

解説: (PassTest メンバーにのみ表示されます)

質問 9

You have the following visualization.

You want the count of Returns displayed only for the first year in the table.
How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

正解:

Explanation:
we need to create a calculated field that displays the count of returns only for the first year in the table. To do this, we can use the following formula:
IF FIRST () = 0 THEN COUNT (Returns) END
This formula uses the FIRST () function, which returns the number of rows from the current row to the first row in the partition. If the current row is the first row, then FIRST () returns 0. The IF statement checks if this condition is true, and if so, it returns the count of returns for that row. Otherwise, it returns NULL.
To complete the formula in the calculated field, you should select the following options from the drop-down menus:
* FIRST ()
* 0
* COUNT (Returns)
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_date.htm

Tableau Certified Data Analyst - TDA-C01 模擬練習