Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
An extract, transform, and load (ETL) process requires... (DP-900)
To complete the sentence, select the appropriate option in the answer area.
An extract, transform, and load (ETL) process requires.
A) a matching schema in the data source and the data target.
B) a target data store powerful enough to transform data.
C) data that is fully processed before being loaded to the target data store.
D) that the data target be a relational database.
Solution
Correct answer: C) data that is fully processed before being loaded to the target data store.
In the ETL process, data is typically extracted from source systems, transformed according to business rules or requirements, and then loaded into the target data store.
The transformation phase involves cleaning, restructuring, and enriching the data to meet the standards and needs of the target system.
The data is indeed fully processed during the transformation phase before being loaded into the target data store to ensure that it aligns with the structure and requirements of the destination system.
This ensures that the data in the target data store is accurate, consistent, and ready for analysis or reporting.
Category: Describe an analytics workload on Azure