Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You are designing a data processing system for a retail company that requires analyzing customer purchase patterns. The data needs to be partitioned to optimize query performance and support efficient data retrieval. What partitioning strategy would you recommend, and how would you implement it in Azure Data Lake Storage Gen2?
A
Implement a partition strategy based on the customer's age, as it is the most important attribute for query performance.
B
Create a partition strategy based on the purchase date and time, allowing for efficient querying of data within specific time ranges.
C
Use a round-robin partitioning method to distribute the data evenly across multiple partitions, regardless of the data's characteristics.
D
Do not implement any partition strategy, as the customer purchase data does not require optimization for query performance.