Microsoft DP-420 Exam Dumps [2026] Practice Valid Exam Dumps Question [Q47-Q62]

QUESTION 47
Hotspot Question
You have a database named db1 in an Azure Cosmos DB for NoSQL account named account1.
The db1 database has a manual throughput of 4,000 request units per second (RU/s).
You need to move db1 from manual throughput to autoscale throughput by using the Azure CLI.
The solution must provide a minimum of 4,000 RU/s and a maximum of 40,000 RU/s.
How should you complete the CLI statements? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION 48
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?

QUESTION 49
You have an Azure Cosmos DB for NoSQL account named account that has the disablekeyBasedletadatwriteAccess property enabled.
You are developing an app named App1 that will be used by a use1 named DevUser1 to create containers in account1. DevUser1 has a non-privileged user account in the Azure AD tenant.
You need to ensure that DevUser1 can use App1 to create containers in account1.
What should you do? To answer, select the appropriate options in the answer area.
NOTE Each correct selection is worth one point.

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

QUESTION 51
You need to implement a trigger in Azure Cosmos DB Core (SQL) API that will run before an item is inserted into a container.
Which two actions should you perform to ensure that the trigger runs? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

QUESTION 52
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 integration tests that you wrote for the application. The solution must execute entirely in the pipeline.
What should you add to the pipeline?

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

QUESTION 54
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?

QUESTION 55
You have an Azure Cosmos DB Core (SQL) account that has a single write region in West Europe.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

QUESTION 56
You need to select the capacity mode and scale configuration for account2 to support the planned changes and meet the business requirements. What should you select? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

QUESTION 57
You have an Azure Cosmos DB for NoSQL container named Contacts that is configured as shown in the following exhibit.

Contacts contains the items shown in the following table.

To Contacts, you plan to insert the items shown in the following table.

For each of the following statements select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

QUESTION 58
You have an Azure Cosmos DB for NoSQL account that contains a container named Container1.
You add a composite index to the default indexing policy of Container1. The index has the following definition.
FirstName ASC, age ASC
You plan to execute the following query against Container1.

You need to optimize the performance of the query by adding an additional index.
How should you complete the additional index? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.

QUESTION 59
You are developing an application that will connect to an Azure Cosmos DB for NoSQL account. The account has a single readme region and one agonal read region. The regions are configured for automatic failover.
The account has the following connect strings. (Line numbers are included for reference only.)

For each of the following statements, select Yes if the statement is true. otherwise, select No.
NOTE: Each correct selection is worth one point.

QUESTION 60
Hotspot Question
You have an Azure subscription that contains the resources shown in the following table.

You plan to use multiple SELECT statements to query Container1 by using the built-in SQL pool of Synapse1.
You need to meet the following requirements:
– Store the key for account1 in Synapse1 for use in the SELECT
– Designate the analytical store in the FROM clause of the SELECT
What should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION 61
You have an Azure Cosmos DB Core (SQL) API account named account1.
In account1, you run the following query in a container that contains 100GB of data.
SELECT *
FROM c
WHERE LOWER(c.categoryid) = “hockey”
You view the following metrics while performing the query.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

QUESTION 62
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 solution must meet the following requirements:
– In the write region, writes must replicate synchronously across at
least three replicas.
– In the read regions, reads must see writes in order for transactional batches.
– Throughput for reads and writes must be maximized.
Which consistency level should you select?