A company has a Cosmos DB container with a high write rate. The current indexing policy indexes all fields. The team wants to reduce write RU cost while maintaining the ability to run queries on a specific field. They also need to ensure that queries are consistent. What is the best approach?

Disable indexing and use full scans for queries.

Increase the provisioned throughput to handle the write load.

Keep consistent indexing mode and exclude all fields except the query field from indexing.

Set the indexing mode to lazy and create a composite index on the query field.

A developer is configuring the integrated cache for an Azure Cosmos DB for NoSQL container. The container has a dedicated gateway and the developer wants to ensure that the cache is used for point reads and queries. What should they do?

Use the Azure Portal to enable the integrated cache under the 'Caching' blade.

Set the `ConsistencyLevel` to Strong to ensure the cache is used.

Set the `EnableIntegratedCache` flag to true in the connection string.

Set the `IntegratedCacheMaxAge` property to a value greater than zero on the container.

A developer is troubleshooting a query that is consuming a high number of RUs in Azure Cosmos DB for NoSQL. The query filters on a property that is indexed, but the RU cost is still high. The developer suspects the query is performing a cross-partition query. What is the best way to confirm this?

Check the `x-ms-request-charge` header to see if the RU cost is high.

Use the Query Execution Metrics to see the number of partitions that were accessed.

Use Azure Monitor metrics to see the total RU consumption for the container.

Check the query's `x-ms-documentdb-query-enable-scan` header to see if scans were enabled.

A developer is troubleshooting a slow query in Azure Cosmos DB for NoSQL. The query is consuming a high number of RUs. The developer wants to identify whether the query is using the index or performing a full scan. Which tool or metric should they use?

The `x-ms-documentdb-query-enable-scan` header to force index usage.

The Azure Monitor metrics for 'Total Request Units' to see the RU consumption trend.

The Query Execution Metrics in the Azure Portal or SDK, which include 'Index Lookup Time' and 'Document Load Time'.

The `x-ms-request-charge` header only, because it shows the total RU cost.

You want to reduce the storage overhead of the index in an Azure Cosmos DB container while still allowing queries on the 'status' property. What is the most appropriate indexing policy change?

Add a composite index on 'status'

Remove all included paths except '/status/?'

Add 'status' to the excluded paths

Microsoft Certified:Azure Cosmos DB Developer Specialty

Domain 4Objective 1

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

Part of the Optimize an Azure Cosmos DB solution domain, which makes up ~13% of our current practice bank. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~5–8 in this domain), expect 2–3 from this objective — we provide 30 practice questions to prepare you well beyond it. (estimate)

30questions here

6free pages

7concepts

Questions 26–30

26expert · medium
A company has a Cosmos DB container with a high write rate. The current indexing policy indexes all fields. The team wants to reduce write RU cost while maintaining the ability to run queries on a specific field. They also need to ensure that queries are consistent. What is the best approach?
Select an answer first
27application · medium
A developer is configuring the integrated cache for an Azure Cosmos DB for NoSQL container. The container has a dedicated gateway and the developer wants to ensure that the cache is used for point reads and queries. What should they do?
Select an answer first
28expert · hard
A developer is troubleshooting a query that is consuming a high number of RUs in Azure Cosmos DB for NoSQL. The query filters on a property that is indexed, but the RU cost is still high. The developer suspects the query is performing a cross-partition query. What is the best way to confirm this?
Select an answer first
29application · medium
A developer is troubleshooting a slow query in Azure Cosmos DB for NoSQL. The query is consuming a high number of RUs. The developer wants to identify whether the query is using the index or performing a full scan. Which tool or metric should they use?
Select an answer first
30foundation · easy
You want to reduce the storage overhead of the index in an Azure Cosmos DB container while still allowing queries on the 'status' property. What is the most appropriate indexing policy change?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DP-420

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-420” is a trademark of its owner, used for identification only.