Question
How does a data warehouse differ from OLTP storage?
Tap to flip
Answer
It is denormalized and optimized for analytics, not transactions.
Tap to flip back
Question
Why does a primary key matter in a relational database?
Tap to flip
Answer
It uniquely identifies each row and cannot be null.
Tap to flip back
Question
How does a foreign key support database integrity?
Tap to flip
Answer
It links to another table’s primary key and enforces referential integrity.
Tap to flip back
Question
Why would you use ETL when combining data from multiple sources?
Tap to flip
Answer
To clean, standardize, deduplicate, and load data into a target.
Tap to flip back