Consider a dataset of financial transactions that includes columns like transaction_id, customer_id, amount, and timestamp. Describe how you would choose the appropriate partitioning strategy for this dataset to optimize query performance, considering the typical query patterns and the size of the dataset.

Simulated

Partition by transaction_id, as it is likely that queries will often filter by specific transactions._

10.9%

Partition by customer_id, as it is likely that queries will often filter by individual customers._

24.2%

Partition by amount, as it is likely that queries will often filter by transaction amounts.

5.2%

Partition by timestamp, as it is likely that queries will often filter by time ranges.

59.7%

Databricks Certified Data Engineer - Professional