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 social media applications.
Ultimate access to all questions.
You are designing a data model for a social media application that requires lookup tables for user profiles. 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.
No comments yet.