Explanation:
Option B is correct because in many cases, denormalized data models can significantly improve query performance and simplify data access, which is often critical for lookup tables used in retail applications.
Ultimate access to all questions.
No comments yet.
You are designing a data model for a retail company that requires lookup tables for product information. Describe the trade-offs between using a normalized data model versus a denormalized data model for these lookup tables and explain which one you would choose and why.
A
Choose a normalized data model to reduce data redundancy and improve data integrity.
B
Choose a denormalized data model to improve query performance and simplify data access.
C
Use a combination of both normalized and denormalized models to balance redundancy and performance.
D
Avoid using lookup tables altogether to simplify the data model.