Free TDA-C01 Exam Braindumps (page: 4)

Page 3 of 17

HOTSPOT (Drag and Drop is not supported)
You have the following dataset.



Yon need to calculate the ranking shown in the Rank field. How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula ?

  1. See Explanation section for answer.

Answer(s): A

Explanation:




To calculate the ranking shown in the Rank field, you need to use the RANK_UNIQUE function, which returns the unique rank of each value in a partition. You need to specify the expression as SUM([Sales]), which calculates the total sales for each product. You also need to specify the order as descending, which means that the highest sales will have the lowest rank. Finally, you need to specify the restart as every [Category], which means that the ranking will reset for each category.


Reference:

https://help.tableau.com/current/pro/desktop/en- us/functions_functions_tablecalculation.htm https://help.tableau.com/current/pro/desktop/en-

us/calculations_calculatedfields_lod_rank.htm



You have the Mowing dashboard.



Which two elements are floating? Choose two.

  1. The state filter
  2. The color legend
  3. The map
  4. The Rate of Obesity chart
  5. The little

Answer(s): A,B

Explanation:

To identify which elements are floating on a dashboard, you can look for a gray border around them when you select them. Alternatively, you can open the Layout pane and see which elements have a pin icon next to them. The pin icon indicates that the element is floating and can be moved freely on the dashboard. Based on these criteria, the state filter and the color legend are floating elements on the dashboard.


Reference:

https://help.tableau.com/current/pro/desktop/en- us/dashboards_organize_floating_layoutcontainers.htm https://help.tableau.com/current/pro/desktop/en-us/dashboards_create_layouts.htm



You have a database that includes field named sales, City and Region. You have the following chart that shows the number of sales made in different cities.



You want to dynamically show the corresponding region when users hover their mouse over any of the bars.
What should you do?

  1. Right-click a in the chat, select Annotate and then select Mark.
  2. Right-click a bar in the chart select Mark Label and then select Always show.
  3. Edit the aliases for City.
  4. Drag Region to Tooltip on the Marks card

Answer(s): D

Explanation:

To show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box.


Reference:

https://help.tableau.com/current/pro/desktop/en- us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en- us/formatting_tooltips.htm



You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.
What should you do from Tableau Desktop?

  1. From the Data menu select New Data Source
  2. From the Data menu select Replace Data Source
  3. From the File menu select Import Workbook
  4. From the File menu select New

Answer(s): A

Explanation:

To connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet, you need to select New Data Source from the Data menu. This will open the Connect pane, where you can choose Microsoft

Excel as your data source and browse for your spreadsheet file. You can then drag and drop your sheets or tables to join or union them in the data source page.


Reference:

https://help.tableau.com/current/pro/desktop/en-us/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_excel.htm






Post your Comments and Discuss Tableau TDA-C01 exam with other Community members: