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

Questions 1–5

1. 1foundation · easy

   An application needs to update a customer's profile and their recent orders in a single transaction. Which partition key design would enable this transaction to be efficient?

   • AUse CustomerId as the partition key for both the profile and orders containers
   • BUse a random partition key for orders to distribute load
   • CUse the same partition key for all items in the container
   • DUse OrderId as the partition key for orders and CustomerId for profiles
   Reveal Solution Discussion Select an answer first
2. 2expert · hard

   A news website stores article views with fields: articleId, category, viewDate, and viewCount. The partition key is articleId. Some articles go viral and receive millions of views, while others receive few. The system is experiencing throttling on the viral articles' partitions. Which solution best addresses the hot-partition problem while preserving the ability to query views for a specific article?

   • AUse articleId as the partition key and increase throughput to 100,000 RU/s.
   • BUse viewCount as the partition key.
   • CUse category as the partition key.
   • DUse a synthetic partition key combining articleId and a date bucket (e.g., yyyy-MM-dd).
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   A query in Azure Cosmos DB for NoSQL includes a filter on the partition key property. How does this affect the query's cost?

   • AIt increases the cost because the partition key adds extra processing
   • BIt makes the query fail if the partition key is not indexed
   • CIt has no effect on cost because all queries scan all partitions
   • DIt reduces the cost because the query is scoped to a single logical partition
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A logistics company stores shipment tracking events in a Cosmos DB container. The current partition key is shipmentId. The application frequently queries all events for a specific carrier (e.g., 'FedEx') over the last 30 days. These queries are slow and consume many RUs. You need to reduce the cost of the carrier-based queries without changing the application's write pattern. What should you do?

   • AAdd a composite index on (carrier, timestamp)
   • BChange the partition key of the existing container to carrier
   • CCreate a second container with carrier as the partition key and use a change feed to populate it
   • DUse a synthetic partition key of carrier_shipmentId
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A telemetry system writes one document per IoT device every minute. Each document includes deviceId, region, timestamp, and a nested readings array. The workload is write-heavy, and queries always filter by deviceId and a time range. Which partition key design minimizes cross-partition queries and provides the best write distribution?

   • AUse timestamp as the partition key.
   • BUse deviceId as the partition key.
   • CUse region as the partition key.
   • DUse a synthetic key combining deviceId and region.
   Reveal Solution Discussion Select an answer first