Intermediate
System Design
Q63 / 100
What is the purpose of "database denormalization" in high-read systems, and what trade-off does it introduce?
Correct! Well done.
Incorrect.
The correct answer is A) Denormalization duplicates data to reduce expensive joins and speed up reads, at the cost of increased storage and more complex updates to keep duplicated data consistent
A
Correct Answer
Denormalization duplicates data to reduce expensive joins and speed up reads, at the cost of increased storage and more complex updates to keep duplicated data consistent
Explanation
By storing redundant copies of related data together, denormalization avoids costly joins for reads, but requires extra care to keep all copies in sync during writes.
Progress
63/100