Tableau Exam TDA-C01 Topic 5 Question 65 Discussion

Actual exam question for Tableau's TDA-C01 exam

Question #: 65
Topic #: 5

You have a dataset that contains sates dat

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

ASUM{[Sales]) IN (50000)

BIIF(SUM< [Sales] )>50000, TRUE, FALSE)

CMAX< [Sales], 50000)

D[Sales] > 50000
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

Show Suggested Answer

Suggested Answer: B, D

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:

by Twanna at May 02, 2025, 05:31 AM

Limited Time Offer

25%

Off

Get Premium TDA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Felicidad

1 days ago

I'm going with both B and D. Gotta cover all the bases, you know?

upvoted 0 times

...

Curtis

3 days ago

D. [Sales] > 50000 is also a great option. Sometimes simpler is better.

upvoted 0 times

...

Devon

7 days ago

B) IIF(SUM([Sales]) > 50000, TRUE, FALSE) is the way to go! It's clear and straightforward.

upvoted 0 times

...