Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
For a large fact table containing sales transactions in a lakehouse, which design consideration most effectively improves query performance?
A
Normalize sales data into multiple tables to reduce the size of the fact table.
B
Store the fact table in a columnar format without partitioning or clustering.
C
Partition the table by transaction date and cluster by product ID.
D
Denormalize related dimensions into the fact table to avoid join operations.
