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: Oct 28, 2025

Add To Cart

Question 1

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

A : move frequently changed field from the index policy of the con-product container.

B : able indexing on all fields in the index policy of the con-product container.

C : t the default consistency level for account1 to eventual.

D : eate a new container and migrate the product catalog data to the new container.

Answer: D

Question 2

An Azure Cosmos DB Core (SQL) API account has a container that stores telemetry data from IoT devices. The container utilizes telemetryId as the partition key and has a throughput of 1000 RU/s (request units per second). Data is submitted by approx 5000 IoT devices by using the same telemetryId value every 5 minutes.

You have an app that does analytics on the data and reads telemetry data frequently for a single IoT device to have the trend analysis.

The below figure demonstrates the sample of a document in the container:

What would you do for reducing the number of RUs consumed by the analytics app?

A : Enhance the offerThroughput value for the container

B : Decrease the offerThroughput value for the container

C : Move the data to a new container that utilizes a partition key of date

D : Move the data to a new container that contains a partition key of deviceIdright

Answer: D

Question 3

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 :

B :

Answer: A

Question 4

In a shared throughput database, the containers share the throughput (Request Units per Second) allocated to that database. In a manually provisioned throughput, it is possible to have up to ………… containers with a minimum ……………. Request Units per second on the database.

A : 15 and 400

B : 25 and 400right

C : 15 and 4000

D : 25 and 4000

Answer: B

Question 5

One of your friends needs to troubleshoot the skew storage. Which of the following SQL API Log Analytics tables would you suggest using?

A : DataPlaneRequests

B : QueryRuntimeStatistics

C : PartitionKeyRUConsumption

D : nPartitionKeyStatisticsright

E : ControlPlaneRequests

Answer: D

Page: 1 / 59

Total 291 Questions | Updated On: Oct 28, 2025

Add To Cart