Black Friday Flash Blitz - 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 75special

Practice Free DP-420 Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB Exam Questions Answers With Explanation

We at Crack4sure are committed to giving students who are preparing for the Microsoft DP-420 Exam the most current and reliable questions . To help people study, we've made some of our Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB exam materials available for free to everyone. You can take the Free DP-420 Practice Test as many times as you want. The answers to the practice questions are given, and each answer is explained.

Question # 6

You have an Azure Cosmos DB for NoSQL account that hosts a container named Container1. The items in Container1 are stored in the following format.

DP-420 question answer

You need to write a query to return the Given and Family names of the children in Family1.

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

NOTE: Each correct selection is worth one point

DP-420 question answer

Question # 7

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. You run the following query.

DP-420 question answer

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

DP-420 question answer

Question # 8

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?

A.

Eventual

B.

Bounded Staleness

C.

Consistent Prefix

D.

Strong

Question # 9

You are creating a database in an Azure Cosmos DB Core (SQL) API account. The database will be used by an application that will provide users with the ability to share online posts. Users will also be able to submit comments on other users ' posts.

You need to store the data shown in the following table.

DP-420 question answer

The application has the following characteristics:

Users can submit an unlimited number of posts.

The average number of posts submitted by a user will be more than 1,000.

Posts can have an unlimited number of comments from different users.

The average number of comments per post will be 100, but many posts will exceed 1,000 comments.

Users will be limited to having a maximum of 20 interests.

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

NOTE: Each correct selection is worth one point.

DP-420 question answer

Question # 10

You have an Azure Cosmos DB for NoSQL database named DB1 that hosts a container named Container1. The partition key for Container 1 is /pki.

You have a .NET app that connects to DBi.

You need to retrieve the request unit (RU) cost of a point operation and store the value as a variable.

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.

DP-420 question answer

Question # 11

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. The account hosts a container named Container1 that stores customer data. Each customer data item includes the customer ' s name and zero or more related business categories in an array.

You need identify customers that have one of their business categories set to " retail " . The solution must return the customerName and businessCategories fields.

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

NOTE: Each correct selection is worth one point.

DP-420 question answer

Question # 12

Vou have an Azure Cosmos DB for NoSQL account that hosts a container named Container1. Contained has analytical store enabled, analytical TTL is set to 7 flays.

An application performs frequent updates to Container 1 and uses TTL to remove expired items.

Vou plan to build an incremental export from Container! to a downstream sink by using change data capture (CDC) in the analytical store and running the export from Azure Data Factory mapping data flows-

You need to configure CDC to meet the following requirement!

• The first run must include only changes from the last three days.

• The RUs required to perform the first run must be minimized.

• Subsequent runs must capture inserts updates, deletes, and TTL operations.

• The process must NOT rely on custom checkpoints based on the _is property,

Which CDC start option should you configure for the source?

A.

Start from the beginning, and set analytical TTL to 3 days so that the first CDC read contains only the last three days.

B.

Start from a specific timestamp set to now. and configure the pipeline to backfill the previous three days by querying the analytical store with a _is fitter

C.

Start from a specific timestamp set to three days ago.

D.

Start from the beginning, and set the dataflow to write rows only where the CDC operation time is within the last three days.

Question # 13

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

DP-420 question answer

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.

DP-420 question answer

Question # 14

You have an Azure Cosmos DB for NoSQL account that contains a container named Container1.

You add a composite index to the default indexing policy of Container1. The index has the following definition.

FirstName ASC, age ASC

You plan to execute the following query against Container1.

DP-420 question answer

You need to optimize the performance of the query by adding an additional index.

How should you complete the additional index? To answer, select the appropriate options in the answer area

NOTE: Each correct selection is worth one point.

DP-420 question answer

Question # 15

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

DP-420 question answer

Question # 16

You have an Azure Cosmos DB for NoSQL database that hosts a container named Container^

You are developing a new app named App1 that will use Container 1.

You need to ensure that when App1 attempts to delete a document in Container1, the action is blocked, and an error is returned to the app.

What should you use?

A.

a post-trigger

B.

a stored procedure

C.

a user-defined function (UDF)

D.

a pre-trigger

Question # 17

You have an Azure subscription.

You plan to implement an Azure Cosmos DB for NoSQL single-region write account named account1 that will replicate across two Azure regions.

You need to set the default consistency level for account1. The solution must meet the following requirements:

• Writes must be performed to a local majority in a single region.

• Reads must be performed from a local minority in a single region.

Which consistency level should you select?

A.

Session

B.

Consistent Prefix

C.

Strong

D.

Bounded Stateness

Question # 18

You have the Azure Cosmos DB for NoSQL containers shown in the following table.

DP-420 question answer

You have the items shown in the following table.

DP-420 question answer

When will each item expire? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DP-420 question answer

Question # 19

You have an Azure Cosmos DB for NoSQL container named Contacts that is configured as shown in the following exhibit.

DP-420 question answer

Contacts contains the items shown in the following table.

DP-420 question answer

To Contacts, you plan to insert the items shown in the following table.

DP-420 question answer

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

NOTE: Each correct selection is worth one point.

DP-420 question answer

Question # 20

You have three containers in an Azure Cosmos DB Core (SQL) API account as shown in the following table.

DP-420 question answer

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.

DP-420 question answer

Question # 21

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.

DP-420 question answer

You need to reduce the amount of request units (RUs) consumed by the analytics application.

What should you do?

A.

Decrease the offerThroughput value for the container.

B.

Increase the offerThroughput value for the container.

C.

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

D.

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

Question # 22

The following is a sample of a document in orders.

DP-420 question answer

The orders container uses customer 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?

A.

Configure the report to query orders by using a SQL query.

B.

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

C.

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

D.

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

Question # 23

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 container! 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 that uses the Azure Cosmos 08 for NoSQL change feed as a trigger and an Azure event hub as the output.

Does this meet the goal?

A.

Yes

B.

No

Question # 24

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?

A.

0

B.

200

C.

2,000

D.

4,000

E.

10,000

Question # 25

You have an Azure Cosmos DB for NoSQL container.

All queries to the container use the Bounded Stateness consistency level.

You discover that when many queries are executed against the container, an HTTP 429 error is returned.

What are two ways to reduce the number of HTTP 429 errors? Each correct answer presents a complete solution.

NOTE Each correct selection is worth one point.

A.

Use a query request option to change the consistency level to Strong

B.

Increase the maximum throughput.

C.

Add a post-trigger to the container.

D.

Add a pre-trigger to the container.

E.

Add query retry logic to the client application.

Question # 26

You have an Azure Cosmos DB for NoSQL container. The container contains items that have the following properties.

DP-420 question answer

You need to protect the data stored in the container by using Always Encrypted. For each property, you must use the strongest type of encryption and ensure that queries execute properly.

What is the strongest type of encryption that you can apply to each property? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DP-420 question answer

Question # 27

You have an Azure Cosmos DB account named accounts

You need to access account1 from an on-premises environment by using a Site-to-Site VPN. What should you use?

A.

a private endpoint

B.

Azure Synapse Link

C.

a dedicated gateway

Question # 28

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?

A.

Yes

B.

No

Question # 29

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?

A.

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

B.

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.

C.

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.

D.

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

Question # 30

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.

DP-420 question answer

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

DP-420 question answer

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.

DP-420 question answer

Question # 31

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.

A.

" connector.class " : " com.azure.cosmos.kafka.connect.source.CosmosDBSourceConnector "

B.

" key.converter " : " org.apache.kafka.connect.json.JsonConverter "

C.

" key.converter " : " io.confluent.connect.avro.AvroConverter "

D.

" connect.cosmos.containers.topicmap " : " iot#telemetry "

E.

" connect.cosmos.containers.topicmap " : " iot "

F.

" connector.class " : " com.azure.cosmos.kafka.connect.source.CosmosDBSinkConnector "

Question # 32

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.

DP-420 question answer

Question # 33

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?

A.

Direct mode over HTTPS

B.

Gateway mode (using HTTPS)

C.

Direct mode over TCP

Question # 34

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.

DP-420 question answer

Question # 35

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?

A.

Enable time to live for the con-product container.

B.

Set the default consistency level of account1 to strong.

C.

Set the default consistency level of account1 to bounded staleness.

D.

Add a custom indexing policy to the con-product container.

Question # 36

You need to implement a solution to meet the product catalog requirements.

What should you do to implement the conflict resolution policy.

A.

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

B.

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

C.

Set the default consistency level for account1 to eventual.

D.

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

Question # 37

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

What should you select?

A.

the timestamp

B.

the humidity

C.

the temperature

D.

the device ID

Question # 38

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.

A.

Configure the trigger for each function to use a different leaseCollectionPrefix

B.

Configure the trigger for each function to use the same leaseCollectionNair.e

C.

Configure the trigger for each function to use a different leaseCollectionName

D.

Configure the trigger for each function to use the same leaseCollectionPrefix

Question # 39

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?

A.

Set the default consistency level of accountl to bounded staleness.

B.

Create a private endpoint connection.

C.

Modify the connection policy of App1.

D.

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

DP-420 PDF

$35

$139.99

3 Months Free Update

  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions

DP-420 PDF + Testing Engine

$47.5

$189.99

3 Months Free Update

  • Exam Name: Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB
  • Last Update: Nov 22, 2026
  • Questions and Answers: 204
  • Free Real Questions Demo
  • Recommended by Industry Experts
  • Best Economical Package
  • Immediate Access

DP-420 Engine

$40

$159.99

3 Months Free Update

  • Best Testing Engine
  • One Click installation
  • Recommended by Teachers
  • Easy to use
  • 3 Modes of Learning
  • State of Art Technology
  • 100% Real Questions included