DP-420 Exam Questions

You have operational data in an Azure Cosmos DB for NoSQL database. Database users report that the performance of the database degrades significantly when a business analytics team...

You are creating an Azure Cosmos DB for NoSQL account. You need to choose whether to configure capacity by using either provisioned throughput or serverless mode. Which two workloa...

You have a container in an Azure Cosmos DB for NoSQL account. You need to create an alert based on a custom Log Analytics query. Which signal type should you use?

You have an Azure Cosmos DB for NoSQL account. You configure the diagnostic settings to send all log information to a Log Analytics workspace. You need to identify when the provisi...

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 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 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 subscription that contains an Azure Cosmos DB for NoSQL account named account1. Backups for account1 have the following configurations: - Interval: 2 hours - Rete...

You have an Azure Cosmos DB for NoSQL account that contains a database named DB1 and a container named Container1. You need to manage the account by using the Azure Cosmos DB SDK....

You plan to create an Azure Cosmos DB for NoSQL account that will have a single write region and three read regions. You need to set the consistency level for the account. The solu...

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 database that hosts a container named container1. You need to ensure that the items stored in container1 will NOT expire unless their TTL value is set e...

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. Data will be retained indefinitely. The...

You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that uses a default consistency level of Consistent Prefix. You execut...

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL database named DB1. In DB1, you plan to create a container that will use a hierarchical partition key. You...

You are designing an Azure Cosmos DB for NoSQL data model that will contain authors, books the authors have written, and reviews of the books. You need to maintain referential inte...

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. You need to write a SQL query that will return multiple items. The solution must meet the followi...

Drag and Drop Question You have an Azure Cosmos DB container named owners. Each item in owners represents an owner and their pets. The following is a sample of the JSON You are wri...

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

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

Drag and Drop Question You have an Azure Cosmos DB for NoSQL account. You need to implement Always Encrypted for all the data stored in the account. The solution must minimize admi...

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

You have an on-premises computer named Computer1 that runs Windows 11. On Computer1, you install the Azure Cosmos DB Emulator by using the default settings. You need to connect to...

You plan to implement an Azure Cosmos DB container that will store telemetry data from 1,000 IoT devices. The data will be updated once every minute. An app will read the data once...

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

You plan to create an Azure Cosmos DB account that will use an integrated cache. What will prevent you from using an integrated cache?

You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that hosts a container named Devices. Devices has a partition key name...

You have an Azure Cosmos DB for NoSQL container named Container1 that contains 20,000 items. The items have 1,000 unique partition key values. Each item is 50 KB. You need to evalu...

You have an Azure Cosmos DB for NoSQL container named Contained that has a provisioned throughput of 1,000 request units per second (RU/s). Contained is queried by using an app nam...

You have an Azure subscription. You plan to create an Azure Cosmos DB for NoSQL database named DB1 that will store author and book data for authors that have each published up to t...

You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that hosts a container named Container1. Container1 has a provisioned...

You have an Azure Cosmos DB for NoSQL account. The account hosts a container that has the change feed enabled. You are building an app by using the Azure Cosmos DB SDK. The app wil...

You have an Azure Cosmos DB for NoSQL container. All queries to the container use the Bounded Staleness consistency level. You discover that when many queries are executed against...

You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that uses strong consistency and is deployed to the East US, West US,...

You have an Azure Cosmos DB for NoSQL account that contains a database named DB1. Users run the following query against DB1. SELECT * FROM c WHERE c.bikeParts = "Frame, Chain, Pedd...

Drag and Drop Question You have an Azure Cosmos DB for NoSQL account named account1 that has a periodic backup policy with a four-hour backup interval and an eight-hour retention p...

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. The account hosts a container named Container1. At some point during the past 4S hours, Container...

You have an Azure Cosmos DB for NoSQL account. You configure the diagnostic settings to send all log information to a Log Analytics workspace. You need to identify when the provisi...

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 configure the diagnostic settings to send all log information to a Log Analytics workspace. You need to identify when the provisi...

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

Drag and Drop Question You have an Azure subscription that contains the resources shown in the following table. You need to create a container in db1 that has the following attribu...

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1. You plan to configure the Apache Kafka service as a data source for account1. What...