A destination must not receive unnecessary sensitive fields. Source transformations are feasible before loading and latency is acceptable. Which integration pattern best matches?

Choose the single best answer.

A.ETL that removes or transforms the sensitive fields before final loading
B.Full-copy replication with no transformation because all SQL data is safe
C.Purview classification alone as automatic field removal
D.ELT that first exposes every sensitive raw field to unrestricted destination users

Show the answer and explanation

✓ Correct answer

ETL that removes or transforms the sensitive fields before final loading

ETL transforms before final destination load and can reduce sensitive exposure. An unrestricted raw ELT landing conflicts with the stated policy. Copying and classification do not themselves remove fields or enforce the intended transformation. Source guide: PDF page 32.

Read the source reference

This item is flagged for content review.

Read and review here, or open the app to practise and save your results on this device.

Practise in the app

Unofficial study aid; not affiliated with or endorsed by Microsoft. Original practice questions are not real examination questions and do not guarantee an exam result.