Consider a dataset of customer feedback from an e-commerce platform, which includes columns like feedback_id, customer_id, rating, 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 feedback_id, as it is likely that queries will often filter by specific feedback entries._

11.4%

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

46.7%

Partition by rating, as it is likely that queries will often filter by feedback ratings.

17.5%

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

24.4%

Databricks Certified Data Engineer - Professional