Answer-first summary for fast verification
Answer: Increased complexity in query logic due to the requirement for frequent join operations to retrieve related data.
Lookup tables are central to normalized data models because they reduce data redundancy and ensure data integrity. However, the trade-off is an increase in query complexity, as users must perform additional joins to combine these tables with fact tables to obtain a complete view of the data.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When implementing a normalized data model within Delta Lake, what is a primary trade-off associated with the use of lookup tables?
A
Scalability limitations arising from the inability to apply partitioning to smaller lookup tables.
B
Permanent loss of historical data caused by overwriting values in lookup tables.
C
Increased complexity in query logic due to the requirement for frequent join operations to retrieve related data.
D
Improved query performance resulting from a significant reduction in necessary join operations.
No comments yet.