Tableau TDA-C01 問題集

質問 1：
You want to add a comment to March 2020 as shown in the following visualization.
You have the following sets in a Tableau workbook
* Top N Customers
* Customers of 2020
* Top N Products
* Sellers of 2020
Which two sets can you combine? Choose two
A. Customers of 2020
B. Top N Products
C. Top N Customers
D. Sellers of 2020
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You have a table that contains four columns named Order Date, Country, Sales, and Profit.
You need to add a column that shows the day of the week for each row. For example, orders placed on August 31, 2022, will show a day of Wednesday.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

正解：

Reference:
Tableau Help: DATENAME Function
Tableau Help: Date Functions
To add a column that shows the day of the week for each row, you should complete the formula as follows:
DATENAME
(
'weekday'
, [Order Date])
The DATENAME function in Tableau returns the name of a specified part of a date or datetime value, such as the year, month, or day. It takes two arguments: the date part and the date. In this question, you want to return the name of the weekday, such as Monday, Tuesday, or Wednesday, for each order date. Therefore, you need to use 'weekday' as the date part and [Order Date] as the date. The formula will return a string value that represents the name of the weekday for each order date.
Tableau Help: DATENAME Function
Tableau Help: Date Functions

質問 3：
You company has two divisions located in the United States and Germany Bach division has a separate database. The following is a sample of the sales data for the division in the United States.

The following is a sample of the sales data for me division in Germany.

You have population data in a file named Populatio.csv. the following is a sample of the data.

You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.
You need to prepare the data to support the planned visualization. The data source must support being published .
Which four actions should you perform in order?
(Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options.
Use Answer Area arrows to re-order the options)

正解：

1 - Open Tableau Prep
2 - Create a new column to concatenate the name for the Germany division
3 - Union the sales data of both divisions
4 - Join the sales data and the population data by using Country as the join field

質問 4：
You have a dataset that contains people and the awards they have won.

Which formula should you use to get the number of different types of awards that have been won?
A. COVAR({Award})
B. INDEX()
C. COUNTD({Award})
D. COUNTD {(NAME])
E. MAX {(Award})
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You have the following tiled dashboard that has one sheet.

You want to replace the sheet with Sheet2.
What should you do?
A. From the context menu of Sheet3, select Remove Dashboard Item.
B. Right-click Sheet2 and select Add to Dashboard.
C. Select Sheet3 and click the Swap Sheet button next to Sheet2.
D. From the context menu of Sheet3, select Deselect.
E. Drag Sheet2 to the dashboard.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You have the following dashboard that contains two visualizations.

You want to show only visualization at time. Users must be able to switch between visualizations.
What should you me?
A. A parameter and a calculated filed
B. Showhide buttons
C. Dashboard actions
D. Worksheet actions
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You have the following visualization.


正解：