
Ultimate access to all questions.
Consider a scenario where you have a large dataset of customer transactions that you need to optimize for querying using Delta Lake. You decide to apply partitioning, z-ordering, bloom filters, and adjust file sizes. Describe in detail how you would choose the appropriate partitioning column, implement z-ordering, apply bloom filters, and determine optimal file sizes for this dataset to enhance query performance.
A
Partition by transaction date, z-order by customer ID, apply bloom filters on transaction amount, and set file size to 128 MB.
B
Partition by customer ID, z-order by transaction date, apply bloom filters on customer ID, and set file size to 256 MB.
C
Partition by transaction amount, z-order by transaction date, apply bloom filters on transaction date, and set file size to 64 MB.
D
Partition by transaction type, z-order by transaction amount, apply bloom filters on transaction type, and set file size to 512 MB.