
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.