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: Mar 19, 2026

Add To Cart

Question 1

You are working on an app that will save the device metrics produced every minute by various IoT devices. You decide to collect the data for two entities; the devices and the device metrics produced by each device. You were about to create two containers for these identified entities but suddenly your data engineer suggests you place both entities in a single container, not two different containers. You would like to be able to track the general data of the device and the number of metrics collections per device. How could we keep track of these entities inside the container?

A : Add a new property to your device documents called metricscollectioncount and update it with the current number of metrics collection documents. Subtract 1 from the metricscollectioncount property when your app or Azure function adds a new metrics collection

B : Add a new property to your device documents called metricscollectioncount and update it with the current number of metrics collection documents. Add 1 to the metricscollectioncount property inside a transactional batch when your app or Azure function adds a new metrics collectionright

C : Use a GROUP BY parameter in your query and use the aggregate count to return the number of device metrics collections per device

D : Use a GROUP BY parameter in your query and use the aggregate sum to return the number of device metrics collections per device

Answer: B

Question 2

Consider the following two statements:

Statement 1: A container with provisioned throughput can't be converted to a shared database container.

Statement 2: A shared database container can’t be converted to have a dedicated throughput.

Which of the above statement(s) is/are true?

A : Only statement 1

B : Only statement 2

C : Both statement 1 and statement 2right

D : None of statements 1 and statement 2

Answer: C

Question 3

The below diagram illustrates the configuration settings for a container in an Azure Cosmos DB Core (SQL) API account.

Which of the following statements rightly describes the container’s configuration?

A : All the items will be deleted after 1 hour

B : All the items will be deleted after 1 month

C : Items will be expired only if they have a time to live valueright

D : Items stored in containers will get retained always, regardless of the time to live value of the items

Answer: C

Question 4

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?

A : able Continuous Backup for the account.

B : nfigure the Backup & Restore settings for the account.

C : eate a new account that has a periodic backup policy.

D : nfigure the Point In Time Restore settings for the account.

Answer: A

Question 5

You have operational data in an Azure Cosmos OB for NoSQL database. Database users report that the performance of the database degrades significantly when a business analytics team runs large Apache Spark-based queries against the database. You need 10 reduce the impact that running the Spark-based queries has on the database users. What should you implement?

A : ure Synapse Link

B : default consistency level of Consistent Prefix

C : default consistency level of Strong

D : Spark connector

Answer: A

Page: 1 / 59

Total 291 Questions | Updated On: Mar 19, 2026

Add To Cart