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 targetsystem 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 alreadyreceived and prepare it for loading, and a loading process can begin working on the prepared data, ratherthan waiting for the entire extraction process to complete.