Tableau Exam TDA-C01 Topic 5 Question 38 Discussion

Actual exam question for Tableau's TDA-C01 exam

Question #: 38
Topic #: 5

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.

AIF [Subject]- 'Science' THEN 'Sciences'
ELSEIF [Subject]='English' THEN 'Humanities'
ELSEIF [Subject]-'Social Studies' THEN 'Humanities'
ELSEIF [Subject]= 'Computer Science' THEN 'Sciences'
END

BIIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')

CIF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END

DCASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'
End

Show Suggested Answer

Suggested Answer: A, D

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

by Willow at Apr 13, 2024, 09:50 PM

Limited Time Offer

25%

This seems like a straightforward question, but I can see how it could trip some people up if they're not careful with the logical functions. I'm leaning towards either option A or D as the best solutions.

upvoted 0 times

...