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.