Design a Data Partitioning Strategy for Azure Cosmos DB for NoSQL DP-420 Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   A container stores user profiles. Each profile has a unique UserId, a Country, and a LastLoginDate. The application performs point reads by UserId and also runs reports that filter by Country. Which partition key is most suitable for this dataset and workload?

   • AUserId
   • BCountry
   • CLastLoginDate
   • DA composite of Country and LastLoginDate
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A social media app stores posts with fields: userId, postId, timestamp, and visibility (public/private). The workload is write-heavy, and the most common query is 'get all public posts for a user'. Which partition key provides the best write distribution and query efficiency?

   • AUse postId as the partition key.
   • BUse visibility as the partition key.
   • CUse userId as the partition key.
   • DUse timestamp as the partition key.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   A container has a partition key that causes most write operations to target a single logical partition. What is the likely effect on throughput?

   • AThe write operations will fail because a single logical partition cannot handle more than 10,000 RUs
   • BThe physical partition containing that logical partition may become a hot partition, causing throttling even if the container has sufficient RU capacity
   • CThe container will automatically increase its provisioned throughput to handle the load
   • DThe write operations will be distributed evenly across all physical partitions
   Reveal Solution Discussion Select an answer first
5. 14expert · hard

   A retail chain stores sales transactions. The current partition key is storeId. The company runs two workloads: (1) real-time lookups of a single transaction by transactionId, and (2) daily sales reports per store. The daily reports are slow and expensive. You need to optimize both workloads. What is the best partitioning strategy?

   • AUse storeId as the partition key for the main container and create a secondary container partitioned by transactionId for lookups
   • BUse transactionId as the partition key for the main container and create a secondary container partitioned by storeId for reports
   • CUse a synthetic partition key of storeId_transactionId
   • DKeep storeId as the partition key and add a composite index on transactionId
   Reveal Solution Discussion Select an answer first
6. 15application · hard

   A multi-tenant SaaS application stores documents for each tenant. Each tenant has many users, and each user has many records. The most common queries are: (1) all records for a user, (2) all users for a tenant. Which hierarchical partition key design best supports both query patterns?

   • APartition key: /tenantId, and store all users in a separate container.
   • BPartition key: /tenantId//userId (hierarchical partition key).
   • CPartition key: /tenantId, with a secondary index on /userId.
   • DPartition key: /userId, with a secondary index on /tenantId.
   Reveal Solution Discussion Select an answer first