Spring Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Exam TDA-C01 All Questions
Exam TDA-C01 All Questions

View all questions & answers for the TDA-C01 exam

Tableau Certified Data Analyst TDA-C01 Question # 45 Topic 5 Discussion

TDA-C01 Exam Topic 5 Question 45 Discussion:
Question #: 45
Topic #: 5

A Data Analyst has the following dataset:

TDA-C01 Question 45

The analyst wants to create a new calculated dimension field named Category that meets the following conditions:

When Subject is Computer Science or Science, the Category must be Sciences.

When Subject is English or Social Studies, the Category must be Humanities.

Which two logical functions achieve this goal? (Choose two.)


A.

IF [Subject] = 'Science' THEN 'Sciences'

ELSEIF [Subject] = 'English' THEN 'Humanities'

ELSEIF [Subject] = 'Social Studies' THEN 'Humanities'

ELSEIF [Subject] = 'Computer Science' THEN 'Sciences'

END


B.

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


C.

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


D.

CASE [Subject]

WHEN 'Computer Science' THEN 'Sciences'

WHEN 'English' THEN 'Humanities'

WHEN 'Social Studies' THEN 'Humanities'

END


Get Premium TDA-C01 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.