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

Questions 1–5

1. 1application · medium

   A company runs an Azure Cosmos DB for NoSQL container that stores user profile data. The container has a high write throughput, and the application occasionally runs queries that filter on `email` and `lastLogin`. The team is considering switching the indexing mode to Lazy to reduce write RU cost. What is the main risk they should consider?

   • AThe container will not support point reads because the index is not updated.
   • BLazy indexing will increase the RU cost of writes because the index is updated in the background.
   • CQueries may return stale data because the index is updated asynchronously.
   • DThe indexing mode cannot be changed back to Consistent without recreating the container.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which Azure Cosmos DB feature allows you to cache point reads and queries to improve performance?

   • AMaterialized views
   • BStored procedures
   • CIntegrated cache
   • DChange feed
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A company runs an Azure Cosmos DB for NoSQL container with a dedicated gateway. They want to enable the integrated cache to reduce RU consumption for repeated queries. The container uses session consistency. What is the minimum configuration required?

   • AChange the consistency level to Eventual to enable the integrated cache.
   • BCreate a new container with the `EnableIntegratedCache` flag set to true.
   • CUse the Azure Portal to enable the integrated cache under the 'Networking' blade.
   • DSet the `IntegratedCacheMaxAge` property on the container to a value greater than zero.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which Azure Cosmos DB SDK response property contains the request unit (RU) charge for a point operation or query?

   • ASessionToken
   • BActivityId
   • CRequestCharge
   • DETag
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A company runs an Azure Cosmos DB for NoSQL container that serves a dashboard application. The dashboard queries the same set of items frequently, and the queries are consuming a significant amount of RUs. The company wants to reduce latency and RU consumption for these repeated queries without changing the consistency level. What should you implement?

   • AChange the indexing policy to exclude all properties to reduce RU cost.
   • BUse a materialized view to pre-aggregate the data and query the view instead.
   • CIncrease the provisioned throughput of the container to handle the query load.
   • DEnable the integrated cache on the container and configure a max age for cached queries.
   Reveal Solution Discussion Select an answer first