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

Catina

3 months ago

I believe formula C) and A) are not correct because they don't check if sales are greater than $50,000

upvoted 0 times

...

Mila

3 months ago

I agree with you, the IIF function in formula B) is used for logical conditions

upvoted 0 times

...

3 months ago

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

upvoted 0 times

Joanna

2 months ago

Absolutely, [Sales] > 50000 is clear and gets the job done.

upvoted 0 times

...

Hubert

3 months ago

Yes, I prefer straightforward formulas too. It makes it easier to understand.

upvoted 0 times

...

Janessa

3 months ago

I agree, simplicity is key. [Sales] > 50000 is straightforward.

upvoted 0 times

...

3 months ago

I agree, the IIF function is the best choice for this scenario.

upvoted 0 times

...