TDA-C01 Dumps Help You Study Objectives

1. You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis. You need to configure be shapes to be much larger than the line.

What should you do?

2. DRAG DROP

You have the following calculated fields in a worksheet.

[Calc1] = DATEADD ('year', -1, TODAY ())

[Calc2] = DATETRUNC ( 'month' , DATEADD ('year', -1, TODAY ())

You want to calculate the month to date value of the prior year.

How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

3. You are creating a new dashboard.

You need to add a button to the dashboard that allows users to export the dashboard as an image.

Which type of object should you use?

4. You want to add a draft watermark to a dashboard as shown in the following exhibit.





Which type of object should you use?

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

A. .png

B. .html

C. .xlsx

D. .txt

E. .pptx

F. .csv

6. DRAG DROP

You have a table that contains the following data.





You want to create a formula to label a bar chart as shown in the following exhibit.





How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

7. HOTSPOT

You receive a tab-delimited data file name sales.tsv.

You need to connect to the file.

Which option should you select in Tableau Desktop?

8. You have the following dataset.





You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer

Which formula should you use for the filter?

9. 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?

10. You want to create the following dashboard.





The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.

When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.





How should you lay out the objects on the dashboard?

11. You publish a dashboard tut uses an attract. The extract refreshes every Monday at 10:00.

You need to ensure that the extract also refreshes on the last day of the month at 18:00.

What should you do?

12. You have the following dataset.





Which formula calculates the percent difference in sales relative to the same quarter the previous year as shown in the Calculation field?

13. You have a dataset that contains sates data.

The following is a sample of the data.





You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false.

Which two formulas achieve the goal Choose two

14. You have the following tiled dashboard that has one sheet.





You want to replace the sheet with Sheet2.

What should you do?

15. You have the following dataset.





Which grouping option should you use m Tableau Prep to group al five names automatically?

16. You have the following table.





You need each record to alternate between grey and white.

What should you change in the Format Shading pane?

17. You have the following dataset that contain 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.

18. You are the owner of an alert.

You receive an email notification that the alert was suspended

From where can you resume the suspended alert?

19. You have the Mowing two tables that contains data about the books in a library.









Both tables are incomplete so there are books missing from the tables.

You need to combine the tables. The solution must ensure that all the data is retained.

Which type of join should you use?

20. HOTSPOT

You have a blank dashboard.

You want to add two sheets to the dashboard. The sheets must support the Show/Hide button.

To which two objects can you add the sheets? (Click the two appropriate Options in the Answer Area.)

21. HOTSPOT

You have a dashboard that is configured for desktop browsers.

You want to customize a layout for mobile users.

Which option should you select first? (Click the appropriate Option in the Answer Area.)

22. You want to create the following table in a view.





Which function should you use to create the Position column?

23. You have the following dataset:





You want to create a parameter to dynamically filter the data to produce the following results.





Which two types of parameters can you use to produce the results? Choose two.

24. HOTSPOT

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.)

25. You have the following chart that sorts states by the number of products each state has purchased.





Which formula should you use to include a number with the position of each state within each region?

26. DRAG DROP

You are developing a data source in Tableau Prep.

You have two tables named Orders and Employees.

The Orders table was created in 2019 and contains the following columns.





The Employees table contains all the employee information for the various sales teams in the sales department and contains the following columns





You want to prepare the data so that you can analyze sales trends over time for every sales team.

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.)

27. You need to change the values of a dimension without creating a new field.

What should you do?

28. You have the following line chart that shows the average sales by month.





Which month had the biggest increase in swage sales compared to me previous month in 2019?

29. You have the following dashboard.





Currently the map is used as a filter that affects the data on the otter sheets of the dashboard

You need to configure the dashboard to ensure that selecting a data point on the map only tillers the Detail table

What should you do?

30. Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.

Add a distribution band on Profit to show the standard deviation from- 1 to 1.