BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Tableau Exam TDA-C01 Topic 5 Question 38 Discussion

Actual exam question for Tableau's TDA-C01 exam
Question #: 38
Topic #: 5
[All TDA-C01 Questions]

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.

Show Suggested Answer Hide 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


Contribute your Thoughts:

Viola
6 months ago
I agree with Option B checks if 'Science' is contained in the Subject, which aligns with the instructions.
upvoted 0 times
...
Caitlin
6 months ago
But option B uses the CONTAINS function, which seems more appropriate for this scenario.
upvoted 0 times
...
Kaycee
6 months ago
I disagree. I believe the correct functions are A and D.
upvoted 0 times
...
Caitlin
7 months ago
I think the correct logical functions are A and B.
upvoted 0 times
...
Brandon
7 months ago
Option C is an interesting one, but I'm not sure it fully covers all the cases. The `ENDSWITH` function seems a bit too specific, and it doesn't handle the 'Science' case explicitly. I'd be worried about potential edge cases with that approach.
upvoted 0 times
Ayesha
6 months ago
User1
upvoted 0 times
...
...
Malcolm
7 months ago
I'm torn between A and D as well. They both seem to capture the conditions pretty well. The only thing that gives me pause with A is the `ELSEIF` statements – I'm not sure if that's the most efficient way to structure the logic. But I'd be curious to hear what the others think.
upvoted 0 times
...
Gilma
7 months ago
Haha, you know what they say, 'when in doubt, CASE it out!' I'm with you, Sabra. Option D looks like the most straightforward and clear-cut solution to me.
upvoted 0 times
...
Willard
7 months ago
Hmm, I'm not sure about option B. Doesn't that use a function that checks for the word 'Humanities' within the Subject field, rather than explicitly checking the values? I could be wrong, but that seems a bit too indirect.
upvoted 0 times
...
Dean
7 months ago
Yeah, I agree. The key is understanding how to properly use those conditional statements to achieve the desired outcome. I'm curious to see what the other candidates think.
upvoted 0 times
...
Sabra
8 months ago
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
...

Save Cancel