Implement Data Access by Using Azure Cosmos DB for NoSQL SDKs DP-420 Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   Which HTTP status code is returned when an optimistic concurrency check fails in Azure Cosmos DB?

   • A412 Precondition Failed
   • B409 Conflict
   • C500 Internal Server Error
   • D429 Too Many Requests
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A mobile app backend uses Azure Cosmos DB for NoSQL to serve a feed of social media posts. The feed query can return many items, and the backend needs to send the results to the client in chunks. The team wants to allow the client to request the next chunk without re-running the entire query. What should the backend do?

   • AUse a stored procedure to generate a unique page ID for each chunk.
   • BReturn the last item's ID to the client and use a WHERE clause to fetch items after that ID.
   • CReturn the query metrics to the client and let the client re-run the query with a different page size.
   • DReturn the continuation token from the query response to the client, and accept it back in the next request to pass to the SDK.
   Reveal Solution Discussion Select an answer first
4. 18expert · hard

   A developer is optimizing a query that joins two containers in Azure Cosmos DB for NoSQL. The query is slow and consumes many RUs. The developer wants to identify whether the query is using indexes or performing a cross-partition scan. They also want to see the RU breakdown. Which approach should they use?

   • AUse the ETag of the response to determine if the query used an index.
   • BEnable query metrics and analyze the 'Document Load Count' and 'Query Preparation Time' metrics.
   • CUse a continuation token to measure the number of pages and estimate the RU cost.
   • DUse the query's activity ID to trace the query in Azure Monitor.
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   What does a 429 status code indicate in Azure Cosmos DB?

   • AThe item was not found in the container.
   • BThe request was unauthorized.
   • CThe request rate has exceeded the provisioned throughput, and the request was throttled.
   • DThe request failed due to a network error.
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A batch job uses the Azure Cosmos DB for NoSQL SDK to insert items. During peak load, the SDK throws a CosmosException with status code 429. The job currently fails and must be restarted. The developer wants to handle this gracefully without manual intervention. What should the developer do?

   • AIncrease the container's RU/s to a very high value.
   • BUse a stored procedure to insert items.
   • CCatch the 429 exception and retry after the RetryAfter interval from the response.
   • DIgnore the 429 exception and continue with the next item.
   Reveal Solution Discussion Select an answer first