Practice Free DP-420 Exam Online Questions
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 by using service principals.
You need to ensure that account1 will only allow apps to connect by using an Azure AD identity.
Which account property should you modify?
- A . disableKeyBasedMetadataWriteAccess,
- B . disableLocalAuth
- C . userAssignedldentatxe
- D . allowedOrxgins
DRAG DROP
You have an Azure Cosmos DB for NoSQL database that hosts a container named Container1.
Container1 stores customer documents that have the following structure.
You need to retrieve the city of residence and the age of each customer who is older than 40.
Which three statements should you run in sequence to build the query? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.
You have an Azure Cosmos DB for NoSQL database named db1 that is monitored by using Azure Monitor. You need to identify the operations that have the highest throughput.
Which metric should you use?
- A . Data Usage
- B . Autoscale Max Throughput
- C . Index Usage
- D . Total Request Units
You have an Azure Cosmos DB for NoSQL database that hosts the containers shown in the following table.
You need to ensure that when a product name changes in the Products container, the product name changes in all orders that have NOT been shipped.
What should you implement?
- A . a change feed
- B . a post-trigger
- C . a pre-trigger
- D . a stored procedure
You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account! that hosts a container named Container 1. Container! has a provisioned throughput of 100 request units per second (RU/s) and uses a single physical partition. Vou are evaluating the available throughput for Container1.
What is the maximum burst capacity that Container1 can accumulate?
- A . 300 RU/s
- B . 1,000 RU/s
- C . 30,000 RU/s
- D . 100.000 RU/s
HOTSPOT
You have a database in an Azure Cosmos DB SQL API Core (SQL) account that is used for development.
The database is modified once per day in a batch process.
You need to ensure that you can restore the database if the last batch process fails. The solution must minimize costs.
How should you configure the backup settings? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
HOTSPOT
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL database named DB1. The shared throughput provisioned for DB1 is 10,000 DTU/s.
DB1 contains the containers shown in the following table.
You need to modify the throughput for the containers.
The solution must meet the following requirements:
• The maximum throughput for Container1 must be 4,000 DTU/s.
• The throughput for Contained must be shared across the containers.
• Administrative effort must be minimized.
What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Litware plans to make multi-region writes to Cosmos DB.
Which of the following should be configured to maximize App1’s query performance after enabling multi-region writes?
- A . Increase RU/s allocation for all containers
- B . Create additional read regions
- C . Increase the number of Azure Functions
- D . Set the default consistency level to bounded staleness
DRAG DROP
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 writing a query that will retrieve the average age of each pet owned by each owner, il the pet is older than two years.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes 01 scroll to view content. NOTE: Each correct selection is worth one point.
HOTSPOT
You have an Azure Resource Manager (ARM) template that provisions Azure Cosmos DB accounts and databases. The accounts are deployed to a single Azure region. The databases have provisioned throughput configured. The name of the region, the type of database throughput, and the throughput value are defined as template parameters.
You need to modify some of the Azure Cosmos DB accounts and databases based on the following scenarios:
• Scenario 1: Add a read region and increase the database throughput.
• Scenario 2: Change the provisioned database throughput to autoscale.
The solution must minimize administrative effort and the duration of the modifications.
What should you use for each scenario? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
