Study Smarter for the DP-420 Exam with Our Free and Reliable DP-420 Exam Questions – Updated for 2025.

At Cert Empire, we are dedicated to providing the most accurate and up-to-date exam questions for students preparing for the Microsoft DP-420 Exam. To make preparation easier, we’ve made parts of our DP-420 exam resources free for everyone. You can practice as much as you like with Free DP-420 Practice Test.

Get DP-420 Exam Dumps

Microsoft DP-420 Free Exam Questions

Disclaimer

Please keep a note that the demo questions are not frequently updated. You may as well find them in open communities around the web. However, this demo is only to depict what sort of questions you may find in our original files.

Nonetheless, the premium exam dumps files are frequently updated and are based on the latest exam syllabus and real exam questions.

1 / 60

You have a database in an Azure Cosmos DB Core (SQL) API account. The database is backed up every two hours. You need to implement a solution that supports point-in-time restore. What should you do first?

Create a new account that has a periodic backup policy

Configure the Backup & Restore settings for the account

Enable Continuous Backup for the account

Configure the Point In Time Restore settings for the account

2 / 60

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 DB SDK to implement the conflict resolution policy for a container. The solution must ensure that any conflict sent to the conflict feed.

Solution: You set ConfilictResolutionMode to Custom. You Set ResolutionProcedures to a custom stored procedure. You configure the custom stored procedure to use the conflictingItems parameter to resolve conflict.

Does this meet the goal?

Yes

3 / 60

You have a container named container1 in an Azure Cosmos DB for NoSQL account named account1 that is set to the session default consistency level. The average size of an item in container1 is 20 KB. You have an application named App1 that uses the Azure Cosmos DB SDK and performs a point read on the same set of items in container1 every minute. You need to minimize the consumption of the request units (RUs) associated to the reads by App1. What should you do?

In App1, modify the connection policy settings

In App1, change the consistency level of read requests to consistent prefix

In account1, provision a dedicated gateway and integrated cache

In account1, change the default consistency level to bounded staleness

4 / 60

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 DB SDK to implement the conflict resolution policy for a container. The solution must ensure that any conflict sent to the conflict feed.

Solution: You set ConfilictResolutionMode to Custom and you use the default settings for the policy.

Does this meet the goal?

Yes

5 / 60

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?

CosmosDB Operator only

DocumentDB Account Contributor only

Cosmos DB Built-in Data Contributor only

DocumentDB Account Contributor and Cosmos DB Built-in Data Contributor

6 / 60

You need to implement a solution to meet the product catalog requirements. What should you do to implement the conflict resolution policy?

Set the default consistency level for account1 to eventual

Disable indexing on all fields in the index policy of the con-product container

Create a new container and migrate the product catalog data to the new container

Remove frequently changed field from the index policy of the con-product container

7 / 60

You have an Azure Cosmos DB for NoSQL account. The change feed is enabled on a container named invoice. You create an Azure function that has a trigger on the change feed. What is received by the Azure function?

All the properties of the updated items

All the properties of the original items and the updated items

Only the partition key and the changed properties of the updated items

Only the changed properties and the system-defined properties of the updated items

8 / 60

You have an Azure subscription.

You plan to create an Azure Cosmos DB for NoSQL database named DB1 that will store author and book data for authors that have each published up to ten books. Typical and frequent queries of the data will include:

* All books written by an individual author

* The synopsis of individual books

You need to recommend a data model for DB1. The solution must meet the following requirements:

* Support transactional updates of the author and book data.

* Minimize read operation costs.

What should you recommend?

Create a single container that stores author items and book items. Embed a list of each author's books in the corresponding author item

Create two containers, one that stores author items and another that stores book items. Embed a list of each author's books in the corresponding author item

Create a single container that stores author items and book items, and then items that represent the relationship between the authors and their books

Create three containers, one that stores author items, a second that stores book items, and a third that stores items that represent the relationship between the authors and their books

9 / 60

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

Backups for account1 have the following configurations:

* Interval: 2 hours

* Retention period: 4 days

You need to estimate the charges associated with the retention of the backups. How many copies of the backups will incur additional charges?

10 / 60

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?

Create a private endpoint connection

Modify the connection policy of App1

Set the default consistency level of accountl to bounded staleness

Increase the number of request units per second (RU/s) allocated to the con-product and conproductVendor containers

11 / 60

You need to identify which connectivity mode to use when implementing App2. The solution must support the planned changes and meet the business requirements. Which connectivity mode should you identify?

Direct mode over TCP

Direct mode over HTTPS

Gateway mode (using HTTPS)

12 / 60

You need to select the partition key for con-iot1. The solution must meet the IoT telemetry requirements. What should you select?

The humidity

The device ID

The timestamp

The temperature

13 / 60

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?

Enable time to live for the con-product container

Set the default consistency level of account1 to strong

Add a custom indexing policy to the con-product container

Set the default consistency level of account1 to bounded staleness

14 / 60

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?

Data Usage

Region Removed

Metadata Requests

Provisioned Throughput

15 / 60

You have an Azure Cosmos DB for NoSQL account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a and a read region in East US. You run the following PowerShell command.

What is the effect of running the command?

A manual failover will occur

The account will be configured for multi-region writes

The provisioned throughput for account1 will increase

The account will be unavailable to writes during the change

16 / 60

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?

Yes

17 / 60

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?

The Pagesize value

The FeedRange value

A stream-based iterator

The changeFeedStartFew value

18 / 60

You have an Azure Cosmos DB database that hosts a container named container1. You need to ensure that the items stored in contained will NOT expire unless their TTL value is set explicitly. What should you do?

Set the DefaulttimtoLive property to e

Set the DefaultiiwioLive property to null

Remove the DefaultTiiwroLive property

Set the DefaultTineToLive property to -l

19 / 60

You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account! that hosts a container named Container 1. Container! has a provisioned throughput of 100 request units per second (RU/s) and uses a single physical partition.

Vou are evaluating the available throughput for Container1.

What is the maximum burst capacity that Container1 can accumulate?

300 RU/s

1,000 RU/s

30,000 RU/s

100,000 RU/s

20 / 60

You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that hosts a container named Devices. Devices has a partition key named type.

You are evaluating the resource utilization of the query. How will the query be executed?

As an in-partition query

As a cross-partition query

As a parallel cross-partition query

21 / 60

You need to create a database in an Azure Cosmos DB for NoSQL account. The database will contain three containers named coll1, coll2 and coll3. The coll1 container will have unpredictable read and write volumes. The col!2 and coll3 containers will have predictable read and write volumes. The expected maximum throughput for coll1 and coll2 is 50,000 request units per second (RU/s) each.

How should you provision the collection while minimizing costs?

Create a serverless account

Create a provisioned throughput account. Set the throughput for coll1 to Manual. Set the throughput for coll2 and coll3 to Autoscale

Create a provisioned throughput account. Set the throughput for call1 to Autoscale. Set the throughput for call2 and coll3 to Manual

22 / 60

You have an Azure Cosmos DB account named account1. You have several apps that connect to account1 by using the account's secondary key. You then configure the apps to authenticate by using service principals. You need to ensure that account1 will only allow apps to connect by using an Azure AD identity. Which account property should you modify?

allowedOrxgins

disableLocalAuth

userAssignedldentatxe

disableKeyBasedMetadataWriteAccess

23 / 60

You have a container named container1 in an Azure Cosmos DB for NoSQL account.

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

Solution: You create an Azure function to copy data to another Azure Cosmos DB for NoSQL container.

Does this meet the goal?

Yes

24 / 60

You have an Azure Cosmos DB account named account1. You need to access account1 from an on-premises environment by using a Site-to-Site VPN. What should you use?

A private endpoint

Azure Synapse Link

A dedicated gateway

25 / 60

You develop an application that uses Azure Cosmos DB Core (SQL) API. You create an Azure pipeline to build and deploy the application. You need to change the pipeline to run integration tests that you wrote for the application. The solution must execute entirely in the pipeline. What should you add to the pipeline?

An Azure Cosmos DB Emulator task

A deployment group named Cosmos DB testing

A NuGet service connection that uses an Azure Cosmos DB API key

A secret variable that has a connection string to an Azure Cosmos DB database

26 / 60

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 function to copy data to another Azure Cosmos DB Core (SQL) API container.
Does this meet the goal?

Yes

27 / 60

You have a database named db1 in an Azure Cosmos DB Core (SQL) API account. You have a third-party application that is exposed through a REST API. You need to migrate data from the application to a container in db1 on a weekly basis. What should you use?

Azure Migrate

Azure Data Factory

Database Migration Assistant

28 / 60

You have a database named db1 in an Azure Cosmos DB Core (SQL) API account named account1. 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?

In account1, add a private endpoint

In account1, enable a dedicated gateway

In db1, create containers that have a custom indexing policy and analytical store disabled

In db1, create containers that have an automatic indexing policy and analytical store enabled

29 / 60

You have an Azure Cosmos DB Core (SQL) API account. The change feed is enabled on a container named invoice. You create an Azure function that has a trigger on the change feed. What is received by the Azure function?

All the properties of the updated items

All the properties of the original items and the updated items

Only the partition key and the changed properties of the updated items

Only the changed properties and the system-defined properties of the updated items

30 / 60

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 function that uses Azure Cosmos DB Core (SQL) API change feed as a trigger and Azure event hub as the output.
Does this meet the goal?

Yes

31 / 60

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 Data Factory pipeline that uses Azure Cosmos DB Core (SQL) API as the input and Azure Blob Storage as the output.
Does this meet the goal?

Yes

32 / 60

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?

Yes

33 / 60

The following is a sample of a document in orders.

The orders container uses customerId as the partition key.
You need to provide a report of the total items ordered per month by item type. The solution must meet the following requirements:
✑ Ensure that the report can run as quickly as possible.
✑ Minimize the consumption of request units (RUs).
What should you do?

Configure the report to query orders by using a SQL query

Configure the report to query orders by using a SQL query through a dedicated gateway

Configure the report to query a new aggregate container. Populate the aggregates by using the change feed

Configure the report to query a new aggregate container. Populate the aggregates by using SQL queries that run daily

34 / 60

You have an Azure Cosmos DB Core (SQL) API account that uses a custom conflict resolution policy. The account has a registered merge procedure that throws a runtime exception. The runtime exception prevents conflicts from being resolved. You need to use an Azure function to resolve the conflicts. What should you use?

A function that pulls items from the change feed and is triggered by a timer trigger

A function that pulls items from the conflicts feed and is triggered by a timer trigger

A function that receives items pushed from the change feed and is triggered by an Azure Cosmos DB trigger

A function that receives items pushed from the conflicts feed and is triggered by an Azure Cosmos DB trigger

35 / 60

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?

Weaker consistency for write operations

Weaker consistency for read operations

Stronger consistency for read operations

Stronger consistency for write operations

36 / 60

You have an Azure Cosmos DB database that contains a container named container1. The container1 container is configured with a maximum of 20,000 RU/s and currently contains 240 GB of data. You need to estimate the costs of container1 based on the current usage. How many RU/s will be charged?

240

4,000

20,000

24,000

37 / 60

You plan to create an Azure Cosmos DB account that will use the NoSQL API. You need to create a grouping strategy for items that will be stored in the account. The solution must ensure that write and read operations on the items can be performed within the same transaction. What should you use to group the items?

Databases

Containers

Logical partitions

Physical partitions

38 / 60

You have an Azure Cosmos DB Core (SQL) API account named account1 that has a single read-write region and one additional read region. Account1 uses the strong default consistency level. You have an application that uses the eventual consistency level when submitting requests to account1. How will writes from the application be handled?

Writes will use the strong consistency level

Writes will use the eventual consistency level

The write order is not guaranteed during replication

Azure Cosmos DB will reject writes from the application

39 / 60

You have a global ecommerce application that stores data in an Azure Cosmos DB Core (SQL) API account. The account is configured for multi-region writes.
You need to create a stored procedure for a custom conflict resolution policy for a new container. In the event of a conflict caused by a deletion, the deletion must always take priority.
Which parameter should you check in the stored procedure function?

existingItem

isTombstone

incomingItem

conflictingItems

40 / 60

You have an Azure Cosmos DB Core (SQL) API account named account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a read region in East US. You run the following PowerShell command.
Update-AzCosmosDBAccountFailoverPriority -ResourceGroupName `rg1` -Name `account1` -FailoverPolicy @(`East US`, `West US`)
What is the effect of running the command?

A manual failover will occur

The provisioned throughput for account1 will increase

The account will be configured for multi-region writes

The account will be unavailable to writes during the change

41 / 60

The settings for a container in an Azure Cosmos DB Core (SQL) API account are configured as shown in the following exhibit.

Which statement describes the configuration of the container?

Items stored in the collection will expire only if the item has a time to live value

Items stored in the collection will be retained always, regardless of the items time to live value

All items will be deleted after one year

All items will be deleted after one hour

42 / 60

You plan to create an Azure Cosmos DB for NoSQL account that will have a single write region and three read regions. You need to set the consistency level for the account. The solution must meet the following requirements:
• In the write region, writes must replicate synchronously across at least three replicas.
• In the read regions, reads must see writes in order for transactional batches.
• Throughput for reads and writes must be maximized.
Which consistency level should you select?

Strong

Eventual

Consistent Prefix

Bounded Staleness

43 / 60

You have an Azure Cosmos DB for NoSQL account that contains a database named DB1 and a container named Container1. You need to manage the account by using the Azure Cosmos DB SDK. What should you do?

Create a container in DB1

Create a user defined function (UDF) in Container1

Read a stored procedure in Container1

List the physical partitions of Container1

44 / 60

You provision an Azure Cosmos DB for NoSQL container. You set the throughput to Autoscale, and the maximum request units per second (RU/s) to 20,000. For how many RU/s will you be charged when the actual RU/s usage is zero?

200

2,000

4,000

10,000

45 / 60

Your company develops an application named App1 that uses the Azure Cosmos DB SDK and the Eventual consistency level. App1 queries an Azure Cosmos DB for NoSQL account named account1.
You need to identify which consistency level to assign to App1 to meet the following requirements:
• Maximize the throughput of the queries generated by App1 without increasing the number of request units currently used by the queries.
• Provide the highest consistency guarantees.
Which consistency level should you identify?

Strong

Session

Consistent Prefix

Bounded Staleness

46 / 60

You have an Azure Cosmos DB Core (SQL) API account named account 1 that uses autoscale throughput.
You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a specific value.
Solution: You configure the function to have an Azure CosmosDB trigger.
Does this meet the goal?

Yes

47 / 60

You plan to store order data in an Azure Cosmos DB Core (SQL) API account. The data contains information about orders and their associated items.
You need to develop a model that supports order read operations. The solution must minimize the number of requests.
What should you do?

Create a database for orders and a database for order items

Create a single database that contains a container for orders and a container for order items

Create a single database that contains one container. Store orders and order items in separate documents in the container

Create a single database that contains one container. Create a separate document for each order and embed the order items into the order documents

48 / 60

You have an Azure Cosmos DB Core (SQL) API account named account1 that uses autoscale throughput.
You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a specific value.
Solution: You configure Azure Event Grid to send events to the function by using an Event Grid trigger in the function.
Does this meet the goal?

Yes

49 / 60

You have an Azure Cosmos DB Core (SQL) API account named account 1 that uses autoscale throughput.
You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a specific value.
Solution: You configure an application to use the change feed processor to read the change feed and you configure the application to trigger the function.
Does this meet the goal?

Yes

50 / 60

You have an Azure Cosmos DB Core (SQL) API account named account 1 that uses autoscale throughput.
You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a specific value.
Solution: You configure an Azure Monitor alert to trigger the function.
Does this meet the goal?

Yes

51 / 60

You maintain a relational database for a book publisher. The database contains the following tables.

The most common query lists the books for a given authorId.
You need to develop a non-relational data model for Azure Cosmos DB Core (SQL) API that will replace the relational database. The solution must minimize latency and read operation costs.
What should you include in the solution?

Create Author, Book, and Bookauthorlnk documents in the same container

Create a container that contains a document for each Author and a document for each Book. In each Book document, embed authorId

Create a container for Author and a container for Book. In each Author document and Book document embed the data from Bookauthorlnk

Create a container for Author and a container for Book. In each Author document, embed bookId for each book by the author. In each Book document embed authorId of each author

52 / 60

You have an Azure Cosmos DB for NoSQL account named account1. You need to create a container named Container1 in account1 by using the Azure Cosmos DB .NET SDK. The solution must ensure that the items in Container1 never expire. What should you set?

DefaultTimeToLive to –1

DefaultTimeToLive to null

TimeToLivePropertyPath to 0

TimeToLivePropertyPath to null

53 / 60

You have an Azure Cosmos DB database. You plan to create a new container named container1 that will store product data and product category data and will primarily support read requests. You need to configure a partition key for container1. The solution must meet the following requirements:
• Minimize the size of the partition.
• Minimize maintenance effort.
Which two characteristics should you prioritize? Each correct answer presents part of the solution.

Unique, Low cardinality

Static, Unique

High cardinality, Static

Low cardinality, High cardinality

54 / 60

You have a container in an Azure Cosmos DB Core (SQL) API account. The container stores telemetry data from IoT devices. The container uses telemetryId as the partition key and has a throughput of 1,000 request units per second (RU/s). Approximately 5,000 IoT devices submit data every five minutes by using the same telemetryId value.
You have an application that performs analytics on the data and frequently reads telemetry data for a single IoT device to perform trend analysis.
The following is a sample of a document in the container.

You need to reduce the amount of request units (RUs) consumed by the analytics application.
What should you do?

Increase the offerThroughput value for the container

Decrease the offerThroughput value for the container

Move the data to a new container that uses a partition key of temp

Move the data to a new container that uses a partition key of deviceId

55 / 60

You have an application named App1 that reads the data in an Azure Cosmos DB Core (SQL) API account. App1 runs the same read queries every minute. The default consistency level for the account is set to eventual.
You discover that every query consumes request units (RUs) instead of using the cache.
You verify the IntegratedCacheiteItemHitRate metric and the IntegratedCacheQueryHitRate metric. Both metrics have values of 0.
You verify that the dedicated gateway cluster is provisioned and used in the connection string.
You need to ensure that App1 uses the Azure Cosmos DB integrated cache.
What should you configure?

The consistency level of the requests from App1

The connectivity mode of the App1 CosmosClient

The indexing policy of the Azure Cosmos DB container

The default consistency level of the Azure Cosmos DB account

56 / 60

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?

In a directory container, create a document for each company and a document for each user. Use the company ID as the partition key

In a user container, create a document for each user. Embed the company into each user document. Use the user ID as the partition key

In a company container, create a document for each company. Embed the users into company documents. Use the company ID as the partition key

Create a user container that uses the user ID as the partition key and a company container that uses the company ID as the partition key. Add the company ID to each user document

57 / 60

You have a container in an Azure Cosmos DB Core (SQL) API 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 familyId.
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?

Update the document of each family member separately by using a patch operation

Update the document of each family member by using a transactional batch operation

Update the document of each family member separately and set the consistency level to strong

58 / 60

You have a database named db1 in an Azure Cosmos DB Core (SQL) API account. You are designing an application that will use db1. In db1, you are creating a new container named coll1 that will store online orders. The following is a sample of a document that will be stored in coll1.

The application will have the following characteristics:
✑ New orders will be created frequently by different customers.
✑ Customers will often view their past order history.
You need to select the partition key value for coll1 to support the application. The solution must minimize costs.
To what should you set the partition key?

OrderId

CustomerId

OrderDate

59 / 60

You have an Azure Cosmos DB Core (SQL) API account. You run the following query against a container in the account.

What is the output of the query?

[{"A": true, "B": true, "C": true}]

[{"A": true, "B": true, "C": false}]

[{"A": true, "B": false, "C": true}]

[{"A": false, "B": true, "C": false}]

60 / 60

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?

Use timestamp as the partition key

Create a new synthetic key that contains deviceId and sensor1Value

Create a new synthetic key that contains deviceId and a random number

Create a new synthetic key that contains deviceId and deviceManufacturer

Your score is

The average score is 57%

By Wordpress Quiz plugin

Free DP-420 Exam Questions – 2025 Updated

Study Smarter for the DP-420 Exam with Our Free and Reliable DP-420 Exam Questions – Updated for 2025.

Disclaimer

[email protected]

Helpful links

top Vendors

Contact Us

[email protected]

FLASH OFFER

avail $6 DISCOUNT on YOUR PURCHASE