When would you choose to denormalize a database? What are the benefits and risks of denormalization?

Sample answer preview

Denormalization intentionally introduces data redundancy into a database to improve read performance. It is the reverse of normalization and involves combining tables, duplicating columns, or pre-computing values.