ExpertAZ-305 · Question 25 · Domain 2.3: Recommend a data storage solution
You are designing an Azure Cosmos DB database for an e-commerce application. The database will store product catalog data. You need to select a partition key. The catalog has 10,000 categories and 5 million products. Queries almost always filter by 'CategoryId'. You need to ensure even distribution of storage and throughput. Which TWO statements describe the characteristics of a good partition key in this scenario? (Select TWO)
You are designing an Azure Cosmos DB database for an e-commerce application. The database will store product catalog data. You need to select a partition key. The catalog has 10,000 categories and 5 million products. Queries almost always filter by 'CategoryId'. You need to ensure even distribution of storage and throughput. Which TWO statements describe the characteristics of a good partition key in this scenario? (Select TWO)
Answer options:
It should have a high cardinality (many distinct values).
It should have a low cardinality (few distinct values).
It should be a property that is rarely used in queries.
It should be a property that appears frequently as a filter in queries.
It should be a property whose value changes frequently.
How to approach this question
Full Answer
Common mistakes
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 6
55 questions · hints · full answers · grading