Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 13 discussion

Actual exam question from Microsoft's DP-900

Question #: 13
Topic #: 1

DRAG DROP -
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.
Select and Place:

Show Suggested Answer

Suggested Answer:

Box 1: The CRM system -
Data is extracted from the CRM system.

Box 2: The data warehouse -
Data is loaded to the data warehouse.
Box 3: An in-memory data integration tool
The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

by Pranitanaik5 at April 2, 2021, 3:08 p.m.

Comments

Submit Cancel

JayRee

Highly Voted 4 years, 3 months ago

The answer is CRM - DWH - DWH. I got all the questions on analytics answered correctly in the exam.

upvoted 183 times

omw2wealth

3 years, 11 months ago

Is it possible to drag the same option twice? :)

upvoted 4 times

researched_answer_boi

3 years, 11 months ago

From the question: "Each location may be used once, more than once, or not at all.", so yep.

upvoted 15 times

...

notem

4 years ago

Agree! Go to https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl In the ELT pipeline, the transformation occurs in the target data store. Instead of using a separate transformation engine, the processing capabilities of the target data store are used to transform data.

upvoted 26 times

...

ANath

Highly Voted 4 years, 3 months ago

This question is related to ELT(Extract-Load-Transform) not ETL (Extract-Transform-Load). In ELT, transformation happens on Target. So, Load and Transform should happen on 'Data Warehouse'. The answer given here is for ETL not for ELT.

upvoted 42 times

S320

4 years, 1 month ago

I agree. The link to the MS site should be this sub-part further down the page: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl#extract-load-and-transform-elt

upvoted 8 times

...

man5484

Most Recent 8 months ago

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.

upvoted 2 times

...

HackIT

9 months, 2 weeks ago

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

upvoted 1 times

...

AGTraining

1 year, 4 months ago

crm datawarehouse in memory data

upvoted 1 times

...

ff09375

1 year, 6 months ago

FWIW, GPT 4 confirms CRM DWH DWH

upvoted 1 times

...

sdg2844

1 year, 7 months ago

I am wondering if there are two correct answers here, because with ELT, you actually extract > Load > Transform > Load that transformation somewhere else. So technically both DWH and in-memory data are theoretically correct.

upvoted 1 times

otapi

1 year, 5 months ago

The Transform can happen right in the DWH, why would you load the data 2nd time to somewhere else? It is possible to add as many extra load and transform as you wish, but that will not be an efficient ELT.

upvoted 2 times

...

akhil5432

1 year, 11 months ago

crm datawarehouse in memory data

upvoted 1 times

...

TestTurtle468

2 years, 3 months ago

On the following website: https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl, the diagram in the result is an example of ETL, but the question discusses ELT. Is this correct, or am I thinking to much on this question? Please advise and thanks.

upvoted 1 times

...

chiiiweiii

2 years, 4 months ago

Correct Answer.

upvoted 1 times

...

Joanna0

2 years, 4 months ago

This is ELT. CRM - EDW - EDW is the correct answer.

upvoted 3 times

...

Tonnie85

2 years, 8 months ago

For ELT, the correct answer is CRM-DWH-DWH https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl Extract, load, and transform (ELT) differs from ETL solely in where the transformation takes place. In the ELT pipeline, the transformation occurs in the target data store. Instead of using a separate transformation engine, the processing capabilities of the target data store are used to transform data.

upvoted 3 times

...