Question 3
To complete the sentence, select the appropriate option in the answer area.
Correct answer: To work with this question, an Exam Simulator is required.
Explanation:
In the ELT pipeline, the transformation occurs in the target data store. ELT only works well when the target system is powerful enough to transform the data efficiently. Incorrect Answers:The data does not need to be fully processed: Often, the three ETL phases are run in parallel to save time.For example, while data is being extracted, a transformation process could be working on data already received and prepare it for loading, and a loading process can begin working on the prepared data, rather than waiting for the entire extraction process to complete. The target does need to be a relational database. Reference: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. ELT only works well when the target system is powerful enough to transform the data efficiently.
Incorrect Answers:
The data does not need to be fully processed: Often, the three ETL phases are run in parallel to save time.
For example, while data is being extracted, a transformation process could be working on data already received and prepare it for loading, and a loading process can begin working on the prepared data, rather than waiting for the entire extraction process to complete.
The target does need to be a relational database.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl