nerdexam
Microsoft

DP-900 · Question #170

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 three stages map as follows: Extract occurs at the source system (the CRM system), where raw data is pulled directly from the operational database. Load and Transform both occur at the data warehouse - data is first loaded into…

Submitted by anna_se· Mar 30, 2026Describe core data concepts and data processing patterns including ELT/ETL pipelines - typically aligned with Microsoft DP-900 (Azure Data Fundamentals) or similar foundational data certification domains.

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 #170 exhibit

Answer Area

Drag items

A standalone data analysis 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 three stages map as follows: Extract occurs at the source system (the CRM system), where raw data is pulled directly from the operational database. Load and Transform both occur at the data warehouse - data is first loaded into the warehouse in its raw form, and then transformation (cleaning, reshaping, aggregating) happens inside the data warehouse using its own processing power. This contrasts with ETL, where transformation happens in a separate staging/middleware tool before loading.

Topics

#ELT vs ETL#Data Warehousing#Data Integration#Azure Synapse Analytics

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-900 Practice