Optimize Query Performance When Using the API for Azure Cosmos DB for NoSQL DP-420 Practice Questions (Page 2)

Questions 6–10

1. 6expert · medium

   A company has a Cosmos DB account with integrated cache enabled. They have a global application with multiple read regions. The application runs the same query in all regions. The team notices that the cache hit ratio is low in some regions. What is the most likely cause?

   • AThe integrated cache is not enabled in those regions.
   • BThe queries are not using the same partition key in all regions.
   • CThe consistency level is different in those regions.
   • DThe cache is not warmed up in those regions.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   You want to retrieve the RU cost of a query using the Azure portal. Which blade or feature would you use?

   • AData Explorer
   • BConnection String blade
   • CMetrics blade
   • DAccess Control (IAM)
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   You run a query in Azure Cosmos DB and observe that it consumed 12.5 RUs. What does this value represent?

   • AThe total amount of request units charged for the query
   • BThe number of physical reads performed by the query
   • CThe number of logical partitions accessed by the query
   • DThe time in milliseconds the query took to execute
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which of the following operations in Azure Cosmos DB typically consumes the LEAST request units?

   • AA point read of a 1 KB item by ID and partition key
   • BA query that scans the entire container
   • CA cross-partition query with multiple filters
   • DA stored procedure that performs multiple operations
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A developer is optimizing queries in an Azure Cosmos DB for NoSQL container. They run a query that filters on a non-indexed property and observe that it consumes 1200 RUs. After adding an appropriate index, the same query consumes 300 RUs. The developer wants to estimate the RU cost of a similar query that filters on a different non-indexed property. What is the best way to estimate the RU cost?

   • AAssume the new query will also consume 1200 RUs because it is also non-indexed.
   • BUse the Azure Cosmos DB Query Execution Metrics to see the RU breakdown and extrapolate based on the number of documents scanned.
   • CRun the query once and read the `x-ms-request-charge` header to get the exact RU cost.
   • DUse the Azure Portal's 'Query Metrics' tab to see the RU charge for the last query and assume the new query will be similar.
   Reveal Solution Discussion Select an answer first