exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 26 discussion

Actual exam question from Microsoft's DP-900
Question #: 26
Topic #: 1
[All DP-900 Questions]

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 Hide 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: A standalone data analysis 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

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
jamorey
Highly Voted 3 years, 7 months ago
I think is CRM - DW -DW ¿is this de correct answer?
upvoted 174 times
bpxgeek
3 years, 1 month ago
Yes you are right it should be CRM-DW-DW
upvoted 11 times
...
durak
3 years, 5 months ago
Absolutely
upvoted 10 times
...
AngelJP
3 years, 2 months ago
Yes, sure
upvoted 6 times
...
Tonnie85
2 years, 6 months ago
Indeed...answer states for ETL, yet question specifies ELT
upvoted 5 times
...
...
Ezther
Highly Voted 3 years, 6 months ago
CRM-DW-DW, same question as 13
upvoted 52 times
wth1234
3 years, 4 months ago
this question refers to ELT the 13th question refers to ETL
upvoted 4 times
wth1234
3 years, 4 months ago
correction: you are right it does not refer to ETL oops same question
upvoted 4 times
...
...
rajat7878
3 years, 2 months ago
Agreed
upvoted 1 times
...
...
man5484
Most Recent 5 months, 2 weeks ago
The 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.
upvoted 2 times
...
cloudbaron
10 months, 4 weeks ago
CRM - DW- DW. " The key point with ELT is that the data store used to perform the transformation is the same data store where the data is ultimately consumed." Ref: https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
upvoted 1 times
...
AGTraining
1 year, 2 months ago
crm dw standalone
upvoted 1 times
...
Edgy_San
1 year, 2 months ago
The answer is correct. But the image is of an ETL process and the process in question and answer is about an an ELT. We answered this question correctly before and it had a link to read more on. Which I can't see it now, since I am here typing this.
upvoted 2 times
...
iza_li
1 year, 3 months ago
For ELT, the correct answer is CRM-DWH-DWH https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
upvoted 1 times
...
Ruesam
1 year, 6 months ago
The answer here is for ETL. Correct answer for ELT should be source, DW, then DW since DW has processing power that can fit both the T and L processes within it
upvoted 1 times
...
lol632
1 year, 6 months ago
It says ELT, where your loading and transformation both happens in the Data Warehouse.
upvoted 1 times
...
MannyJZ
1 year, 8 months ago
On exam today 08/08/23
upvoted 2 times
...
fafulka
1 year, 10 months ago
in exam 16/06/2023
upvoted 2 times
...
Dudures
2 years ago
Exam 04/15/2023
upvoted 4 times
...
chiiiweiii
2 years, 2 months ago
Correct Answer.
upvoted 1 times
...
Mohitsain
2 years, 3 months ago
1.CRM 2.DW 3.DW
upvoted 2 times
...
Stuurwiel1
2 years, 3 months ago
ELT> CRM> DW>DW ETL> CRM> DW> DAT https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
upvoted 2 times
...
cpalmier
2 years, 4 months ago
Pienso que es correcta la respuesta, si considero a Power BI. Power BI es una herramienta de análisis la cual puede hacer transformaciones.
upvoted 1 times
...
Dusica
2 years, 5 months ago
CRM, DW, DW
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago