Free Certified Tableau Data Analyst Exam Braindumps
Certified Tableau Data Analyst Questions 51–55 (page: 12)

Updated On: 10-Feb-2026

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?

  1. Drag Discount to Color on the Marks card
  2. Convert Discount to Discrete
  3. Set Discount to Dual Axis
  4. Drag Discount to the Columns shelf

Answer(s): C

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.


Reference:

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



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

  1. SUM{[Sales]) IN (50000)
  2. IIF(SUM< [Sales] )>50000, TRUE, FALSE)
  3. MAX< [Sales], 50000)
  4. [Sales] > 50000

Answer(s): B,D

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.


Reference:

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



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.

  1. ZN ([Profits])
  2. ISNULL ([Profits])
  3. IFNULL [(profits] ,0)
  4. IF [Profits] != null then [Profits] END

Answer(s): A,C

Explanation:

Both the ZN and IFNULL functions in Tableau can be used to replace NULL values with zeros. The ZN function converts NULL to zero directly, while the IFNULL function allows you to specify that NULL should be replaced with zero. Both will result in showing zero for any NULL values in the Profits field.


Reference:

https://help.tableau.com/current/pro/desktop/en- us/functions_functions_logical.htm#IFNULL https://help.tableau.com/current/pro/desktop/en- us/functions_functions_logical.htm#IF https://help.tableau.com/current/pro/desktop/en- us/functions_functions_logical.htm#ZN https://help.tableau.com/current/pro/desktop/en- us/functions_functions_logical.htm#ISNULL



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

  1. .png
  2. .html
  3. .xlsx
  4. .txt
  5. .pptx
  6. .csv

Answer(s): A,C,E

Explanation:

Tableau provides various options to export data from a worksheet. The formats available are typically those that are best suited for visualization or further data analysis. The options include:
.png for exporting images of the visualizations
.xlsx for exporting data in a format that can be opened with Microsoft Excel .pptx for creating PowerPoint presentations with the visualization embedded These formats are designed to facilitate sharing and presenting the insights derived from Tableau visualizations, or for conducting further analysis in tools like Excel.



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



  1. See Explanation for the Answer.

Answer(s): A

Explanation:



Viewing page 12 of 36
Viewing questions 56 - 60 out of 127 questions


Post your Comments and Discuss Salesforce Certified Tableau Data Analyst exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!