Question
Why does normalization improve transactional database design?
Tap to flip
Answer
It reduces redundancy and update anomalies.
Tap to flip back
Question
Why is a data lake useful for analytics with diverse data?
Tap to flip
Answer
It stores raw structured and unstructured data in native format.
Tap to flip back
Question
Why are OLTP databases usually normalized?
Tap to flip
Answer
They are optimized for frequent, day-to-day transactions.
Tap to flip back
Question
Why can ratio data support more statistical operations than nominal data?
Tap to flip
Answer
It has equal intervals and a true zero.
Tap to flip back