Microsoft

DP-900 practice question 3

Microsoft Azure Data Fundamentals · free question 3 of 20

Question

To complete the sentence, select the appropriate option in the answer area.

Explanation

In ETL, data is transformed by a separate engine, often using staging tables, before it is loaded into the destination, so the data arrives at the target already processed. Needing a target store powerful enough to transform data describes ELT, where transformation happens inside the target. ETL is often used precisely because source and target schemas differ, and the target does not have to be a relational database.

Practice the whole free set

Answer all 20 free DP-900 questions with instant feedback, or unlock all 322 questions with Learn and Exam modes.