A data lake applies structure only when data is READ for analysis, while a warehouse enforces structure on WRITE. What are these called?
A.Schema-on-read vs schema-on-write
Correct terminology pair.
B.Normalization vs denormalization
Normalization is table design within relational schemas.
C.Indexing vs partitioning
Indexing/partitioning are physical storage optimizations.
D.ACID vs BASE
ACID/BASE describe transaction consistency models.
Why this answer
Schema-on-read (lakes): store raw, interpret at query time — flexible, handles any format. Schema-on-write (warehouses): enforce structure on ingest — guarantees consistency, faster predictable queries.
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