You are designing a Windows Azure application that will use Windows Azure Table storage.
The application will allow teams of users to collaborate on projects.
Each user is a member of only one team. You have the following requirements:
Ensure that each user can efficiently query records related to his or her team’s projects.
Minimize data access latency.
You need to recommend an approach for partitioning table storage entities.
What should you recommend?
A.
Partition by user.
B.
Partition by team.
C.
Partition by project.
D.
Partition by the current date.