Question

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

Accepted Answer

iif(subscription.notEquals("Lite") || subscription.notEqualsl "Standard") || subscription.notEquatsCPro'). 'Standard', subscription)

Answer

iif(subscription.equals("Lite") &&subscriptiorvequ3ls("Standard") && sub$ctiption.eqoals("Pro"). subscription. el$e("5tandard"))

Answer

iif(subscription.noiEquals(*Lite" || "Standard" || "Pro"), subscription, subscription, replacestrf "Standard"))

Answer

iif(subscription.equals("Lite") || subscription.equals("Standard") || subscriptionequalsfPro"). subscription. "Standard")

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…

Take the free AD0-E600 practice test

Other AD0-E600 practice questions