Summer Certification Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: force70

Salesforce Certified Tableau Data Analyst Analytics-DA-201 Question # 36 Topic 4 Discussion

Salesforce Certified Tableau Data Analyst Analytics-DA-201 Question # 36 Topic 4 Discussion

Analytics-DA-201 Exam Topic 4 Question 36 Discussion:
Question #: 36
Topic #: 4

You have the following dataset.

Analytics-DA-201 Question 36

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.


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 ' Science ' THEN ' Sciences '

WHEN ' English ' THEN ' Humanities '

WHEN ' Social Studies ' THEN ' Humanities '

End


Get Premium Analytics-DA-201 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.