Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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.