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

Questions 21–25

1. 21application · medium

   A developer is analyzing the RU consumption of a query in Azure Cosmos DB for NoSQL. The query returns 100 items and consumes 400 RUs. The developer wants to reduce the RU cost of this query. Which approach is most likely to reduce the RU cost?

   • AAdd a composite index on the properties used in the WHERE clause and ORDER BY.
   • BIncrease the page size of the query to return more items per page.
   • CUse the `x-ms-documentdb-query-enable-scan` header to force index usage.
   • DChange the query to use `SELECT *` instead of selecting specific properties.
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A team is designing an Azure Cosmos DB for NoSQL container for an IoT solution. The container stores sensor readings with properties like `deviceId`, `timestamp`, `temperature`, and `humidity`. The team frequently runs queries that filter on `deviceId` and `timestamp` to get time-series data. They also occasionally run queries on `temperature` to find outliers. The team wants to minimize RU consumption for the time-series queries while keeping the occasional temperature queries efficient. What indexing policy should they use?

   • AInclude all properties in the indexing policy to ensure all queries are efficient.
   • BUse a composite index on `deviceId` and `timestamp` and exclude all other properties.
   • CInclude only `deviceId` and `timestamp` in the indexing policy and exclude `temperature` and `humidity`.
   • DInclude `deviceId`, `timestamp`, and `temperature` in the indexing policy, and exclude `humidity`.
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   What is the primary purpose of the Azure Cosmos DB integrated cache?

   • ATo provide a backup of the data
   • BTo enforce consistency levels
   • CTo increase write throughput by buffering write operations
   • DTo reduce latency for read-heavy workloads by caching data in memory
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A developer wants to monitor the RU consumption of queries in a production Cosmos DB account. They need to identify queries that consume more than 100 RUs. Which Azure service should they use to set up this monitoring?

   • AAzure Application Insights
   • BAzure Monitor with diagnostic logs
   • CAzure Log Analytics
   • DAzure Storage Analytics
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   In Azure Cosmos DB, which component of the indexing policy determines whether a property is included in the index and how it is indexed?

   • AIncluded paths
   • BExcluded paths
   • CComposite indexes
   • DIndexing mode
   Reveal Solution Discussion Select an answer first