DP-420 Exam Questions

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 re...

You have a container in an Azure Cosmos DB for NoSQL account. The container stores data about families. Data about parents, children, and pets are stored as separate documents. Eac...

You are designing an Azure Cosmos DB for NoSQL solution to store data from IoT devices. Writes from the devices will be occur every second. The following is a sample of the data. Y...

You need to create a data store for a directory of small and medium-sized businesses (SMBs). The data store must meet the following requirements: - Store companies and the users em...

You are building an application that will store data in an Azure Cosmos DB for NoSQL account. The account uses the session default consistency level. The account is used by five ot...

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 q...

You plan to store order data in an Azure Cosmos DB for NoSQL account. The data contains information about orders and their associated items. You need to develop a model that suppor...

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 re...

You have a global ecommerce application that stores data in an Azure Cosmos DB for NoSQL account. The account is configured for multi-region writes. You need to create a stored pro...

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 u...

You have an Azure Cosmos DB for NoSQL account named account1 that has a single read-write region and one additional read region. Account1 uses the strong default consistency level....

You have an Azure Cosmos DB for NoSQL 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...

Drag and Drop Question You have an Azure Synapse Analytics workspace named workspace1 that contains a serverless SQL pool. You have an Azure Table Storage account that stores opera...

You have a database named db1 in an Azure Cosmos DB for NoSQL account named account1. You need to write JSON data to db1 by using Azure Stream Analytics. The solution must minimize...

You have a database named db1 in an Azure Cosmos DB for NoSQL account. You have a third-party application that is exposed through a REST API. You need to migrate data from the appl...

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 q...

You have a database in an Azure Cosmos DB for NoSQL account. The database contains a container named container1. The indexing mode of container1 is set to none. You configure Azure...

You have a container named container1 in an Azure Cosmos DB for NoSQL account named account1 that is set to the session default consistency level. The average size of an item in co...

You have an application that queries an Azure Cosmos DB for NoSQL account. You discover that the following two queries run frequently. You need to minimize the request units (RUs)...

You have a container in an Azure Cosmos DB for NoSQL account. Data update volumes are unpredictable. You need to process the change feed of the container by using a web app that ha...

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 q...

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 q...

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 q...

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 unit...

You need to create a database in an Azure Cosmos DB for NoSQL account. The database will contain three containers named coll1, coll2, and coll3. The coll1 container will have unpre...

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 unit...

You have an Azure Cosmos DB for NoSQL account. You need to create an Azure Monitor query that lists recent modifications to the regional failover policy. Which Azure Monitor table...

Case Study 1 - Litware, inc Overview Litware, Inc. is a United States-based grocery retailer. Litware has a main office and a primary datacenter in Seattle. The company has 50 reta...

You have an Azure Cosmos DB database. You plan to create a new container named container1 that will store product data and product category data and will primarily support read req...

You develop an application that uses Azure Cosmos DB Core (SQL) API. You create an Azure pipeline to build and deploy the application. You need to change the pipeline to run integr...

You plan to create an operational system that will store data in an Azure Cosmos DB Core (SQL) API account. You need to configure the account to meet the following requirements: -...

You have an Azure Cosmos DB account named account1. You need to access account1 from an on-premises environment by using a Site-to-Site VPN. What should you use?

You have an Azure Cosmos DB database named database1 that contains a container named container1. The container1 container stores product data and has the following indexing policy....

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 q...

You have an Azure Cosmos DB account named account1. You have several apps that connect to account1 by using the account's secondary key. You then configure the apps to authenticate...

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 rea...

You have an Azure Cosmos DB for NoSQL account named account1. You need to create a container named Container1 in account1 by using the Azure Cosmos DB .NET SDK. The solution must e...

You are designing an Azure Cosmos DB for NoSQL solution to store data from IoT devices. Writes from the devices will occur every second. Data will be retained indefinitely. The fol...

Your company develops an application named App1 that uses the Azure Cosmos DB SDK and the Eventual consistency level. App1 queries an Azure Cosmos DB for NoSQL account named accoun...

You provision an Azure Cosmos DB for NoSQL container. You set the throughput to Autoscale, and the maximum request units per second (RU/s) to 20,000. For how many RU/s will you be...

Drag and Drop Question You are designing three apps named App1, App2, and App3. Each app will use a separate Azure Cosmos DB for NoSQL account. The apps have the following consiste...

You plan to create an Azure Cosmos DB account that will use the NoSQL API. You need to create a grouping strategy for items that will be stored in the account. The solution must en...

You have an Azure Cosmos DB database that contains a container named container1. The container1 container is configured with a maximum of 20,000 RU/s and currently contains 240 GB...

You have an Azure Cosmos DB for NoSQL account that uses the default consistency level. How can the consistency level be modified as part of a query request?

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 q...

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 i...

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 q...

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 q...

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 q...

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...