Tableau Tableau Certifications TDA-C01 Questions & Answers

• Question 31:

  You have the Mowing dashboard.

  

  Which two elements are floating? Choose two.

  A. The state filter

  B. The color legend C. The map

  D. The Rate of Obesity chart

  E. The little

  Correct Answer: CD

• Question 32:

  You have a line chart on a worksheet.

  You want to add a comment to March 2020 as shown in the following visualization.

  What should you do?

  

  A. Drag the growth rate to Text on the Marks card

  B. Enable captions

  C. Annotate March 2020

  D. Add a tooltip

  Correct Answer: D

• Question 33:

  You have the following dataset.

  

  Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?

  A. {FIXED: [Region] SUM Sales}

  B. {FIXED: SUM Sales}

  C. {Fixed: [Region]: TOTAL Sales}

  D. {FIXED: TOTAL (Sales)}

  Correct Answer: C

• Question 34:

  You have a dashboard that contains confidential information about patients health. The data needs to always be up to date tor a team of healthcare workers. How should you share me dashboard with the healthcare workers?

  A. Publish the dashboard to Tableau Public

  B. Print the dashboard to PDF

  C. Publish aw dashboard to Tableau Server

  D. Export the dashboard as a .twbx

  Correct Answer: B

• Question 35:

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

  A. From the Data menu select New Data Source

  B. From the Data menu select Replace Data Source

  C. From the File menu select Import Workbook

  D. From the File menu select New

  Correct Answer: D

• Question 36:

  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?

  A. Right-click a in the chat, select Annotate and then select Mark.

  B. Right-click a bar in the chart select Mark Label and then select Always show.

  C. Edit the aliases for City.

  D. Drag Region to Tooltip on the Marks card

  Correct Answer: A

• Question 37:

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

  Select and Place:

  

  Correct Answer:

  

• Question 38:

  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 m order?

  (Place the three correct options in order Use the arrows to move Options in Answer Area arrows to re order the options.)

  Select and Place:

  

  Correct Answer:

  

• Question 39:

  DRAG DROP

  You have a data source that contains the following columns.

  

  You want to filter regions based on the highest sales. Users must be able to specify the number of regions shown.

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

  Select and Place:

  

  Correct Answer:

  

  Explanation: To filter regions based on the highest sales and allow users to specify the number of regions shown, you should perform these actions in order:

  Answer area:

  Create an integer data type parameter named Param1.

  Drag Region to the Filters shelf.

  Configure a Top filter by field. Use Param1 and filter by the sum of Sales. To create a dynamic filter that lets users choose the number of regions to display, you need to use a parameter and a top filter. A parameter is a user-defined variable

  that can be used in calculations, filters, and reference lines. A top filter is a type of filter that shows only the top or bottom N values based on a specified field or expression. In this question, you want to filter regions based on the highest sales.

  You also want users to be able to specify the number of regions shown. To achieve this, you need to follow these steps:

  First, you need to create an integer data type parameter named Param1. This parameter will allow users to enter a number that will determine how many regions to show. You can create a parameter by right-clicking on the Data pane and

  selecting Create Parameter. Then, you need to specify the name, data type, current value, and allowable values for the parameter. In this case, you can choose Integer as the data type, 10 as the current value, and All as the allowable values.

  You also need to show the parameter control by right-clicking on the parameter and selecting Show Parameter Control. This will display a slider or a text box where users can enter or adjust the parameter value. Next, you need to drag Region

  to the Filters shelf. This will open the Filter dialog box, where you can choose how to filter the Region field. You can filter by general, wildcard, condition, or top. In this case, you want to filter by top, so you need to select the Top tab.

  Finally, you need to configure a top filter by field. Use Param1 and filter by the sum of Sales. This will filter the Region field by showing only the top N regions based on the sum of Sales, where N is the value of the parameter Param1. You can

  configure a top filter by field by selecting By field in the Top tab, then choosing the parameter Param1 from the drop-down list, and selecting the aggregation function Sum and the field Sales from the other drop-down lists. This will create a

  filter expression that looks like this: Top Param1 by SUM(Sales). By following these steps, you will create a filter that shows only the regions with the highest sales, and allows users to change the number of regions shown by adjusting the

  parameter value.

  References:

  Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Filtering Data" Tableau Help: Parameters

  Tableau Help: Top Filters

• Question 40:

  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 m order? (Place the three correct options in order.)

  Select and Place:

  

  Correct Answer: