Free Practice Questions for the Microsoft Certified: Azure Cosmos DB Developer Specialty DP-420 Exam (2026 Updated)

You are troubleshooting the current issues caused by the application updates.

Which action can address the application updates issue without affecting the functionality of the application?

You have an Azure Cosmos DB for NoSQL account that uses the default consistency level. How can the consistency level be modified as part of a query request?

You plan to implement con-iot1 and con-iot2.

You need to configure the default Time to Live setting for each container. The solution must meet the loT telemetry requirements.

What should you configure? To answer, select the appropriate options in the answer NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1 and a Log Analytics workspace named Workspace1. Workspace 1 stores the logs of account1.

You need to identify which operations used the most request units per second (RU/s) during the last 24 hours.

How should you complete the query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point

You have an Azure Cosmos OB for NoSQL account configured for global distribution across four regions. At connection time, the SQL SDK needs to identify the optimal endpoint for reading and writing. Which two factors can influence the SDK? Each correct answer presents a complete solution NOTE- Each correct selection is worth one point.

You have a container m an Azure Cosmos DB for NoSQL account. The container stores data about families. Data about parents, children, and pets are stored as separate documents.

Each document contains the address of each family. Members of the same family share the same partition key named family Id

You need to update the address for each member of the same family that share the same address. The solution must meet the following requirements:

• Be atomic consistent isolated, and durable (ACID).

• Provide the lowest latency.

What should you do?

You have an Azure Cosmos DB container named owners. Each item in owners represents an owner and their pets. The following is a sample of the JSON

You are writing a query that will retrieve the average age of each pet owned by each owner, il the pet is older than two years.

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes 01 scroll to view content.

NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB for NoSQL database named DB1 that hosts a container named Contained. The partition key for Container! is /city.

You are developing a cloud-native app named App1 that will store customer information in DB1. App1 will perform transactional batch operations to update the items in Contained.

You need to configure App1 to meet the following requirements:

• Ensure that batch operations are rolled back if an item ' s ETag value has changed since the value was last read.

• Ensure that all operations in the batch apply to a single partition key value.

How should you complete the C# code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You provision Azure resources by using the following Azure Resource Manager (ARM) template.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result1 these questions will not appear in the review screen.

You have a database in an Azure Cosmos DB for NoSQL account that is configured for multi-region writes.

You need to use the Azure Cosmos OB SDK to implement the conflict resolution policy for a container. The solution must ensure that any conflicts are sent to the conflicts feed.

Solution: You set ConflictResolutionMode to Laswriterwins and you use the default settings for the policy.

Does this meet the goal?

You have a development environment that uses multiple Azure subscriptions.

You plan to deploy a single Azure Cosmos DB account that will contain a single database in each subscription.

You need to automate the deployment by using an Azure Resource Manager (ARM) template. The solution must meet the following requirements:

• Minimize Azure Cosmos DB-related charges.

• Maximize the available request units per second (RU/s) without increasing costs.

How should you complete the template? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

You have a database in an Azure Cosmos DB Core (SQL) API account.

You plan to create a container that will store employee data for 5,000 small businesses. Each business will have up to 25 employees. Each employee item will have an emailAddress value.

You need to ensure that the emailAddress value for each employee within the same company is unique.

To what should you set the partition key and the unique key? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an on-premises computer named Computer1 that runs Windows 11.

On Computer1, you install the Azure Cosmos DB Emulator by using the default settings. You need to connect to the API for NoSQL clients hosted by the emulator. What should you use?

You have an Azure Cosmos DB for NoSQL account that has multiple write regions.

You need to receive an alert when requests that target the database exceed the available request units per second (RU/s).

Which Azure Monitor signal should you use?

You have an Azure Cosmos DB database named databaset contains a container named container1. The container1 container store product data and has the following indexing policy.

Which path will be indexed?

You have the following Azure Resource Manager (ARM) template.

You plan to deploy the template in incremental mode.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named accounts In account1, you plan to create a container that will store the data items shown in the following table.

Each customer item will have customer sales by month values embedded.

The most executed query will return data for a matrix that aggregates the monthly sales ot each business category. The matrix will use customer business categories as columns and months as rows.

You need to configure the partition key for the container. The solution must minimize the request units (RUs) required to run the query.

Which property should you use for the partition key?

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1.

For account 1, you plan to implement an integrated gateway that will use the D4s SKU.

You need to optimize integrated gateway performance for point reads from account1. The solution must meet the following requirements:

• For new point reads, maximize how long returned items remain in the integrated cache.

• For new and repeating point reads, maximize the cost benefits of the integrated cache.

What should you do for each requirement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have the following query.

SELECT * FROM с

WHERE c.sensor = " TEMP1 "

AND c.value < 22

AND c.timestamp > = 1619146031231

You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by the query.

What should you recommend?

You have an Azure Cosmos DB for NoSQL database that hosts the containers shown in the following table.

You need to ensure that when a product name changes in the Products container, the product name changes in all orders that have NOT been shipped.

What should you implement?

You have an Azure Cosmos DB for NoSQL database named db1 that writes to multiple Azure regions. You need to test the performance of db1 in the secondary region. Which command should you run first?

You are designing an Azure Cosmos DB for NoSQL solution.

You plan to create a new container named Container1 that will store product data for automotive repair pans as shown in the following table.

The data will be stored in Container! as shown in the following table

You need to recommend a data partitioning solution for the database. The solution must spread the workload to minimize I/O contention.

Which column should you recommend for the physical partition key and the logical partition key? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Vou have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that hosts a container named Customers. Multi-region writes are allowed.

You execute the following C# code.

For each of the following statements, Select Yes if the statement is true, Otherwise, select No.

NOTE: Each correct selection is worth one point.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a container named container1 in an Azure Cosmos DB Core (SQL) API account.

You need to make the contents of container1 available as reference data for an Azure Stream Analytics job.

Solution: You create an Azure Synapse pipeline that uses Azure Cosmos DB Core (SQL) API as the input and Azure Blob Storage as the output.

Does this meet the goal?

You have an Azure Resource Manager (ARM) template that provisions Azure Cosmos DB accounts and databases. The accounts are deployed to a single Azure region. The databases have provisioned throughput configured. The name of the region, the type of database throughput, and the throughput value are defined as template parameters.

You need to modify some of the Azure Cosmos DB accounts and databases based on the following scenarios:

• Scenario 1: Add a read region and increase the database throughput.

• Scenario 2: Change the provisioned database throughput to autoscale.

The solution must minimize administrative effort and the duration of the modifications.

What should you use for each scenario? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named Account1 and an Azure key vault named Vault1.

You plan to enable customer-managed keys and use an encryption key stored in Vault1 to encrypt data at rest.

You need to configure Account1 to use the key from Vault1. The solution must ensure that Account1 continues to operate if the key is rotated in Vault1.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named accounts In account1, you create a container that has the following configurations:

• Partition key: CompanylD

• Composite unique key: UserName and EmailAddress

To the container, you plan to add the data items shown in the following table.

How many conflicts will occur?

You have an Azure Cosmos DB for NoSQL account named account! that has a periodic backup policy with a four-hour backup interval and an eight-hour retention period. The account account contains a single database named db1 and containers that have stored procedures.

An administrator deletes db1 accidentally.

You need to ensure that the contents of db1, including all of its items, is available as soon as possible.

How should you perform the procedure? To answer, drag the missing actions to the correct order. Each action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE Each correct selection is worth one point.

You have a multi-region Azure Cosmos DB account named account1 that has a default consistency level of strong.

You have an app named App1 that is configured to request a consistency level of session.

How will the read and write operations of App1 be handled? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB Core (SQL) account that has a single write region in West Europe.

database named db

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You need to recommend indexes for con-product and con-productVendor. The solution must meet the product catalog requirements and the business requirements.

Which type of index should you recommend for each container? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to provide a solution for the Azure Functions notifications following updates to con-product. The solution must meet the business requirements and the product catalog requirements.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You configure multi-region writes for account1.

You need to ensure that App1 supports the new configuration for account1. The solution must meet the business requirements and the product catalog requirements.

What should you do?

You need to select the capacity mode and scale configuration for account2 to support the planned changes and meet the business requirements. What should you select? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.