Free Microsoft DP-420 Practice Questions & Answers 2026 Part2

You have an Azure subscription that contains the resources shown in the following table.You need to store the account key of account1 in KV1. What should you use?

You plan to implement an Azure Cosmos DB container that will store telemetry data from 1,000 loT devices. The data will be updated once every minute. An app will read the data once daily and generate aggregated reports that summarize the state of each device.You need to configure a partition key for the container. The solution must meet the following requirements:* Minimize the possibility of reaching the partition limits.* Spread read and write operations evenly across the partitions.* Minimize how long it takes to locate a specific set of telemetry values.To what should you set the partition key?

You configure multi - region writes for account1. You need to ensure that App1 supports the new configuration for account1. The solution must meet the business requirements and the product catalog requirements. What should you do?

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 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 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 minimize latency and read operation costs.What should you include in the solution?

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.

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 a container in an Azure Cosmos DB for NoSQL account that stores data about orders. The following is a sample of an order document. Documents are up to 2 KB. You plan to receive one million orders daily. Customers will frequently view then past order history. You are the evaluating whether to use orderDate as the partition key. What are two effects of using orderDate as the partition key? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. Upserts of items in container1 occur every three seconds. You have an Azure Functions app named function1 that is supposed to run whenever items are inserted or replaced in container1. You discover that function1 runs, but not on every upsert. You need to ensure that function1 processes each upsert within one second of the upsert. Which property should you change in the Function.json file of function1?

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?

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?

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 container named container! in an Azure Cosmos DB for NoSQL account. You need to make the contents of container1 available as reference data for an Azure Stream Analytics job. Solution: You create an Azure function that uses the Azure Cosmos 08 for NoSQL change feed as a trigger and an Azure event hub as the output. Does this meet the goal?

You have an app named App1 that uses an Azure Cosmos DB for NoSQL database.App1 uses the spatial columns shown in the following table.You need to design an indexing strategy for App1.Which columns can be indexed by using spatial indexes?

The settings for a container in an Azure Cosmos DB Core (SQL) API account are configured as shown in the following exhibit.Which statement describes the configuration of the container?

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 account named account1 that uses the Core (SQL) API.You have a web service that receives JSON-based messages.You need to recommend a solution that will process and store the messages in a container in account1. The solution must minimize latency.What should you include in the recommendation?

You are designing an Azure Cosmos DB Core (SQL) API solution to store data from IoT devices. Writes from the devices will be occur every second.The following is a sample of the data.You need to select a partition key that meets the following requirements for writes:✑ Minimizes the partition skew✑ Avoids capacity limits✑ Avoids hot partitionsWhat should you do?

You have an Azure Cosmos DB account that hosts a single container named Container1. Container1 contains items that include two properties named Tenantld and Userld. Container1 has logical partitions based on the Tenantld property.You need to configure subpartitioning for Container1 based on the Userld property. The solution must maximize data availability.What should you do first?