nerdexam
Microsoft

DP-900 · Question #123

Drag and Drop Question Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process. Where does…

The correct answer is The CRM system; The data warehouse; The data warehouse. In an ELT (Extract, Load, Transform) process, the Extract stage pulls raw data directly from the source system - the CRM system - so processing occurs there. The Load stage moves that raw data into the destination - the data warehouse - where it is stored as-is. The Transform…

Submitted by asante_acc· Mar 30, 2026Describe core data concepts and data processing pipelines (e.g., Microsoft DP-900 Azure Data Fundamentals - Core Data Concepts)

Question

Drag and Drop Question Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:

Exhibit

DP-900 question #123 exhibit

Answer Area

Drag items

An in-memory data integration toolThe CRM systemThe data warehouse

Correct arrangement

  • The CRM system
  • The data warehouse
  • The data warehouse

Explanation

In an ELT (Extract, Load, Transform) process, the Extract stage pulls raw data directly from the source system - the CRM system - so processing occurs there. The Load stage moves that raw data into the destination - the data warehouse - where it is stored as-is. The Transform stage also occurs in the data warehouse, because ELT's key differentiator is that transformation happens inside the target system (leveraging its compute power) rather than in an intermediate tool. This is what distinguishes ELT from ETL, where transformation happens before loading.

Topics

#ELT vs ETL#Data Integration#Data Warehouse#Data Processing Stages

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-900 Practice