Question 1
A financial services firm is ingesting sensitive customer data from an on-premise data warehouse into Data Cloud via the MuleSoft Anypoint Connector. A requirement is to mask the middle digits of all Social Security Number (SSN) fields during ingestion before the data is stored in a Data Lake Object (DLO). Which Data Cloud feature is the most efficient and secure tool for this transformation?
Answer and explanation
Correct answer: C
Batch Data Transforms are designed for complex, large-scale transformations on data at rest after it has landed in the DLO. Using a Library function allows for reusable, complex logic like PII masking to be defined once and applied across multiple transforms, which is efficient and maintainable. Calculated Insights operate on DMOs, not DLOs during ingestion. Streaming Data Transformations act on data in-flight but are more suited for real-time event data, not large batch loads from a data warehouse. Formula fields on the DMO are applied after ingestion and do not mask the raw data in the DLO.