A Data Analyst has the following dataset:The analyst wants to create a new calculated dimension...

Salesforce Analytics-DA-201 Question Answer

A Data Analyst has the following dataset:

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.)

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

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

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

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

END

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

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

CASE [Subject]

WHEN ' Computer Science ' THEN ' Sciences '

WHEN ' English ' THEN ' Humanities '

WHEN ' Social Studies ' THEN ' Humanities '

END

Analytics-DA-201 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"