Answer-first summary for fast verification
Answer: Increased query complexity and overhead due to the requirement for joins to retrieve related data.
Normalized data models utilize lookup tables to minimize data redundancy and ensure consistency. However, the primary trade-off is that queries become more complex and potentially slower, as they must perform additional joins at runtime to aggregate related information that would otherwise be pre-joined in a denormalized model.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When implementing a normalized data model within Delta Lake, what is a significant trade-off associated with the use of lookup tables?
A
Enhanced query performance resulting from a reduction in necessary join operations.
B
The risk of losing historical data integrity whenever updates are applied to the lookup sources.
C
Increased query complexity and overhead due to the requirement for joins to retrieve related data.
D
Inherent limitations in scalability due to the inability to partition small lookup tables.
No comments yet.