Which accurately contrasts ETL and ELT in modern analytics pipelines?
A.ETL transforms before loading; ELT loads raw data first and transforms in the target
Correct ordering distinction.
B.ETL is for streaming; ELT is for batch
Both can be batch or streaming — the difference is WHERE transform happens.
C.ELT transforms before loading; ETL transforms after
Reversed — ELT loads first.
D.They are identical
The transform location genuinely differs.
Why this answer
ETL: Extract → Transform → Load (transform in a staging engine, load curated). ELT: Extract → Load → Transform (land raw in the lake/warehouse, transform with the target's compute — the modern lakehouse pattern).
Correct answer: A · Last reviewed 2026-11-05
Official AWS references
Practice this interactively
Answer without seeing the solution first in the Core Data Concepts practice session.
Practice Core Data Concepts