Microsoft DP-420 Practice Exams
Last updated on Nov 16,2026- Exam Code: DP-420
- Exam Name: Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB
- Certification Provider: Microsoft
- Latest update: Nov 16,2026
HOTSPOT
You have three containers in an Azure Cosmos DB Core (SQL) API account as shown in the following table.

You have the following Azure functions:
– A function named Fn1 that reads the change feed of cn1
– A function named Fn2 that reads the change feed of cn2
– A function named Fn3 that reads the change feed of cn3
You perform the following actions:
– Delete an item named item1 from cn1.
– Update an item named item2 in cn2.
For an item named item3 in cn3, update the item time to live to 3,600 seconds.
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 have a container named container1 in an Azure Cosmos DB Core (SQL) API account.
You need to provide a user named User1 with the ability to insert items into container1 by using role-based access control (RBAC). The solution must use the principle of least privilege.
Which roles should you assign to User1?
- A . CosmosDB Operator only
- B . DocumentDB Account Contributor and Cosmos DB Built-in Data Contributor
- C . DocumentDB Account Contributor only
- D . Cosmos DB Built-in Data Contributor only
HOTSPOT
You configure a backup for an Azure Cosmos DB for NoSQL account as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

HOTSPOT
You plan to create an Azure Cosmos DB container named account that will contain items in the following format.

You need to define a query that will return the ids of all accounts that have ever recorded a negative value for balance.
How should you complete the query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

HOTSPOT
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The container1 container has 120 GB of data.
The following is a sample of a document in container1.

The orderId property is used as the partition key.
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 have an Azure Cosmos DB for NoSQL account. The account hosts a container that has the change feed enabled. You are building an app by using the Azure Cosmos DB SDK. The app will read items from the change feed by using a pull model. You need to ensure that multiple threads can read the change feed in parallel.
What should you include?
- A . the changeFeedStartFew value
- B . the Pagesize value
- C . the FeedRange value
- D . a stream-based iterator
You have an Azure Cosmos DB Core (SQL) API account.
You run the following query against a container in the account.
SELECT
IS_NUMBER("1234") AS A,
IS_NUMBER(1234) AS B,
IS_NUMBER({prop: 1234}) AS C
What is the output of the query?
- A . [{"A": false, "B": true, "C": false}]
- B . [{"A": true, "B": false, "C": true}]
- C . [{"A": true, "B": true, "C": false}]
- D . [{"A": true, "B": true, "C": true}]
You have a database named db1in an Azure Cosmos DB for NoSQL account named account 1. You need to write JSON data to db1 by using Azure Stream Analytics. The solution must minimize costs.
Which should you do before you can use db1 as an output of Stream Analytics?
- A . in account, add a private endpoint.
- B . In db1, create containers that have a custom indexing policy and analytical store disabled.
- C . In account, enable a dedicated gateway.
- D . In db1, create containers that have an automatic indexing policy and analytical store enabled.
HOTSPOT
You have an on-premises network.
You have an Azure subscription that contains an Azure Cosmos DB account named account1 and an Azure virtual network named VNet1. VNet1 contains two virtual machines named VM1 and VM2. VNet1 is connected to the on-premises network by using a Site-to-Site (S2S) VPN.
You need to meet the following requirements:
• Block access to the public endpoint of account1.
• Allow only VM1 to access account1.
What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

You have an application that queries an Azure Cosmos 06 for NoSQL account.
You discover that the following two queries run frequently,
![]()
You need to minimize the request units (RUs) consumed by reads and writes.
What should you create?
- A . a composite index for (name DESC, time stamp ASC)
- B . a composite index for (name ASC, time stamp DESC)
- C . a composite index for (name ASC time stamp ASC) and a composite index for (name, time stamp disc)
- D . a composite index for (name ASC, time stamp ASC)

