Practice workspace
Try 25 supported questions from the 102-question bank. Check each answer when you are ready and keep this preview’s progress privately in your browser.
Free preview
This sample includes answers, available explanations, official references and curated community discussion. An Exam Pass unlocks the private complete bank for this exam.
Answer support
Unexplained marked answers are community claims, not independently verified teaching. Check uncertain or contested items against the official sources below.
25 questions in this bank
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?
How others answered
Only 60% agreed on this answer — treat it as contested rather than settled.
You need to identify which connectivity mode to use when implementing App2. The solution must support the planned changes and meet the business requirements. Which connectivity mode should you identify?
How others answered
You are troubleshooting the current issues caused by the application updates. Which action can address the application updates issue without affecting the functionality of the application?
How others answered
You have an Azure Cosmos DB Core (SQL) API account that uses a custom conflict resolution policy. The account has a registered merge procedure that throws a runtime exception. The runtime exception prevents conflicts from being resolved. You need to use an Azure function to resolve the conflicts. What should you use?
How others answered
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?
How others answered
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?
How others answered
Only 61% agreed on this answer — treat it as contested rather than settled.
The following is a sample of a document in orders.
The orders container uses customerId as the partition key. You need to provide a report of the total items ordered per month by item type. The solution must meet the following requirements: ✑ Ensure that the report can run as quickly as possible. ✑ Minimize the consumption of request units (RUs). What should you do?
How others answered
Only 73% agreed on this answer — treat it as contested rather than settled.
You need to select the partition key for con-iot1. The solution must meet the IoT telemetry requirements. What should you select?
How others answered
You need to provide a solution for the Azure Functions notifications following updates to con-product. The solution must meet the business requirements and the product catalog requirements. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
How others answered
You need to implement a solution for the planned changes and meet the product catalog requirements. What should you do to implement the conflict resolution policy?
How others answered
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?
How others answered
You have the following query.
You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by the query. What should you recommend?
How others answered
You need to create a database in an Azure Cosmos DB Core (SQL) API account. The database will contain three containers named coll1, coll2, and coll3. The coll1 container will have unpredictable read and write volumes. The coll2 and coll3 containers will have predictable read and write volumes. The expected maximum throughput for coll1 and coll2 is 50,000 request units per second (RU/s) each. How should you provision the collection while minimizing costs?
How others answered
You have a database in an Azure Cosmos DB Core (SQL API) account. The database contains a container named container1. The indexing mode of container1 is set to none. You configure Azure Cognitive Search to extract data from container1 and make the data searchable. You discover that the Cognitive Search index is missing all the data from the Azure Cosmos DB index. What should you do to resolve the issue?
How others answered
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?
How others answered
Only 41% agreed on this answer — treat it as contested rather than settled.
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 container1 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 Synapse pipeline that uses Azure Cosmos DB for NoSQL as the input and Azure Blob Storage as the output. Does this meet the goal?
How others answered
Most people chose A, not B. Verify this one against the vendor documentation.
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 partitions What should you do?
How others answered
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?
How others answered
Only 68% agreed on this answer — treat it as contested rather than settled.
You have a container named container1 in an Azure Cosmos DB Core (SQL) API account named account1 that is set to the session default consistency level. The average size of an item in contained 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?
How others answered
You have a global ecommerce application that stores data in an Azure Cosmos DB Core (SQL) API account. The account is configured for multi-region writes. You need to create a stored procedure for a custom conflict resolution policy for a new container. In the event of a conflict caused by a deletion, the deletion must always take priority. Which parameter should you check in the stored procedure function?
How others answered
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?
How others answered
You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Core (SQL) API account. The data from a container named telemetry must be added to a Kafka topic named iot. The solution must store the data in a compact binary format. Which three configuration items should you include in the solution? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
How others answered
You have an Azure Cosmos DB Core (SQL) API 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.
How others answered
Only 64% agreed on this answer — treat it as contested rather than settled.
You have an Azure Cosmos DB Core (SQL) API account. The change feed is enabled on a container named invoice. You create an Azure function that has a trigger on the change feed. What is received by the Azure function?
How others answered
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?
How others answered
Only 70% agreed on this answer — treat it as contested rather than settled.
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
DP-420 practice, question 1 of 25
Compiled from exam discussions posted publicly by other people on ExamTopics. Copyright in each contribution rests with its original author; it is reproduced here for study. Not verified by us — most items carry no explanation. To request removal, see our content policy.
Compiled from ExamTopics community discussions
Compiled from publicly posted community exam discussions. Contributed by third parties rather than written here, so accuracy varies and most items carry no explanation.
Across the private full bank: 0 explanations, 98 questions with candidate context and 0 questions with direct citations.
Version 1.0.0 · bank updated . How we source questions