List of questions
Related questions
Question 35 - AD0-E600 discussion
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?
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)
D.
iif(subscription.equals("Lite") || subscription.equals("Standard") || subscriptionequalsfPro"). subscription. "Standard")
Your answer:
0 comments
Sorted by
Leave a comment first