Intermediate
System Design
Q66 / 100
What is the purpose of "database normalization" versus "denormalization" trade-off in system design?
Correct! Well done.
Incorrect.
The correct answer is A) Normalization reduces redundancy and improves write consistency at the cost of more complex reads (joins); denormalization improves read performance at the cost of redundancy and write complexity
A
Correct Answer
Normalization reduces redundancy and improves write consistency at the cost of more complex reads (joins); denormalization improves read performance at the cost of redundancy and write complexity
Explanation
Choosing between normalization and denormalization depends on the read/write profile of the application — OLTP systems often favor normalization, while read-heavy analytical systems may favor denormalization.
Progress
66/100