Tableau TDA-C01 問題集

質問 1：
A Data Analyst has the following dataset in Microsoft Excel.

The analyst is using Data Interpreter to cleanse the dataset. Data Interpreter provides the following results.

How many rows of data will be ingested into Tableau as values?
A. 19
B. 15
C. 17
D. 20
正解：A

質問 2：
From Tableau Desktop you sign in lo a Tableau Server site.
What appears in the list of available data sources when you search for a published data source?
A. All the data sources published to the Tableau Server
B. All the data sources published to the site within the folders to which you have access
C. All the data sources published to the site
D. All the data sources published to the Tableau Server within the folders to which you have access
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A Data Analyst has a workbook that uses an extracted data source.
The analyst publishes the workbook to Tableau Server.
Which three actions can the analyst perform from the Extract Refresh page in Tableau Server? (Choose three.)
A. Run a refresh
B. Change the priority of the refresh
C. Modify the frequency of the refresh
D. Change the refresh from full to incremental
E. Delete the refresh
正解：A,B,C

質問 4：
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.)

正解：

Explanation:
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.
References:
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.
References:
Tableau Help: DATENAME Function
Tableau Help: Date Functions

質問 5：
You have a workbook that connects to a database. The database requires authentication.
You plan to publish the workbook and schedule a daily refresh of the data.
Which two conditions must be met to schedule the refresh? Choose two.
A. The data must be extracted.
B. The data source must be stored as a hyper file.
C. The data source must use a live connection.
D. The credentials must be embedded.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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.)
正解：
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

質問 7：
A Data Analyst has the following chart.

The analyst needs to enable the drilldown from Category to Subcategory as shown in the following chart.

What should the analyst create?
A. A combined set for Category and Subcategory
B. A hierarchy of Category and Subcategory
C. A bin for Category and a bin for Subcategory
D. A group of Category and Subcategory
正解：B