Free Microsoft Azure DP-420 Actual Exam Questions
The questions for this exam were last updated on January 7, 2026
Dumps Box (DumpsBox) offers up-to-date practice exam questions for DP-420 certification exam which are developed and validated by Microsoft subject domain experts certified in Microsoft Azure DP-420 . These practice questions are update regularly as we keep an eye on any recent changes in DP-420 syllabus, and when there is update our team quickly adjusts the questions. This commitment to providing the best quality exam prep material to certification aspirants is what makes DumpsBox.com the best certification exam prep website. On top of that, our strong, yet strictly moderated, community based feedback keeps the content clean and current. Each question has helpful community discussion that provides it extra perspective and introduces helpful resources for better exam preparation. This also saves students from other outdated practice questions or illicit exam dumps that can have adverse affects on career. Browse through our Microsoft Azure DP-420 exam questions and pass your exam on first try.
Question No. 1
You have an Azure Cosmos DB for NoSQL account.
You need to create an Azure Monitor query that lists recent modifications to the regional failover
policy.
Which Azure Monitor table should you query?
You need to create an Azure Monitor query that lists recent modifications to the regional failover
policy.
Which Azure Monitor table should you query?
Select one option, then reveal solution.
Question No. 2
HOTSPOT
You have the indexing policy shown in the following exhibit.
Use the drop-down menus to select the answer choice that answers each question based on the
information presented in the graphic.
NOTE: Each correct selection is worth one point.
You have the indexing policy shown in the following exhibit.
Use the drop-down menus to select the answer choice that answers each question based on the
information presented in the graphic.
NOTE: Each correct selection is worth one point.
Question No. 3
You have a database in an Azure Cosmos DB Core (SQL) API account.
You need to create an Azure function that will access the database to retrieve records based on a
variable named accountnumber. The solution must protect against SQL injection attacks.
How should you define the command statement in the function?
You need to create an Azure function that will access the database to retrieve records based on a
variable named accountnumber. The solution must protect against SQL injection attacks.
How should you define the command statement in the function?
Select one option, then reveal solution.
Question No. 4
You are designing an Azure Cosmos DB Core (SQL) API solution to store data from IoT devices. Writes
from the devices will be occur every second.
The following is a sample of the data.
You need to select a partition key that meets the following requirements for writes:
Minimizes the partition skew
Avoids capacity limits
Avoids hot partitions
What should you do?
from the devices will be occur every second.
The following is a sample of the data.
You need to select a partition key that meets the following requirements for writes:
Minimizes the partition skew
Avoids capacity limits
Avoids hot partitions
What should you do?
Select one option, then reveal solution.
Question No. 5
HOTSPOT
You have an Azure Cosmos DB Core (SQL) API account named account1.
You have the Azure virtual networks and subnets shown in the following table.
The vnet1 and vnet2 networks are connected by using a virtual network peer.
The Firewall and virtual network settings for account1 are configured as shown in the exhibit.
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 Core (SQL) API account named account1.
You have the Azure virtual networks and subnets shown in the following table.
The vnet1 and vnet2 networks are connected by using a virtual network peer.
The Firewall and virtual network settings for account1 are configured as shown in the exhibit.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Question No. 6
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?
Which action can address the application updates issue without affecting the functionality of the
application?
Select one option, then reveal solution.
Question No. 7
HOTSPOT
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 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.
Question No. 8
HOTSPOT
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account.
The following is a sample of a document in container1.
{
"studentId": "631282",
"firstName": "James",
"lastName": "Smith",
"enrollmentYear": 1990,
"isActivelyEnrolled": true,
"address": {
"street": "",
"city": "",
"stateProvince": "",
"postal": "",
}
}
The container1 container has the following indexing policy.
{
"indexingMode": "consistent",
"includePaths": [
{
"path": "/*"
},
{
"path": "/address/city/?"
}
],
"excludePaths": [
{
"path": "/address/*"
},
{
"path": "/firstName/?"
}
]
}
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.
The following is a sample of a document in container1.
{
"studentId": "631282",
"firstName": "James",
"lastName": "Smith",
"enrollmentYear": 1990,
"isActivelyEnrolled": true,
"address": {
"street": "",
"city": "",
"stateProvince": "",
"postal": "",
}
}
The container1 container has the following indexing policy.
{
"indexingMode": "consistent",
"includePaths": [
{
"path": "/*"
},
{
"path": "/address/city/?"
}
],
"excludePaths": [
{
"path": "/address/*"
},
{
"path": "/firstName/?"
}
]
}
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Question No. 9
You have an Azure Cosmos DB Core (SQL) API account that is used by 10 web apps.
You need to analyze the data stored in the account by using Apache Spark to create machine learning
models. The solution must NOT affect the performance of the web apps.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to analyze the data stored in the account by using Apache Spark to create machine learning
models. The solution must NOT affect the performance of the web apps.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Select all that apply, then reveal solution.
Question No. 10
HOTSPOT
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. You define and
implement an encryption policy by using 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.
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. You define and
implement an encryption policy by using 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.
Question No. 11
HOTSPOT
You are developing an application that will connect to an Azure Cosmos DB for NoSQL account. The
account has a single readme region and one agonal read region. The regions are configured for
automatic failover.
The account has the following connect strings. (Line numbers are included for reference only.)
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 are developing an application that will connect to an Azure Cosmos DB for NoSQL account. The
account has a single readme region and one agonal read region. The regions are configured for
automatic failover.
The account has the following connect strings. (Line numbers are included for reference only.)
For each of the following statements, select Yes if the statement is true. otherwise, select No.
NOTE: Each correct selection is worth one point.
Question No. 12
You need to create a data store for a directory of small and medium-sized businesses (SMBs). The
data store must meet the following requirements:
* Store companies and the users employed by them. Each company will have less than 1,000 users.
* Some users have data that is greater than 2 KB.
* Associate each user to only one company.
* Provide the ability to browse by company.
* Provide the ability to browse the users by company.
* Whenever a company or user profile is selected, show a details page for the company and all the
related users.
* Be optimized for reading data.
Which design should you implement to optimize the data store for reading data?
data store must meet the following requirements:
* Store companies and the users employed by them. Each company will have less than 1,000 users.
* Some users have data that is greater than 2 KB.
* Associate each user to only one company.
* Provide the ability to browse by company.
* Provide the ability to browse the users by company.
* Whenever a company or user profile is selected, show a details page for the company and all the
related users.
* Be optimized for reading data.
Which design should you implement to optimize the data store for reading data?
Select one option, then reveal solution.
Question No. 13
You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Core (SQL)
API account. The data from a container named telemetry must be added to a Kafka topic named iot.
The solution must store the data in a compact binary format.
Which three configuration items should you include in the solution? Each correct answer presents
part of the solution.
NOTE: Each correct selection is worth one point.
API account. The data from a container named telemetry must be added to a Kafka topic named iot.
The solution must store the data in a compact binary format.
Which three configuration items should you include in the solution? Each correct answer presents
part of the solution.
NOTE: Each correct selection is worth one point.
Select all that apply, then reveal solution.
Question No. 14
HOTSPOT
You plan to deploy two Azure Cosmos DB Core (SQL) API accounts that will each contain a single
database. The accounts will be configured as shown in the following table.
How should you provision the containers within each account to minimize costs? To answer, select
the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You plan to deploy two Azure Cosmos DB Core (SQL) API accounts that will each contain a single
database. The accounts will be configured as shown in the following table.
How should you provision the containers within each account to minimize costs? To answer, select
the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question No. 15
HOTSPOT
You have a container in an Azure Cosmos DB Core (SQL) API account.
You need to use the Azure Cosmos DB SDK to replace a document by using optimistic concurrency.
What should you include in the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You have a container in an Azure Cosmos DB Core (SQL) API account.
You need to use the Azure Cosmos DB SDK to replace a document by using optimistic concurrency.
What should you include in the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.