Databricks Certified Data Engineer - Professional

Get started today

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.

Simulated

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.