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: Apr 01, 2026

Add To Cart

Question 1

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 2

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 3

You have recently joined a new company as an App developer. Which of the following metrics would you check to know if your application uses the dedicated gateway or not?

A : IntegratedCacheItemHitRate

B : DedicatedGatewayRequestsright

C : IntegratedCacheQueryHitRate

D : DedicatedGatewayApps

Answer: B

Question 4

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 5

You have a container of books with JSON documents that have a string property named title. The JSON documents also have a property named tags which is an array of string values. You need to authorize a SQL query that will create a cross-product of the document titles and tags. Which of the following SQL query would you use?

A : SELECT b.title, t.tags FROM books b

B : SELECT b.title, t.tags[0] FROM books b

C : SELECT b.title, t.tags[0] FROM books b

D : None of the Above

Answer: C

Page: 1 / 59

Total 291 Questions | Updated On: Apr 01, 2026

Add To Cart