Free Tableau TDA-C01 Exam Dumps Questions & Answers

The following table displays the row-level data in a Tableau data source:

A Data Analyst creates this calculated field:
SUM(IF [Item] = 'A' THEN [Sales] END) / COUNT([Order ID])
What is the result of this aggregate calculation?

• A.An error
• B.50
• C.12
• D.15

In a worksheet, you have a calculated column named YTD Sales that uses the following formula.
[Order Date] <= TODAY () AND DATETBUNC {"year", [Order Dace]) = DATETPUNC)"year", TODAY(J) You want to create a calculated column named Exclude Current Month that will be dragged to the Filters shell. Exclude Current Month will exclude the current month values from YTD Sales.
How should you complete the formula for Exclude Current Month? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

Correct Answer:

Explanation:

You are the owner of an alert.
You receive an email notification that the alert was suspended
From where can you resume the suspended alert?

• A.The Data Source page of Tableau Desktop
• B.The Notification area of Tableau Prep
• C.The Shared with Ma page
• D.The My Content area of Tableau web pages

A Data Analyst wants to create the following table in a view:

Which function should the analyst use to create the Position column?

• A.INDEX
• B.FIRST
• C.RANK
• D.LAST

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