Scenario: A database administrator is considering denormalizing certain tables to improve query performance. However, they are concerned about potential data redundancy. How would you advise them on mitigating this risk?

Option 4: Implement proper indexing - When denormalizing tables, it's crucial to implement proper indexing to mitigate the risk of data redundancy. Indexes help optimize query performance by facilitating efficient data retrieval. By creating indexes on the denormalized tables, the database administrator can ensure that queries execute swiftly while minimizing the impact of redundant data. Therefore, advising the administrator to implement proper indexing is the most appropriate way to mitigate the risk of data redundancy when denormalizing tables.