Tableau TDA-C01 Online Practice Questions and Exam Preparation

Tableau TDA-C01 Online Questions & Answers

• Question 1:

  You have the following Map.

  

  You need the map to appear as shown in the following visualization.

  

  What should you do?

  A. Drag Location to Size on the Marks card.
  B. Change the opacity to 75%.
  C. Drag Population to Size on the Marks card.
  D. Change the mark type to Density.
  E. Change the mark type to Map.
  D. Change the mark type to Density.

  ---

  Explanation

  To create a map visualization that shows the concentration of data points in different locations, you need to change the mark type to Density. This will create a heatmap that uses color and size to indicate the density of the data points. You can also adjust the intensity and transparency of the density marks to suit your needs.

  References: The information is based on the following sources: Create Heatmaps that Show Trends or Density in Tableau Build a Simple Map - Tableau

• Question 2:

  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?

  

  

  Explanation

• Question 3:

  You have the following dataset:

  

  Which grouping option should you use in Tableau Prep to group all five names automatically?

  A. Pronunciation
  B. Spelling
  C. Manual Selection
  D. Common Characters
  D. Common Characters

  ---

  Explanation

  Common Characters: Find and group values that have letters or numbers in common. This option uses the ngram fingerprint algorithm that indexes words by their unique characters after removing punctuation, duplicates, and whitespace. This algorithm works for any supported language. This option isn't available for data roles. For example, this algorithm would match names that are represented as "John Smith" and "Smith, John" because they both generate the key "hijmnost". Since this algorithm doesn't consider pronunciation, the value "Tom Jhinois" would have the same key "hijmnost" and would also be included in the group.

• Question 4:

  You have a dataset that contains people and the awards they have won.

  

  Which formula should you use to get the number of different types of awards that have been won?

  A. COVAR({Award})
  B. COUNTD({Award})
  C. COUNTD {(NAME])
  D. MAX {(Award})
  E. INDEX()
  B. COUNTD({Award})

  ---

  Explanation

  To get the number of different types of awards that have been won, you should use the formula COUNTD({Award}). This formula will return the count of distinct values in the Award field, which are the different types of awards that have been won.

  The other options are not correct for this scenario. COVAR({Award}) is not a valid function in Tableau. MAX({Award}) will return the maximum value in the Award field, which may not be a type of award. INDEX() will return the index or rank of each row in a partition, which is not related to the types of awards.

  References: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#COUNTD https://help.tableau.com/current/pro/desktop/en-us/ functions_functions_tablecalculation.htm#INDEX

  The COUNTD function in Tableau calculates the number of distinct (unique) items in a field. When looking to get the number of different types of awards that have been won, the COUNTD([Award]) function will count each unique award name only once, regardless of how many times it appears in the dataset. This will return the total number of unique award types.

• Question 5:

  CORRECT TEXT

  Open the link to Book1 found on the desktop. Open the Line worksheet.

  Modify the chart to show only main and max values of both measures in each region.

  

  A. Check the steps below in explanation.
  B. PlaceHoder
  A. Check the steps below in explanation.

  ---

  Explanation

  To modify the chart to show only min and max values of both measures in each region, you need to do the following steps:

  Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the Line worksheet.

  Click on the Line tab at the bottom of the workbook to open the worksheet. You will see a line chart that shows the sales and profit for each month by region.

  Drag Month from the Columns shelf to Filters shelf. This will open a dialog box that allows you to filter by different criteria.

  Select Range of Dates from the dialog box. This will show you options to filter by a range of dates or values.

  Select Minimum and Maximum from the drop-down list next to Month. This will filter by the minimum and maximum values of Month for each region. You can also enter specific values or use the sliders to adjust the range.

  Click OK to apply the filter. You will see that the line chart now shows only min and max values of both measures in each region.

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

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

• Question 6:

  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. Convert Discount to Discrete
  C. Set Discount to Dual Axis
  D. Drag Discount to the Columns shelf
  C. Set Discount to Dual Axis

  ---

  Explanation

  To combine the lines to appear as shown in the second chart, you should set Discount to Dual Axis. Dual Axis is a feature that allows you to show two measures on two separate axes on one chart. You can create a dual axis by right-clicking on a measure on any shelf and selecting Dual Axis from the menu. This will create two axes on one chart and synchronize their scales.

  In this case, you want to show Profit and Discount on two separate axes on one chart. You can right-click on Discount on any shelf and select Dual Axis from the menu. This will create a dual axis chart that shows Profit and Discount as two lines with different colors.

  The other options are not correct for this scenario. Dragging Discount to Color on the Marks card will change the color of Profit based on Discount, but it will not show two lines. Converting Discount to Discrete will change Discount from a green pill to a blue pill, but it will not affect how it appears on the chart. Dragging Discount to Columns shelf will create two separate charts for Profit and Discount, but it will not combine them.

  References: https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures.htm https://help.tableau.com/current/pro/desktop/en-us/multiplemeasures_dualaxes.htm

• Question 7:

  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

  A. SUM{[Sales]) IN (50000)
  B. IIF(SUM< [Sales] )>50000, TRUE, FALSE)
  C. MAX< [Sales], 50000)
  D. [Sales] > 50000
  B. IIF(SUM< [Sales] )>50000, TRUE, FALSE)
  D. [Sales] > 50000

  ---

  Explanation

  The two formulas that will return a value of true if a month has sales greater than $50,000, otherwise the formula must return a value of false, are:

  B. IIF(SUM([Sales]) > 50000, TRUE, FALSE)

  D. [Sales] > 50000

  The IIF function is a logical function that returns one value if a condition is true, and another value if the condition is false. In this case, the condition is SUM([Sales]) > 50000, which means that the sum of sales for a month is greater than $50,000. The function will return TRUE if the condition is true, and FALSE if the condition is false.

  The comparison operator > is a logical operator that returns TRUE if the left operand is greater than the right operand, and FALSE otherwise. In this case, the operands are [Sales] and 50000, which means that the sales for a month are greater than $50,000. The operator will return TRUE if the sales are greater than $50,000, and FALSE otherwise.

  The other options are not correct for this scenario. The IN function is a logical function that returns TRUE if a value is in a set of values, and FALSE otherwise. In this case, the value is SUM([Sales]), which is not in the set of values (50000). The function will always return FALSE. The MAX function is an aggregation function that returns the maximum value in a field or expression. In this case, the field or expression is [Sales], 50000, which is not valid syntax. The function will return an error.

  References: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#IIF https://help.tableau.com/current/pro/desktop/en-us/operators.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#MAX

• Question 8:

  You want to create the following table in a view.

  

  Which function should you use to create the Position column?

  A. RANK
  B. FIRST
  C. INDKX
  D. LAST
  B. FIRST

  ---

  Explanation

  To create the Position column, you should use the FIRST () function. The FIRST () function returns the number of rows from the current row to the first row in the partition. For example, the first row in a partition will return 0, the second row

  will return -1, and so on. In this question, the partition is defined by the Segment field, and the table is sorted by the Sales field in descending order. Therefore, the Position column shows the offset of each row from the first row in each

  segment, based on the sales ranking.

  References:

  Tableau Certified Data Analyst Exam Prep Guide, page 11, section "Creating Calculated Fields"

  Tableau Help: FIRST Function

• Question 9:

  You create a worksheet named Sales by Region and hide the tide of the worksheet.

  You print the worksheet as a PDF and notice that the worksheet title appears.

  You need to prevent the title from appearing when you print the worksheet as a PDF.

  Which settings should configure from the File menu in Tableau Desktop?

  A. Page Setup
  B. Print
  C. Export As PowerPoint
  D. Share
  E. Export As Version
  A. Page Setup

  ---

  Explanation

  In Tableau Desktop, you can manage how worksheets appear when printed or exported as PDFs by configuring the Page Setup settings. This includes controlling whether titles, headers, or footers appear on the output. To prevent the worksheet title from appearing, you would adjust the options in the Page Setup dialog to deselect the title display.

• Question 10:

  You have a workbook that uses an extracted data source.

  You publish the workbook to Tableau Server.

  Which three actions can you perform from the Extract Refresh page in Tableau Server? Choose three.

  A. Run a refresh.
  B. Change the refresh from full to incremental.
  C. Change the priority of the refresh.
  D. Delete the refresh.
  E. Modify the frequency of the refresh.
  A. Run a refresh.
  C. Change the priority of the refresh.
  D. Delete the refresh.

  ---

  Explanation