
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.