Tableau TDA-C01 問題集

質問 1：
You have a dashboard that contains a parameter named Start Date.
You need to create an extract from a Microsoft Excel file. The extract must be filtered based on Start Date.
What should you do?
A. Create a data source based on the Excel worksheet and create a calculated field based on Start Date.From the Data pane, add the calculated field to the data source filter
B. Create a custom SOL query that references Stan Date in the WHERE clause.
C. Create a custom SOL query to define the data source and create a calculated field based on Start Date.
Add the calculated field to the extract filter.
D. Create a data source based on the Excel worksheet and create a calculated field based on Start Date.
Add the calculated field to the extract filter.
正解：D

質問 2：
You have the following dataset:

Which grouping option should you use in Tableau Prep to group all five names automatically?
A. Pronunciation
B. Spelling
C. Common Characters
D. Manual Selection
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
In a dataset, you have a string field named Name that contains unnecessary semicolons.
Which function should you use to remove the semicolons from the Name field?
A. TRIM
B. SPLIT
C. REPLACE
D. CONTAINS
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A Data Analyst is creating a new dashboard.
The analyst needs to add a button to the dashboard that allows users to export the dashboard as an image.
Which type of object should the analyst use?
A. Navigation
B. Image
C. Download
D. Extension
正解：C

質問 5：
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?
A. Dimension filler
B. Table calculation filter
C. Measure filter
D. Context filter
正解：D

質問 6：
A Data Analyst wants to create the following table in a view:

Which function should the analyst use to create the Position column?
A. RANK
B. LAST
C. INDEX
D. FIRST
正解：D

質問 7：
A Data Analyst has two tables named EmployeeInfo and DepartmentInfo. EmployeeInfo contains four fields named Full Name, Department ID, Start Date, and Salary. DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP. The analyst wants to combine the tables to meet the following requirements:
* EmployeeInfo is the first table that is dragged to the canvas,
* The records must contain the Full Name, and the Department Name, Size, and VP fields if available,
* Not all records have an exact match.
Which type of join should the analyst use?
A. Union
B. Full outer
C. Left
D. Inner
正解：C