
Ultimate access to all questions.
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.