DP-900 Question 26

Community Discussion

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

• 1

  Extract: The CRM system Extraction involves reading data from the source. The processing power to retrieve this data comes from the source system, the CRM. Load: The data warehouse Loading involves writing data into the destination. The processing for the write operation occurs at the Data Warehouse. Transform: The data warehouse In an ELT (Extract-Load-Transform) architecture, the transformation logic is executed by the target system's engine after the raw data has been loaded. Therefore, transformation occurs in the Data Warehouse. This is ELT not ETL.

• 1

  he CRM system, In the "Extract" phase, data is retrieved from the source system, which in this case is the CRM system. The data warehouse, In the "Load" phase, the extracted data is loaded into the target system, which is the data warehouse. The data warehouse, In an ELT process, the transformation of data occurs within the target system (data warehouse), leveraging its processing power for transformations.

• 1

  I think is CRM - DW -DW