Answer-first summary for fast verification
Answer: Partition by customer ID and purchase date
Partitioning by customer ID and purchase date allows for efficient analysis of customer behavior and sales trends. This strategy also supports personalized marketing efforts by grouping data based on individual customer transactions.
Author: LeetQuiz Editorial Team
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
No comments yet.