Microsoft DP-420 Exam Dumps

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. You Set ResolutionProcedures to a custom stored procedure. You configure the custom stored procedure to use the conflictingItems parameter to resolve conflict.

Does this meet the goal?

Show Answer Hide Answer

You have a container m an Azure Cosmos DB for NoSQL account. The container stores data about families. Data about parents, children, and pets are stored as separate documents.

Each document contains the address of each family. Members of the same family share the same partition key named family Id

You need to update the address for each member of the same family that share the same address. The solution must meet the following requirements:

* Be atomic consistent isolated, and durable (ACID).

* Provide the lowest latency.

What should you do?

Show Answer Hide Answer

You plan to create an Azure Cosmos DB database named db1 that will contain two containers. One of the containers will contain blog posts, and the other will contain users. Each item in the blog post container will include:

* A single blog post

* All the comments associated to the blog post

* The names of the users who created the blog post and added the comments to the blog post

Items in the blog post container will be partitioned based on the post ID. Items in the user container will be partitioned based on the user ID.

You need to minimize the number of request units allocated to queries that list all the posts of a given user. The solution must minimize administrative and development effort

What should you include in the solution?

Show Answer Hide Answer

The following is a sample of a document in orders.

The orders container uses customer as the partition key.

You need to provide a report of the total items ordered per month by item type. The solution must meet the following requirements:

Ensure that the report can run as quickly as possible.

Minimize the consumption of request units (RUs).

What should you do?

Show Answer Hide Answer

You have a container in an Azure Cosmos DB Core (SQL) API account. The container stores telemetry data from IoT devices. The container uses telemetryId as the partition key and has a throughput of 1,000 request units per second (RU/s). Approximately 5,000 IoT devices submit data every five minutes by using the same telemetryId value.

You have an application that performs analytics on the data and frequently reads telemetry data for a single IoT device to perform trend analysis.

The following is a sample of a document in the container.

You need to reduce the amount of request units (RUs) consumed by the analytics application.

What should you do?

Show Answer Hide Answer