Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
You are designing a data model for a healthcare application that requires lookup tables for patient 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.
Simulated
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.
Comments
Loading comments...