
Answer-first summary for fast verification
Answer: Partition by user ID and call date
Partitioning by user ID and call date allows for efficient analysis of individual user behavior and network usage patterns. This strategy also supports real-time analysis by grouping data based on chronological order.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are working with a telecommunications company that needs to analyze call detail records (CDRs) for network optimization and customer behavior insights. The data includes call details, user profiles, and timestamps. What partition strategy would you implement to optimize the performance of analytical queries?
A
Partition by user ID and call date
B
Partition by call type and duration
C
Partition by geographical region and call date
D
Partition by call date and time