Which partition key provides the most efficient throughput?

Your company is an online retailer that can have more than 100 million orders during a 24-hour period, 95 percent of which are placed between 16:30 and 17:00. All the orders are in US dollars.

The current product line contains the following three item categories:

– Games with 15,123 items

– Books with 35,312 items

– Pens with 6,234 items

You are designing an Azure Cosmos DB data solution for a collection named Orders Collection. The following documents is a typical order in Orders Collection.

Order Collection is expected to have a balanced read/write-intensive workload.

Which partition key provides the most efficient throughput?
A . Item/Category
B . OrderTime
C . Item/Currency
D . Item/id

View Answer

Answer: A

Explanation:

Choose a partition key that has a wide range of values and access patterns that are evenly spread across logical partitions. This helps spread the data and the activity in your container across the set of logical partitions, so that resources for data storage and throughput can be distributed across the logical partitions.

Choose a partition key that spreads the workload evenly across all partitions and evenly over time. Your choice of partition key should balance the need for efficient partition queries and transactions against the goal of distributing items across multiple partitions to achieve scalability.

Candidates for partition keys might include properties that appear frequently as a filter in your queries. Queries can be efficiently routed by including the partition key in the filter predicate.

References:

https://docs.microsoft.com/en-us/azure/cosmos-db/partitioning-overview#choose-partitionkey