Free Certified Tableau Data Analyst Exam Braindumps
Certified Tableau Data Analyst Questions 81–85 (page: 18)

Updated On: 10-Feb-2026

DRAG DROP (Drag and Drop is not supported)
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.)

  1. See Explanation for the Answer.

Answer(s): A

Explanation:

To complete the formula, you should drag the option MAX from the list of options and drop it into the first blank space, and then drag the option [Sales] and drop it into the second blank space. The formula will look like this: Option (MAX) Option ([Sales]). This formula will calculate the maximum value of the sales field for each country. You can use this formula to create a calculated field that will show the highest sales amount for each country in your data source.


Reference:

Create a Simple Calculated Field - Tableau
MAX Function - Tableau
Tableau Certified Data Analyst Study Guide



You have the following dashboard that contains two sheets.



You want to minimize the whitespace between the sheets.

What should you configure?

  1. The background
  2. The position
  3. The padding
  4. The size
  5. The border

Answer(s): C

Explanation:

To minimize the whitespace between the sheets, you should configure the padding of the sheets and the dashboard. Padding is the amount of space between the edge of a sheet or dashboard and its content. You can adjust the padding by using the Layout tab in the Format pane. You can reduce the padding for each sheet by selecting the sheet and changing the values for the inner and outer padding. You can also reduce the padding for the dashboard by selecting the dashboard and changing the values for the outer padding. Reducing the padding will make the sheets and the dashboard more compact and eliminate unnecessary whitespace.


Reference:

Format Dashboards - Tableau
Tableau Certified Data Analyst Study Guide



You have the following tiled dashboard that has one sheet.



You want to replace the sheet with Sheet2.

What should you do?

  1. Select Sheet3 and click the Swap Sheet button next to Sheet2.
  2. Right-click Sheet2 and select Add to Dashboard.
  3. From the context menu of Sheet3, select Deselect.
  4. Drag Sheet2 to the dashboard.
  5. From the context menu of Sheet3, select Remove Dashboard Item.

Answer(s): D

Explanation:

In Tableau, to replace a sheet on a dashboard, you can simply drag the desired sheet (Sheet2 in this case) from the sheets list onto the dashboard where the current sheet (Sheet3) is. This will replace the existing visualization with the new one.



You are creating a new dashboard.

You need to add a button to the dashboard that allows users to export the dashboard as an image.

Which type of object should you use?

  1. Image
  2. Ask Data
  3. Extension
  4. Download
  5. Navigation

Answer(s): C

Explanation:

Extensions in Tableau are web-based programs that can interact with dashboards. To add a button that allows users to export the dashboard as an image, you would use an Extension object. This could be a custom extension designed to trigger the download of the dashboard view as an image.



You have the following dataset.



You want to create a new calculated dimension field named Category that meets the following conditions:
.
When Subject is Computer Science or Science, Category must be Sciences. .
When Subject is English or Social Studies, Category must be Humanities.
Which two logical functions achieve the goal? Choose two.

  1. IF [Subject]- 'Science' THEN 'Sciences'
    ELSEIF [Subject]='English' THEN 'Humanities'
    ELSEIF [Subject]-'Social Studies' THEN 'Humanities'
    ELSEIF [Subject]= 'Computer Science' THEN 'Sciences'
    END
  2. IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')
  3. IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
  4. CASE [Subject]
    WHEN 'Computer Science' THEN 'Sciences'
    WHEN 'Science' THEN 'Sciences'

    WHEN 'English' THEN 'Humanities'
    WHEN 'Social Studies' THEN 'Humanities'
    End

Answer(s): A,D

Explanation:

To create a new calculated dimension field named Category that meets the given conditions, you can use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF clauses to check the value of the Subject field and assign it to either `Sciences' or `Humanities'. Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will produce the same result, but the CASE function is more concise and easier to read. Option B is incorrect because it will assign `Humanities' to any subject that contains `Science' in its name, which is not the desired outcome. Option C is incorrect because it will only check if the subject ends with `Computer Science' and ignore the other subjects.


Reference:

Logical Functions - Tableau
Tableau Certified Data Analyst Study Guide



Viewing page 18 of 36
Viewing questions 86 - 90 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!