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 26, 2026

Add To Cart

Question 1

You have an Azure Cosmos DB Core (SQL) API account that is used by 10 web apps. You need to analyze the data stored in the account by using Apache Spark to create machine learning models. The solution must NOT affect the performance of the web apps. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A : an Apache Spark pool in Azure Synapse, create a table that uses cosmos.olap as the data source.

B : eate a private endpoint connection to the account.

C : an Azure Synapse Analytics serverless SQL pool, create a view that uses OPENROWSET and the CosmosDB provider.

D : able Azure Synapse Link for the account and Analytical store on the container.

E : an Apache Spark pool in Azure Synapse, create a table that uses cosmos.oltp as the data source.

Answer: A,D

Question 2

Azure Cosmos DB comes in 2 different capacity modes that are provisioned throughput and serverless.

i). Which of these modes is best suited for Workloads having sustained traffic that require predictable performance?

ii). For which mode, Geo distribution is unavailable?

A : i) provisioned throughput and ii) Serverlessright

B : i) Serverless and ii) Provisioned throughput

C : i) Provisioned throughput and ii) Provisioned throughput

D : i) Serverless and ii) Serverless

Answer: A

Question 3

You have an Azure Cosmos DB for NoSQL account named account1 that supports an application named App1. App1 uses the consistent prefix consistency level. You configure account1 to use a dedicated gateway and integrated cache. You need to ensure that App1 can use the integrated cache. Which two actions should you perform for APP1? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A : ange the connection mode to direct

B : ange the account endpoint to https://account1.sqlx.cosmos.azure.com.

C : ange the consistency level of requests to strong.

D : ange the consistency level of requests to session.

E : ange the account endpoint to https://account1.documents.azure.com

Answer: B,D

Question 4

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?

A : In account1, change the default consistency level to bounded staleness.

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

C : In account1, provision a dedicated gateway and integrated cache

D : In App1, modify the connection policy settings.

Answer: C

Question 5

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

Page: 1 / 59

Total 291 Questions | Updated On: Oct 26, 2026

Add To Cart