Black Friday Mega Drop - Up to 75% Off Best Sellers - Ends in 0d 00h 00m 00s - Coupon code: certbig75

DP-420 Exam Dumps - Microsoft Certified: Azure Cosmos DB Developer Specialty Questions and Answers

Question # 4

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.

Options:

A.

Append pre to the name of the JavaScript function trigger.

B.

For each create request, set the access condition in RequestOptions.

C.

Register the trigger as a pre-trigger.

D.

For each create request, set the consistency level to session in RequestOptions.

E.

For each create request, set the trigger name in RequestOptions.

Buy Now
Question # 5

You have the following query.

SELECT * FROM с

WHERE c.sensor = " TEMP1 "

AND c.value < 22

AND c.timestamp > = 1619146031231

You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by the query.

What should you recommend?

Options:

A.

a composite index for (sensor ASC, value ASC) and a composite index for (sensor ASC, timestamp ASC)

B.

a composite index for (sensor ASC, value ASC, timestamp ASC) and a composite index for (sensor DESC, value DESC, timestamp DESC)

C.

a composite index for (value ASC, sensor ASC) and a composite index for (timestamp ASC, sensor ASC)

D.

a composite index for (sensor ASC, value ASC, timestamp ASC)

Buy Now
Question # 6

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

Which columns can be indexed by using spatial indexes?

Options:

A.

Col1 only

B.

Col1 and Col2 only

C.

Col1, Col2, and Col3 only

D.

Col1, Col2, and CoI4 only

Buy Now
Question # 7

You have operational data in an Azure Cosmos OB for NoSQL database.

Database users report that the performance of the database degrades significantly when a business analytics team runs large Apache Spark-based queries against the database.

You need 10 reduce the impact that running the Spark-based queries has on the database users.

What should you implement?

Options:

A.

Azure Synapse Link

B.

a default consistency level of Consistent Prefix

C.

a default consistency level of Strong

D.

the Spark connector

Buy Now
Question # 8

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 should you query?

Options:

A.

CDBPartitionKeyStatistics

B.

CDBQueryRunTimeStatistics

C.

CDBDataPlaneRequests

D.

CDBControlPlaneRequests

Buy Now
Question # 9

You have a database in an Azure Cosmos DB Core (SQL) API account.

You need to create an Azure function that will access the database to retrieve records based on a variable named accountnumber. The solution must protect against SQL injection attacks.

How should you define the command statement in the function?

Options:

A.

cmd = " SELECT * FROM Persons pWHERE p.accountnumber = ' accountnumber ' "

B.

cmd = " SELECT * FROM Persons pWHERE p.accountnumber = LIKE @accountnumber "

C.

cmd = " SELECT * FROM Persons pWHERE p.accountnumber = @accountnumber "

D.

cmd = " SELECT * FROM Persons pWHERE p.accountnumber = ' " + accountnumber + " ' "

Buy Now
Question # 10

You have a database in an Azure Cosmos DB for NoSQL account. The database contains a container named container1. The indexing mode container1 is set to none. You configure Azure Cognitive Search to extract data from container1 and make the data searchable. You discover that the Cognitive Search index is missing all the data from the Azure Cosmos DB index. What should you do to resolve the issue?

Options:

A.

Modify The index attributes in Cognitive Search to searchable.

B.

Modify the index attributes in Cognitive Search to Retrievable.

C.

Change the indexing mode of container 1 to consistent-

D.

Modify the indexing policy of container 1 to exclude the / * path

Buy Now
Question # 11

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. What should you do?

Options:

A.

List the physical partitions of Container1.

B.

Read a stored procedure in Container1.

C.

Create a user defined function (UDF) in Container1.

D.

Create a container in DB1.

Buy Now
Question # 12

You are troubleshooting the current issues caused by the application updates.

Which action can address the application updates issue without affecting the functionality of the application?

Options:

A.

Enable time to live for the con-product container.

B.

Set the default consistency level of account1 to strong.

C.

Set the default consistency level of account1 to bounded staleness.

D.

Add a custom indexing policy to the con-product container.

Buy Now
Question # 13

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1 and a Log Analytics workspace named Workspace1. Workspace 1 stores the logs of account1.

You need to identify which operations used the most request units per second (RU/s) during the last 24 hours.

How should you complete the query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point

Options:

Buy Now
Exam Code: DP-420
Exam Name: Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB
Last Update: Nov 17, 2026
Questions: 204
DP-420 pdf

DP-420 PDF

$25  $99.99
DP-420 Engine

DP-420 Testing Engine

$28.75  $114.99
DP-420 PDF + Engine

DP-420 PDF + Testing Engine

$37.5  $149.99