AD0-E600 practice question 3 of 10

A data engineer is ingesting time-series data in CSV format from a CRM system. The source data contains a "subscription" field that contains what…

Full set: 50 questions
A data engineer is ingesting time-series data in CSV format from a CRM system. The source data contains a "subscription" field that contains what level of subscription the customer has purchased. The data is ingested into a target field called "subscriptionLevel". which is an enum field that accepts the following values: "Lite*. "Standard", and "Pro’’. The data engineer knows that the CSV files contain some rows that do not conform to the above enum. Instead of rejecting those rows, the data engineer wants to transform non-conforming fields to "Standard". Which mapping function(s) will accomplish this?
Answer options
A: iif(subscription.equals("Lite") &&subscriptiorvequ3ls("Standard") && sub$ctiption.eqoals("Pro"). subscription. el$e("5tandard"))
B: iif(subscription.noiEquals(*Lite" || "Standard" || "Pro"), subscription, subscription, replacestrf "Standard"))
C: iif(subscription.notEquals("Lite") || subscription.notEqualsl "Standard") || subscription.notEquatsCPro'). 'Standard', subscription) Correct answer
D: iif(subscription.equals("Lite") || subscription.equals("Standard") || subscriptionequalsfPro"). subscription. "Standard")
Correct Answer:
C. iif(subscription.notEquals("Lite") || subscription.notEqualsl "Standard") || subscription.notEquatsCPro'). 'Standard', subscription)
Explanation

you can use Data Prep functions to compute and calculate values based on what is entered in source fields. The iif function returns one value if a condition is true and another value if it is false. https://experienceleague.adobe.com/docs/experience-platform/data-prep/functions.html?lang=en

Keep practicing

Take the free AD0-E600 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test

More questions

Other AD0-E600 practice questions

Scroll to Top