Answer-first summary for fast verification
Answer: Achieving an optimal balance between table denormalization and storage efficiency, tailored to specific query patterns.
The design of lookup tables in Delta Lake requires a strategic balance. While normalized designs improve storage efficiency and data integrity, denormalized designs can significantly accelerate query performance. The decision should be driven by the specific read/write patterns and performance requirements of the downstream applications.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When designing lookup tables within a Delta Lake architecture, which of the following represents a critical design consideration?
A
Utilizing high-cardinality keys as the primary mechanism to reduce the physical footprint of the table.
B
Storing all lookup tables exclusively in the Bronze layer to minimize processing overhead.
C
Achieving an optimal balance between table denormalization and storage efficiency, tailored to specific query patterns.
D
Disabling partitioning on all lookup tables to guarantee transactional consistency across the lakehouse.