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

Questions 36–40

1. 36foundation · easy

   What is the purpose of pagination in Azure Cosmos DB queries?

   • ATo improve query performance by running the query on multiple partitions in parallel.
   • BTo automatically retry the query if it fails due to transient errors.
   • CTo ensure that the query returns results in a specific order.
   • DTo retrieve large result sets in manageable pages to avoid overwhelming the client or exceeding response size limits.
   Reveal Solution Discussion Select an answer first
2. 37expert · hard

   A developer is troubleshooting a slow query in Azure Cosmos DB for NoSQL. The query filters on a property that is not indexed. The developer enabled query metrics and sees that the query is consuming a high number of RUs and reading a large amount of data. What should the developer do to improve the query's performance?

   • AUse a stored procedure to run the query.
   • BAdd a composite index on the filtered property and the partition key.
   • CUse a point read instead of a query.
   • DIncrease the container's RU/s.
   Reveal Solution Discussion Select an answer first
4. 38foundation · easy

   What is the purpose of a session token in Azure Cosmos DB session consistency?

   • AIt allows a client to read its own writes by providing a token that represents the latest write seen by that session.
   • BIt is used to authenticate the client to the Azure Cosmos DB account.
   • CIt is used to enable cross-partition queries.
   • DIt is used to route requests to the correct physical partition.
   Reveal Solution Discussion Select an answer first
5. 39application · medium

   An IoT solution stores sensor readings in Azure Cosmos DB for NoSQL. Each reading has a timestamp and a deviceId. The team wants to automatically delete readings that are older than 30 days to save storage and reduce RU costs. They do not want to run a separate cleanup job. What should they do?

   • AUse a stored procedure to delete old items every day.
   • BSet a Time-to-Live (TTL) of 30 on each item when creating it.
   • CUse a query to find old items and delete them with a bulk operation.
   • DSet a default Time-to-Live (TTL) of 2592000 seconds on the container.
   Reveal Solution Discussion Select an answer first
6. 40expert · hard

   A collaborative editing application uses Azure Cosmos DB for NoSQL to store documents. Multiple users can edit the same document concurrently. The team wants to prevent lost updates but also wants to minimize the number of retries. They are considering using patch operations with optimistic concurrency control. Which approach should they take?

   • AUse a patch operation with a condition that checks the ETag, and retry the entire patch if the condition fails.
   • BUse a transactional batch that includes a read and a patch, and retry the batch if it fails.
   • CUse a replace operation with the full document and rely on the SDK's automatic retry for conflicts.
   • DUse a stored procedure that locks the document during the update.
   Reveal Solution Discussion Select an answer first