dp-900 Practice Question 1816
Exam: dp-900
Domain: Describe core data concepts
Topic: Describe data analytics core concepts
Difficulty: medium
Contoso Ltd needs to decide between using ETL or ELT for their data processing pipeline. The company wants to ensure that data transformations are performed after loading data into the target system. Which approach should they choose and why?
Answer Options
A
ETL because it transforms data before loading
B
ELT because it transforms data after loading
C
Data warehousing best practices
D
Hybrid ETL/ELT to balance transformation and loading
Correct Answer
B: ELT because it transforms data after loading
Explanation
The correct answer is to choose ELT because it allows for data transformations to be performed after the data has been loaded into the target system. This aligns with Contoso Ltd's requirement. Option A is incorrect because ETL involves transforming data before loading it into the target system, which does not meet their needs. Option C is irrelevant as it pertains to data warehousing strategies rather than ETL/ELT. Option D is incorrect because it suggests a hybrid approach, which is not aligned with their specific requirement.