
Ultimate access to all questions.
Given a dataset of product sales from a retail chain, which includes columns like product_id, store_id, sales_amount, and timestamp. Describe how you would apply Delta Lake optimizations such as partitioning, z-ordering, and bloom filters to this dataset to enhance query performance. Consider the typical query patterns and the size of the dataset._
A
Partition by product_id, z-order by timestamp, apply bloom filters on sales_amount.
B
Partition by store_id, z-order by product_id, apply bloom filters on timestamp.
C
Partition by timestamp, z-order by sales_amount, apply bloom filters on store_id.
D
Partition by sales_amount, z-order by timestamp, apply bloom filters on product_id.