DP-900 Question 13

Community Discussion

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

• 1

  CRM -> DWH -> DWH Ref: https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl#:~:text=In%20the%20ELT%20pipeline%2C%20the%20transformation%20occurs%20in%20the%20target%20data%20store Ref: https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl#:~:text=In%20the%20ELT%20pipeline%2C%20the%20transformation%20occurs%20in%20the%20target%20data%20store

• 2

  Extract: The CRM System Explanation: In the ELT process, data is extracted directly from the source system, which in this case is the CRM system. Load: The Data Warehouse Explanation: In an ELT process, data is loaded directly into the data warehouse without being transformed first. Transform: The Data Warehouse Explanation: In ELT, transformation occurs after data is loaded into the data warehouse, using the data warehouse’s processing capabilities to perform the transformations.

• 1

  Agree for ELT, load and Transform happens in target system which is DW.