DP-420 Exam Questions

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

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

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

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

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 application named App1 that reads the data in an Azure Cosmos DB for NoSQL account. App1 runs the same read queries every minute. The default consistency level for the...

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

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

You have an Azure Cosmos DB for NoSQL account. You run the following query against a container in the account. What is the output of the query?

You need to implement a trigger in Azure Cosmos DB for NoSQL that will run before an item is inserted into a container. Which two actions should you perform to ensure that the trig...

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 a container in an Azure Cosmos DB for NoSQL account. The container stores telemetry data from IoT devices. The container uses telemetryId as the partition key and has a th...

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

You have an Azure Cosmos DB for NoSQL account that uses a custom conflict resolution policy. The account has a registered merge procedure that throws a runtime exception. The runti...

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 have a container named container1 in an Azure Cosmos DB for NoSQL account. Upserts of items in container1 occur every three seconds. You have an Azure Functions app named funct...

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

You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB for NoSQL account. The data from a container named telemetry must be added to a Kafka topic na...

You are implementing an Azure Data Factory data flow that will use an Azure Cosmos DB for NoSQL sink to write a dataset. The data flow will use 2,000 Apache Spark partitions. You n...

You have a container named container1 in an Azure Cosmos DB for NoSQL account. You need to provide a user named User1 with the ability to insert items into container1 by using role...

You have an Azure Cosmos DB Core (SQL) API account. You configure the diagnostic settings to send all log information to a Log Analytics workspace. You need to identify when the pr...

You have a database in an Azure Cosmos DB for NoSQL account. The database is backed up every two hours. You need to implement a solution that supports point-in-time restore. What s...

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

You have an Azure Cosmos DB Core (SQL) API account that is used by 10 web apps. You need to analyze the data stored in the account by using Apache Spark to create machine learning...

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?

Drag and Drop Question You have an app that stores data in an Azure Cosmos DB for NoSQL account The app performs queries that return large result sets. You need to return a complet...

Drag and Drop Question You have an Azure Cosmos DB for NoSQL account that is configured for multi-region writes. The account contains a database that has two containers named conta...

You are working on an app that will save the device metrics produced every minute by various IoT devices. You decide to collect the data for two entities; the devices and the devic...

The below diagram illustrates the configuration settings for a container in an Azure Cosmos DB Core (SQL) API account. Which of the following statements rightly describes the conta...

While working in .NET SDK v3, you need to enable multi-region writes in your app that uses Azure Cosmos DB. WestUS2 is the region where your application would be deployed and Cosmo...

While chairing a team session, you are telling the team members about the Azure Cosmos DB Emulator. Which of the following statement is not true about Azure Cosmos DB Emulator?

You need to configure the consistency levels on a per-request basis. Which of the following C# class would you use in the .NET SDK for Azure Cosmos DB SQL API?

Which of the following function in Spark SQL separates the array's elements into multiple rows with positions and utilizes the column names 'pos' for position and 'col' for element...

One of the team members has recently joined the team and wants to manually adjust the time for which the items will remain in the cache. He asks you for help about which property f...

You work in the Intel company that has its clients across 4 different countries, with hundreds of thousands of clients for countries 1 and 2, and a few thousand clients for countri...

Gateway mode using the dedicated gateway is one of the ways to connect to an Azure Cosmos DB account. Which of the following statement(s) is/are true about a dedicated gateway?

You need to create a .NET console app to manage data in the Azure Cosmos DB SQL API account. As a part of the procedure, you need to create a database. Which of the following metho...

You are part of a development team and your team creates a set of aggregate metadata items that are needed to be changed anytime, once you successfully update or create an item wit...

Which of the following is the most optimal method of managing referential integrity between different containers in Azure Cosmos DB?

App1 is an application that reads the data stored in the Azure Cosmos DB Core (SQL) API account. The application runs the same read queries every minute. Eventual is the default co...

Container2 is a container in an Azure Cosmos DB Core (SQL) API account where Upserts of items happen every three seconds. You are having an Azure Functions application named functi...

Range, spatial, and composite are three different types of indexes supported by Azure Cosmos DB. Which of these indexes are used for geospatial objects like points, polygons, LineS...

The server-side latency direct and server-side latency gateway are two metrics that can be used to view the server-side latency of any operation in two different connection modes....

You have a database named db1 in an Azure Cosmos DB for NoSQL account. You are designing an application that will use db1. In db1, you are creating a new container named coll1 that...