Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 210 discussion

Actual exam question from Microsoft's DP-900

Question #: 210
Topic #: 1

DRAG DROP -
Match the processes to the appropriate scenarios.
To answer, drag the appropriate process from the column on the left to its scenario on the right. Each process may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:

Show Suggested Answer

Suggested Answer:

by fusioner at Sept. 1, 2022, 7:36 a.m.

Comments

Submit Cancel

KingChuang

Highly Voted 2 years, 9 months ago

Should be ETL,ELT,Data ingest

upvoted 103 times

Docxx

2 years, 9 months ago

This has more logic

upvoted 9 times

...

snowfox

2 years, 8 months ago

Totally agreed.

upvoted 8 times

...

SudeepDsouza

Highly Voted 2 years, 8 months ago

Should be ETL, ELT and Data Ingestion

upvoted 14 times

...

vivek_kol

Most Recent 8 months, 2 weeks ago

Correct answer should be ETL, ELT, DATA INGESTION

upvoted 1 times

...

profesorklaus

8 months, 2 weeks ago

ETL ELT Data Ingestion In first two there is a processing action. In a last one there is no processing at all

upvoted 1 times

...

Jikkuz

1 year ago

Why are more than half of the answers are incorrect in this set of questions. Getting totally confused after reading this exam questions.

upvoted 2 times

...

QeUtPat

1 year, 2 months ago

Please update the answer, its ETL, ELT and Data Ingestion

upvoted 1 times

...

Anuragsharma83

1 year, 7 months ago

ETL,ELT, Data Ingest

upvoted 2 times

...

srgopalkr

1 year, 10 months ago

I'd agree with the provided answer: 1. Data is Retrieved (Extract) and processed (Transformed) before being saved to a target system (Load). Answer is ETL 2. Data is saved to a target system (Ingestion) and then processed (Transformed). There is no extraction as such. Answer is Data Ingestion. 3. Data is Extracted from a source system (Extract) and then saved to a target system (Load). Perhaps Transformation will be done next, but NOT indicated here. Answer is ELT.

upvoted 2 times

Koteyko

1 year, 1 month ago

How is it possible to save data to a target system without previously extracting it from somewhere? "Extract" was rather omitted here as well as "Transformation" in the last.

upvoted 1 times

...