Databases · Junior · Question 39 of 75
What is denormalization?
- 1A mistake in schema design that must always be fixed
- 2Removing all foreign keys
- ✓Correct answer: Deliberately duplicating data (e.g. storing an order total) to make reads faster, at the cost of keeping copies in sync
Explanation
It's a trade-off for read-heavy workloads. The duplicate must be updated reliably, for example in the same transaction or by a trigger.