What is denormalization, and when might it be used in a database design?
- Increasing data consistency in a database
- Introducing redundancy for performance reasons
- Reducing redundancy in a database by adding tables
- Removing duplicate records from a database
Denormalization involves intentionally introducing redundancy into a database design for performance optimization purposes. It may be used when read performance is critical or when data retrieval needs are complex.
Loading...
Related Quiz
- What is the purpose of outlier detection in data cleansing?
- What are some potential drawbacks of denormalization compared to normalization?
- How does metadata management facilitate data governance through data lineage?
- Which factor is not considered when selecting a data loading strategy?
- In the ETL process, data is extracted from multiple sources such as ________.