Black Friday Madness- 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: fifty75ct

DP-420 Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB Questions and Answers

Questions 4

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

You need to use the Azure Cosmos DB SDK to replace a document by using optimistic concurrency.

What should you include in the code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 5

You configure multi-region writes for account1.

You need to ensure that App1 supports the new configuration for account1. The solution must meet the business requirements and the product catalog requirements.

What should you do?

Options:

A.

Set the default consistency level of accountl to bounded staleness.

B.

Create a private endpoint connection.

C.

Modify the connection policy of App1.

D.

Increase the number of request units per second (RU/s) allocated to the con-product and con-productVendor containers.

Buy Now
Questions 6

You need to select the partition key for con-iot1. The solution must meet the IoT telemetry requirements.

What should you select?

Options:

A.

the timestamp

B.

the humidity

C.

the temperature

D.

the device ID

Buy Now
Questions 7

You need to implement a solution to meet the product catalog requirements.

What should you do to implement the conflict resolution policy.

Options:

A.

Remove frequently changed field from the index policy of the con-product container.

B.

Disable indexing on all fields in the index policy of the con-product container.

C.

Set the default consistency level for account1 to eventual.

D.

Create a new container and migrate the product catalog data to the new container.

Buy Now
Questions 8

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.

Options:

Buy Now
Questions 9

You need to provide a solution for the Azure Functions notifications following updates to con-product. The solution must meet the business requirements and the product catalog requirements.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options:

A.

Configure the trigger for each function to use a different leaseCollectionPrefix

B.

Configure the trigger for each function to use the same leaseCollectionNair.e

C.

Configure the trigger for each function to use a different leaseCollectionName

D.

Configure the trigger for each function to use the same leaseCollectionPrefix

Buy Now
Questions 10

You have a database in an Azure Cosmos DB Core (SQL) API account. The database is backed up every two hours.

You need to implement a solution that supports point-in-time restore.

What should you do first?

Options:

A.

Enable Continuous Backup for the account.

B.

Configure the Backup & Restore settings for the account.

C.

Create a new account that has a periodic backup policy.

D.

Configure the Point in Time Restore settings for the account.

Buy Now
Questions 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
Questions 12

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

You plan to create a container that will store employee data for 5,000 small businesses. Each business will have up to 25 employees. Each employee item will have an emailAddress value.

You need to ensure that the emailAddress value for each employee within the same company is unique.

To what should you set the partition key and the unique key? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 13

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. The account hosts a container named Container1 that stores customer data. Each customer data item includes the customer ' s name and zero or more related business categories in an array.

You need identify customers that have one of their business categories set to " retail " . The solution must return the customerName and businessCategories fields.

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
Questions 14

You have an Azure Cosmos DB for NoSQL account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a and a read region in East US.

You run the following PowerShell command.

What is the effect of running the command?

Options:

A.

A manual failover will occur.

B.

The account will be unavailable to writes during the change.

C.

The provisioned throughput for account1 will increase.

D.

The account will be configured for multi-region writes.

Buy Now
Questions 15

You have an application named App1 that reads the data in an Azure Cosmos DB Core (SQL) API account. App1 runs the same read queries every minute. The default consistency level for the account is set to eventual.

You discover that every query consumes request units (RUs) instead of using the cache.

You verify the IntegratedCacheiteItemHitRate metric and the IntegratedCacheQueryHitRate metric. Both metrics have values of 0.

You verify that the dedicated gateway cluster is provisioned and used in the connection string.

You need to ensure that App1 uses the Azure Cosmos DB integrated cache.

What should you configure?

Options:

A.

the indexing policy of the Azure Cosmos DB container

B.

the consistency level of the requests from App1

C.

the connectivity mode of the App1 CosmosClient

D.

the default consistency level of the Azure Cosmos DB account

Buy Now
Questions 16

You provision Azure resources by using the following Azure Resource Manager (ARM) template.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 17

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
Questions 18

You have an Azure Cosmos DB for NoSQL account.

The change feed is enabled on a container named invoice.

You create an Azure function that has a trigger on the change feed.

What is received by the Azure function?

Options:

A.

all the properties of the updated items

B.

only the partition key and the changed properties of the updated items

C.

all the properties of the original items and the updated items

D.

only the changed properties and the system-defined properties of the updated items

Buy Now
Questions 19

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named accounts In account1, you create a container that has the following configurations:

• Partition key: CompanylD

• Composite unique key: UserName and EmailAddress

To the container, you plan to add the data items shown in the following table.

How many conflicts will occur?

Options:

A.

0

B.

1

C.

2

D.

3

Buy Now
Questions 20

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?

Options:

A.

a certificate

B.

a key

C.

a secret

Buy Now
Questions 21

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL database named DB1.

You develop a software as a service (SaaS) app named App1 that uses DB1. App1 will be used by multiple vendors to manage their customers.

You need to create a container in DB1 that will store customer and order details for each vendor. The solution must meet the following requirements:

• Each vendor must have a unique tenant ID.

• The performance of the container must be optimized for reads.

• Customer IDs can be duplicated across the container but must be unique for each vendor.

• The container must be optimized for concurrent queries from multiple customers. Each query will return data for a single vendor.

How should you configure the container?

Options:

A.

Add a partition key to the tenant ID and a unique key policy to the customer ID.

B.

Add hierarchical partition key on (tenant identifier, customer identifier).

C.

Add a partition key to the customer ID and a unique key policy to the tenant ID.

D.

Add hierarchical partition key on (customer identifier, tenant identifier).

Buy Now
Questions 22

You have a database in an Azure Cosmos DB for NoSQL account that is configured for multi-region writes.

You need to use the Azure Cosmos DB SDK to implement the conflict resolution policy for a container. The solution must ensure that any conflict sent to the conflict feed.

Solution: You set ConfilictResolutionMode to Custom and you use the default settings for the policy.

Does this meet the goal?

Options:

A.

Yes

B.

No

Buy Now
Questions 23

You have an Azure Cosmos DB for NoSQL account.

You need to perform detailed troubleshooting to view the deobfuscated query of all requests. What should you enable in the Azure portal?

Options:

A.

DataPlaneRequests

B.

QueryRuntimeStatistics

C.

Diagnostics full-text query

D.

ControlPlaneRequests

Buy Now
Questions 24

You have a container named container1 in an Azure Cosmos DB Core (SQL) API account.

The following is a sample of a document in container1.

{

" studentId " : " 631282 " ,

" firstName " : " James " ,

" lastName " : " Smith " ,

" enrollmentYear " : 1990,

" isActivelyEnrolled " : true,

" address " : {

" street " : " " ,

" city " : " " ,

" stateProvince " : " " ,

" postal " : " " ,

}

}

The container1 container has the following indexing policy.

{

" indexingMode " : " consistent " ,

" includePaths " : [

{

" path " : " /* "

},

{

" path " : " /address/city/? "

}

],

" excludePaths " : [

{

" path " : " /address/* "

},

{

" path " : " /firstName/? "

}

]

}

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 25

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. The account contains a database named DB1 and an Azure Key Vault named KV1.

You need to create a container named Container1 in DB1. The solution must ensure that the properties of the items in Container1 are encrypted by using Always Encrypted.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Options:

Buy Now
Questions 26

You need to configure an Apache Kafka instance to ingest data from an Azure Cosmos DB Core (SQL) API 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.

Options:

A.

" connector.class " : " com.azure.cosmos.kafka.connect.source.CosmosDBSourceConnector "

B.

" key.converter " : " org.apache.kafka.connect.json.JsonConverter "

C.

" key.converter " : " io.confluent.connect.avro.AvroConverter "

D.

" connect.cosmos.containers.topicmap " : " iot#telemetry "

E.

" connect.cosmos.containers.topicmap " : " iot "

F.

" connector.class " : " com.azure.cosmos.kafka.connect.source.CosmosDBSinkConnector "

Buy Now
Questions 27

You have an Azure Cosmos DB for NoSQL account named account1.

You have an app named App1 that connects to account1 and uses strong consistency for all requests.

You implement the Azure Cosmos DB integrated cache for account1.

You need to ensure that App1 uses the integrated cache.

What should you do?

Options:

A.

Change the request consistency level to session.

B.

Set MaxIntegratedCacheStaleness to 0.

C.

Change the request consistency level to bounded staleness.

D.

Set the connectivity mode to direct mode over TCP.

Buy Now
Questions 28

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named accounts In account1, you plan to create a container that will store the data items shown in the following table.

Each customer item will have customer sales by month values embedded.

The most executed query will return data for a matrix that aggregates the monthly sales ot each business category. The matrix will use customer business categories as columns and months as rows.

You need to configure the partition key for the container. The solution must minimize the request units (RUs) required to run th e query.

Which property should you use for the partition key?

Options:

A.

customereusinesscategoryid

B.

customerSalesForMonth

C.

customerid

D.

customerNa«e

Buy Now
Questions 29

You have an Azure Cosmos DB for NoSQL account that hosts a container named Customers. You need to add customers to Customers by using the Azure Cosmos DB Spark Connector. How should you complete the code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 30

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.

Options:

Buy Now
Questions 31

You have an Azure Cosmos DB container named container1.

You need to insert an item into contained. The solution must ensure that the item is deleted automatically after two hours.

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

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 32

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 runtime exception prevents conflicts from being resolved.

You need to use an Azure function to resolve the conflicts. What should you use?

Options:

A.

a function that pulls items from the change feed and is triggered by a timer trigger

B.

a function that receives items pushed from the conflicts feed and is triggered by an Azure Cosmos DB trigger

C.

a function that pulls items from the conflicts feed and is triggered by a timer trigger

D.

a function that receives items pushed from the change feed and is triggered by an Azure Cosmos DB trigger

Buy Now
Questions 33

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?

Options:

A.

Metrics

B.

Log

C.

Activity Log

D.

Resource Health

Buy Now
Questions 34

You have an Azure Cosmos DB for NoSQL account that contains a database named DB1. Users run the following query against DB1.

You add an index to the recordset.

You need to change the ORDER by syntax of the query to optimize the use of the index. The solution must NOT change the result set.

Which syntax should you use?

Which syntax should you use?

Options:

A.

ORDER BY c._ts MSC, c.bikeParts ASC

B.

ORDER BY c._ts ASC, c.bikeParts DESC

C.

ORDER BY c.bikeParts ASC, c._ts ASC

D.

order BY c.bikeParts DESC, c._ts ASC

Buy Now
Questions 35

You have a container named container! 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-based access The solution must use the principle of least privilege.

Which roles should you assign to User1?

Options:

A.

Cosmos DB Built-in Data Contributor only

B.

Cosmos DB Operator only

C.

DocumentDB Account Contribute only

D.

DocumentDB Account Contributor and Cosmos DB Built-in Data Contributor

Buy Now
Questions 36

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 units per second (RU/s).

Which Azure Monitor signal should you use?

Options:

A.

Region Removed

B.

Provisioned Throughput

C.

Metadata Requests

D.

Data Usage

Buy Now
Questions 37

You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. Upserts of items in container1 occur every three seconds.

You have an Azure Functions app named function1 that is supposed to run whenever items are inserted or replaced in container1.

You discover that function1 runs, but not on every upsert.

You need to ensure that function1 processes each upsert within one second of the upsert.

Which property should you change in the Function.json file of function1?

Options:

A.

checkpointInterval

B.

leaseCollectionsThroughput

C.

maxItemsPerInvocation

D.

feedPollDelay

Buy Now
Questions 38

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.

Options:

Buy Now
Questions 39

You have an Azure Cosmos DB for NoSQL account that contains a container named container1.

You plan to use container1 as a key-value store that will perform point reads on the item ID and partition key.

You need to define an indexing policy for container! The solution must meet the following requirements:

• Provide the ability to set DefauitTimeToLive for container1.

• Minimize implementation time.

• Minimize costs.

How should you complete the JSON definition of the indexing policy? 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 19, 2026
Questions: 204
DP-420 pdf

DP-420 PDF

$23.75  $94.99
DP-420 Engine

DP-420 Testing Engine

$27.5  $109.99
DP-420 PDF + Engine

DP-420 PDF + Testing Engine

$36.25  $144.99