Tableau Certified Data Analyst v1.0
Question 1
You have a Tableau workbook that contains three worksheets named Sheet1, Sheet2, and Sheet3.
You create several filters.
From the Data Source page, you plan to add data source filters.
Which type of filter will appear in the Edit Data Source Filters dialog box?
- A. A context filter on a dimension in Sheet3
- B. A table calculation filter used on Sheet2
- C. A top N condition filter on a dimension in Sheet1 and Sheet2
- D. A dimension filter on all the sheets
Answer : D
Question 2
You have the following dataset.
Which grouping option should you use in Tableau Prep to group all five names automatically?
- A. Pronunciation
- B. Common Characters
- C. Spelling
- D. Manual Selection
Answer : C
Question 3
You have the following visualization.
The Last() calculation is set to compute using Table (across).
Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Order Date?
- A. 2
- B. 3
- C. 4
- D. 0
Answer : C
Question 4
HOTSPOT -
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?
Answer : Navigation.
Question 5
You have the following dashboard.
Currently, the map is used as a filter that affects the data on the other sheets of the dashboard.
You need to configure the dashboard to ensure that selecting a data point on the map only filters the Detail table.
What should you do?
- A. From the context menu of Sales over time, select Deselect.
- B. From the context menu of Sales over time, select Ignore Actions.
- C. From the context menu of Profits by State, deselect Use as Filter
- D. From the context menu of Sales over time, select Remove Dashboard Item.
Answer : B
Question 6
DRAG DROP -
You have a dataset that contains daily sales by business segment from 2017 to the present.
You want to use monthly historical trends to predict sales by segment in the future.
Which three actions should you perform in order?
(Place the three correct options in order Use the arrows to move Options to Answer Area Use Answer Area arrows to re-order the options.)
Answer : 
Question 7
You have the following chart that shows profits and discounts over time.
You need to combine the lines to appear as shown in the following chart.
What should you do?
- A. Drag Discount to Color on the Marks card
- B. Drag Discount to the Columns shelf.
- C. Set Discount to Dual Axis
- D. Convert Discount to Discrete
Answer : B
Question 8
You have the following chart that shows the cumulative volume of sales from various dates.
You want the months to appear as shown in the following chart.
What should you do?
- A. Select Show Missing Values for the date
- B. Convert the date to Attribute
- C. Convert the date to Continuous
- D. Convert the date to Exact Date
Answer : C
Question 9
In which three formats can you export a worksheet from the Worksheet menu? (Choose three.)
- A. .csv
- B. .xlsx
- C. .png
- D. .html
- E. .pptx
- F. .txt
Answer : ABD
Question 10
You have the following dataset that contains null values in the Profits field.
You want the data to appear as shown in the following table.
Which two formulas achieve the goal? (Choose two.)
- A. ISNULL((Profits])
- B. IF [Profits] != null then [Profits] END
- C. IFNULL([Profits],0)
- D. ZN([Profits])
Answer : CD
Question 11
You have the following dataset in Microsoft Excel.
You are using Data Interpreter to cleanse the dataset Data Interpreter provides the following results.
- A. 15
- B. 17
- C. 19
- D. 20
Answer : D
Question 12
You create a parameter named Choose Region that contains values from a field named Region.
You want users to be able to use the Choose Region parameter to interact with a chart by toggling between different regions.
What should you do next?
- A. Set the Choose Region parameter to Single Value (list).
- B. Add the [Region] = [choose Region] formula to the Filters card.
- C. Add Region to the Filters card.
- D. Add the Choose Region parameter to the Pages card.
Answer : B
Question 13
DRAG DROP -
You connect to a Microsoft SQL Server database.
You need to create a custom SQL query that retrieves rows from a table named Students. Only students in the city of Berlin must be returned.
How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
Answer : 
Question 14
A colleague provides you with access to a folder that contains the following files:
• Sales.csv
• Book1.json
• Sales.tds
• Export.mdb
Which file contains an extract?
- A. Sales.csv
- B. Export.mdb
- C. Book1.json
- D. Sales.tds
Answer : D
Question 15
HOTSPOT
-
You have the following chart.
You want to calculate the percentage change of sales by using 2017 as the reference year to create the following chart.
How should you configure the quick table calculation?
Answer : 