Tableau Tableau Certifications TDA-C01 Questions & Answers

• Question 81:

  DRAG DROP

  You have a table that contains the following data.

  

  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 82:

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

  Select and Place:

  

  Correct Answer:

  

  There are different ways to prepare the data in Tableau Prep, but one possible answer is:

  Answer area:

  Join the tables.

  Aggregate the data by Sales Team.

  Add the following filter to the Employees table: Sale Team - Team Alpha. To analyze sales trends over time for every sales team, you need to combine the data from the Orders and Employees tables. You can do this by joining the tables on

  the Rep ID column, which is a common identifier for both tables. This will create a single table with all the columns from both tables. Next, you need to aggregate the data by Sales Team, which is the level of analysis you want. You can do this

  by grouping the data by the Sales Team column and applying an aggregation function (such as sum, average, count, etc.) to the other columns that you want to measure (such as Total Amount, Rep Tenure, etc.). This will create a summary

  table with one row for each sales team and the aggregated values for the other columns. Finally, you need to filter the data to focus on a specific sales team, such as Team Alpha. You can do this by adding a filter to the Employees table and

  selecting only the rows where Sales Team equals Team Alpha. This will remove the rows for other sales teams and keep only the data for Team Alpha.

  References:

  [Tableau Certified Data Analyst Exam Prep Guide], page 9, section "Preparing Data"

  [Tableau Help: Join Your Data]

  [Tableau Help: Aggregate Your Data] [Tableau Help: Filter Your Data]

• Question 83:

  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 ?

  Hot Area:

  

  Correct Answer:

  

• Question 84:

  You have the following dashboard.

  

  When a user selects a only on the map the data on the bar chart must show only the data for the selected city. The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)

  Hot Area:

  

  Correct Answer:

  

• Question 85:

  You have the following visualization.

  

  Hot Area:

  

  Correct Answer:

  

• Question 86:

  You have a dataset that has four fields named Category. Profit Sates and Customer Name. You need to create the following visualization.

  

  Hot Area:

  

  Correct Answer:

  

• Question 87:

  You have two data sources that use the same schema One data source contains order data from 2019 and the other data source contains order data from 2020.

  You have a worksheet that shows the orders from 2019.

  You need to configure the worksheet to show the orders from 2020 without reloading the data.

  Which option should you select?

  Hot Area:

  

  Correct Answer:

  

• Question 88:

  HOTSPOT

  You have a data source that contains the following columns.

  

  You want to sort customers based on the most expensive orders.

  How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

  Hot Area:

  

  Correct Answer:

  

• Question 89:

  HOTSPOT

  You have a data set that contains three columns named Sales, Profit, and Quantity.

  You need to build the following scatter plot.

  

  Hot Area:

  

  Correct Answer:

  

  To build the scatter plot shown in the image, you need to place the Profit measure on the Rows shelf and the Sales measure on the Columns shelf. This will create a Cartesian chart with Profit as the y-axis and Sales as the x-axis. Then, you need to change the mark type to Circle on the Marks card. This will display the data points as circles that vary in size according to the Quantity measure. You can also add color or shape encoding to the marks to show additional dimensions or measures in the view. References: Build a Scatter Plot Understanding and Using Scatter Plots Scatter plot in Tableau

• Question 90:

  HOTSPOT

  You have the following visualization.

  

  You want the count of Returns displayed only for the first year in the table.

  How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

  Hot Area:

  

  Correct Answer:

  

  Explanation: we need to create a calculated field that displays the count of returns only for the first year in the table. To do this, we can use the following formula:

  IF FIRST () = 0 THEN COUNT (Returns) END

  This formula uses the FIRST () function, which returns the number of rows from the current row to the first row in the partition. If the current row is the first row, then FIRST () returns 0. The IF statement checks if this condition is true, and if so,

  it returns the count of returns for that row. Otherwise, it returns NULL.

  To complete the formula in the calculated field, you should select the following options from the drop-down menus:

  FIRST ()

  COUNT (Returns)

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