DP-900 Question 33

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 1

  YES/NO/YES

• 1

  Extract, transform, and load (ETL) can reduce the transfer of sensitive data to destination systems. - True Reason: ETL performs transformations before loading, so sensitive data can be filtered or masked before it reaches the destination. Extract, load, and transform (ELT) transforms data by using a compute resource independent of the source system and destination system. - False Reason: ELT typically uses the destination system’s compute resources (e.g., a data warehouse) for transformations, not an independent resource. Extract, load, and transform (ELT) minimizes the time it takes to copy large volumes of data to destination systems. - True Reason: ELT loads raw data first without waiting for transformations, which speeds up initial data transfer for large datasets.

• 2

  Sentence one, Yes - ETL transforms the data before loading it into the destination system, which allows for filtering or masking sensitive data before transfer. Sentence two, No - In ELT, data is first loaded into the destination system and then transformations occur within the destination system itself, typically using its computing resources. Sentence three, Yes - ELT loads data first and then transforms it in the destination system, allowing for faster data ingestion, especially when dealing with large datasets.