
Ultimate access to all questions.
You are tasked with implementing a partition strategy for a retail dataset that includes sales data, customer profiles, and product information. The data needs to support various analytical queries, including sales trend analysis and customer behavior insights. What partition strategy would you recommend?
A
Partition by customer ID and purchase date
B
Partition by product category and sales amount
C
Partition by store location and purchase date
D
Partition by purchase date and time