Free Microsoft DP-420 Practice Exams Questions 2026  - TheExamsLabs

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?

You have an Azure Cosmos DB for NoSQL account configured for global distribution across four regions.

At connection time, the SQL SDK needs to identify the optimal endpoint for reading and writing.

Which two factors can influence the SDK? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You plan to create an Azure Cosmos DB for NoSQL database named db1 that will contain two containers. One of the containers will contain blog posts, and the other will contain users. Each item in the blog post container will include:

• A single blog post

• The top 10 comments associated to the blog post

• The names of the users who created the blog post and the associated comments

You need to automatically update the usernames in the blog post container whenever a username in the user container changes.

What should you implement for the user container?

You plan to create an Azure Cosmos DB for NoSQL account that will use customer-managed keys stored in

Azure Key Vault.

You need to configure an access policy in Key Vault to allow Azure Cosmos DB access to the keys.

Which three permissions should you enable in the access policy? Each correct answer presents part of the

solution.

NOTE: Each correct selection is worth one point.