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

Correct Answer:

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. References:
Create a Simple Calculated Field - Tableau
MAX Function - Tableau
Tableau Certified Data Analyst Study Guide

Comment: *

Name: *

Email: *

Verification: *

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

Correct Answer:

Explanation:
A screenshot of a computer Description automatically generated

To calculate the month to date value of the prior year, you need to filter the order date to be between the first day of the same month of the previous year and the same day of the previous year. You can use the calculated fields [Calc1] and [Calc2] to get these dates. [Calc1] returns the date that is one year before today, and [Calc2] returns the date that is the first day of the month of [Calc1]. By using these fields in the filter condition, you can get the desired result.
References:
Finding the Month-to-Date Values for the Prior Year
[DATEADD Function]
[DATETRUNC Function]

Comment: *

Name: *

Email: *

Verification: *

You have the following dashboard that contains two visualizations.

You want to show only visualization at time. Users must be able to switch between visualizations.
What should you me?

• A.Worksheet actions
• B.Dashboard actions
• C.A parameter and a calculated filed
• D.Showhide buttons

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

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

Correct Answer:

1 - Specify Employee Name as the join key
2 - Open both data sources in Tableau Desktop
3 - Join both datasets and select the join type

Comment: *

Name: *

Email: *

Verification: *