Free Microsoft DP-420 Exam Questions

Become Microsoft Certified with updated DP-420 exam questions and correct answers

Page: 1 / 59

Total 291 Questions | Updated On: Dec 17, 2025

Add To Cart

Question 1

Each transaction in a Cosmos Database provides ACID property guarantees. Which of these ACID properties ensures that the data is always in a valid state across transactions?

A : Atomicity

B : Consistencyright

C : Isolation

D : Durability

Answer: B

Question 2

You are designing an Azure Cosmos DB for NoSQL solution to store data from IoT devices. Writes from the devices will occur every second. Data will be retained indefinitely.

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?

A : Use timestamp as the partition key.

B : Create a new synthetic key that contains deviceId and sensor1Value.

C : Create a new synthetic key that contains deviceId and deviceManufacturer.

D : Create a new synthetic key that contains deviceId and a random number.

Answer: B

Question 3

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?

A : composite index for (sensor ASC, value ASC) and a composite index for (sensor ASC, timestamp ASC)

B : composite index for (sensor ASC, value ASC, timestamp ASC) and a composite index for (sensor DESC, value DESC, timestamp DESC)

C : composite index for (value ASC, sensor ASC) and a composite index for (timestamp ASC, sensor ASC)

D : composite index for (sensor ASC, value ASC, timestamp ASC)

Answer: A

Question 4

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 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?

A :

B :

Answer: B

Question 5

While working in .NET SDK v3, you need to enable multi-region writes in your app that uses Azure Cosmos DB. WestUS2 is the region where your application would be deployed and Cosmos DB is replicated.

Which of the following attributes would you set to WestUS2 to achieve the goal?

A : ApplicationRegionright

B : SetCurrentLocation

C : setPreferredLocations

D : connection_policy.PreferredLocations

Answer: A

Page: 1 / 59

Total 291 Questions | Updated On: Dec 17, 2025

Add To Cart