Explanation:
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.
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.