
Ultimate access to all questions.
In the context of designing a scalable and efficient data pipeline for a global e-commerce platform, which approach is most widely recognized for managing data transformations to ensure data is ready for analysis in a data warehouse? Consider the need for handling large volumes of data, minimizing latency, and ensuring data quality. Choose the best option.
A
LET (Load, Extract, Transform) - A method where data is first loaded into the target system, then extracted and transformed.
B
ELT (Extract, Load, Transform) - A method where data is extracted from sources, loaded into the target system, and then transformed.
C
ETL (Extract, Transform, Load) - A method where data is extracted from sources, transformed to meet business needs, and then loaded into the target system.
D
TLE (Transform, Load, Extract) - A method where data is transformed before being loaded into the target system and then extracted for analysis.