Free Microsoft DP-420 Practice Questions & Answers 2026 Part1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure Cosmos DB Core (SQL) API account named account 1 that uses autoscale throughput. You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a speci c value.Solution: You con gure an Azure Monitor alert to trigger the function.Does this meet the goal?

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?

You have an Azure Cosmos DB Core (SQL) API account that has multiple write regions.You need to receive an alert when requests that target the database exceed the available request units per second (RU/s).Which Azure Monitor signal should you use?

You need to select the partition key for con - iot1. The solution must meet the IoT telemetry requirements. What should you select?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure Cosmos DB Core (SQL) API account named account 1 that uses autoscale throughput. You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a speci c value. Solution: You con gure an application to use the change feed processor to read the change feed and you con gure the application to trigger the function.Does this meet the goal?

You have an Azure Cosmos DB Core (SQL) API account named account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a read region in East US.You run the following PowerShell command.Update-AzCosmosDBAccountFailoverPriority -ResourceGroupName `rg1` -Name`account1` -FailoverPolicy @(`East US`, `West US`)What is the effect of running the command?

You have an Azure Cosmos DB Core (SQL) API account.You run the following query against a container in the account.What is the output of the query?

You have an Azure Cosmos DB for NoSQL database named db1 that writes to multiple Azure regions. You need to test the performance of db1 in the secondary region. Which command should you run first?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure Cosmos DB Core (SQL) API account named account 1 that uses autoscale throughput. You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a speci c value.Solution: You con gure the function to have an Azure CosmosDB trigger.Does this meet the goal?

You have an Azure Cosmos DB for NoSQL account named account1. You plan to implement a multi-region write scenario. You enable multi-region writes for account1.Which two actions should you perform next? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have a database in an Azure Cosmos DB Core (SQL) API 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 conflicts are sent to the conflicts feed.Solution: You set ConflictResolutionMode to LastWriterWins and you use the default settings for the policy.Does this meet the goal?

You have an Azure Cosmos DB for NoSQL database named db1 that is monitored by using Azure Monitor. You need to identify the operations that have the highest throughput. Which metric should you use?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure Cosmos DB Core (SQL) API account named account 1 that uses autoscale throughput. You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a speci c value.Solution: You con gure an Azure Monitor alert to trigger the function.Does this meet the goal?

You need to implement a trigger in Azure Cosmos DB Core (SQL) API that will run before an item is inserted into a container.Which two actions should you perform to ensure that the trigger runs? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB for NoSQL account that has multiple write regions.You need to receive an alert when requests that target the database exceed the available request units per second (RU/s).Which Azure Monitor signal should you use?

You need to select the partition key for con-iot1. The solution must meet the IoT telemetry requirements.What should you select?

You are developing an application that will use an Azure Cosmos DB Core (SQL) API account as a data source. You need to create a report that displays the top five most ordered fruits as shown in the following table. A collection that contains aggregated data already exists. The following is a sample document: { "name": "apple", "type": ["fruit", "exotic"], "orders": 10000 } Which two queries can you use to retrieve data for the report? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A) B) C) D)

You maintain a relational database for a book publisher. The database contains the following tables.The most common query lists the books for a given authorId.You need to develop a non-relational data model for Azure Cosmos DB Core (SQL) API that will replace the relational database. The solution must minimizelatency and read operation costs.What should you include in the solution?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure Cosmos DB Core (SQL) API account named account 1 that uses autoscale throughput. You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a speci c value.Solution: You con gure the function to have an Azure CosmosDB trigger.Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure Cosmos DB Core (SQL) API account named account 1 that uses autoscale throughput. You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a speci c value.Solution: You con gure the function to have an Azure CosmosDB trigger.Does this meet the goal?

You have a database in an Azure Cosmos DB for NoSQL account.You need to create an Azure function that will access the database to retrieve records based on a variable named accountnumber. The solution must protect against SQL injection attacks.How should you define the command statement in the function?

You are implementing an Azure Data Factory data flow that will use an Azure Cosmos DB (SQL API) sink to write a dataset. The data flow will use 2,000 Apache Spark partitions. You need to ensure that the ingestion from each Spark partition is balanced to optimize throughput. Which sink setting should you configure?