DP-420 Online Practice Questions and Answers

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?

A. Yes

B. No

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:

1.

Be atomic consistent isolated, and durable (ACID).

2.

Provide the lowest latency. What should you do?

A. Update the document of each family member by using a transactional batch operation.

B. Update the document of each family member separately by using a patch operation.

C. Update the document of each family member separately and set the consistency level to strong.

You have a global ecommerce application that stores data in an Azure Cosmos OB for NoSQL account. The account is contoured for multi-region writes.

You need to create a stored procedure for a custom conflict resolution policy for a new container.

In the event of a conflict caused by a deletion the deletion must always take priority.

Which parameter should you check m the stored procedure function?

A. conf1ictingItems

B. is Tombstone

C. existingitem

D. incoming1tem

You plan to create an operational system that will store data in an Azure Cosmos OB 'or NoSQL account. You need to configure the account to meet the following requirements:

1.

Support Spar* queries.

2.

Support the analysis of data from the last six months.

3.

Only pay for analytical compute when running queries.

Which three actions should you perform?

Each correct answer presents part of the solution. NOTE Each correct selection is worth one point.

A. Create an Azure Synapse linked service.

B. Create a container and set the time to live to six months.

C. Create a container and set the analytical property to six months.

D. Create an Azure Synapse pipeline.

E. Create an Azure Databanks notebook.

F. Enable Azure Synapse Link for the account

You have an Azure Cosmos DB for NoSQL account named account1 that has a single read-write region and one additional read region.

Account1 uses the strong default consistency level.

You have an application that uses the eventual consistency level when submitting requests to account1.

How will writes from the application be handled?

A. Writes will use the strong consistency level.

B. Azure Cosmos DB will reject writes from the application.

C. The write order is not guaranteed during replication.

D. Writes will use the eventual consistency level.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result1 these questions will not appear in the review screen.

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 OB SDK to implement the conflict resolution policy for a container. The solution must ensure that any conflicts are sent to the conflicts feed.

Solution: You set ConflictResolutionMode to Laswriterwins and you use the default settings for the policy.

Does this meet the goal?

A. Yes

B. No

You need to create a data store for a directory of small and medium-sized businesses (SMBs). The data store must meet the following requirements:

1.

Store companies and the users employed by them. Each company will have less than 1,000 users.

2.

Some users have data that is greater than 2 KB.

3.

Associate each user to only one company.

4.

Provide the ability to browse by company.

5.

Provide the ability to browse the users by company.

6.

Whenever a company or user profile is selected, show a details page for the company and all the related users.

7.

Be optimized for reading data.

Which design should you implement to optimize the data store for reading data?

A. In a directory container, create a document for each company and a document for each user. Use company ID as the partition key.

B. In a company container, create a document for each company. Embed the users into company documents. Use the company ID as the partition key.

C. Create a user container that uses the user ID as the partition key and a company container that container that uses the company ID as the partition key. Add the company ID to each user documents.

D. In a user container, create a document for each user. Embed the company into each user document. Use the user ID as the partition key.

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?

A. Enable Continuous Backup for the account.

B. Configure the Backup and 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.

You plan to create an Azure Cosmos DB Core (SQL) API account that will use customer-managed keys stored in Azure Key Vault.

You need to configure an access policy in Key Vault to allow Azure Cosmos DB access to the keys.

Which three permissions should you enable in the access policy? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. Wrap Key

B. Get

C. List

D. Update

E. Sign

F. Verify

G. Unwrap Key

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

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

You need to make the contents of container1 available as reference data for an Azure Stream Analytics job.

Solution: You create an Azure Synapse pipeline that uses Azure Cosmos DB Core (SQL) API as the input and Azure Blob Storage as the output.

Does this meet the goal?

A. Yes

B. No

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?

A. Decrease the offerThroughputvalue for the container.

B. Increase the offerThroughputvalue for the container.

C. Move the data to a new container that has a partition key of deviceId.

D. Move the data to a new container that uses a partition key of date.

You have an Azure Cosmos DB database.

You plan to create a new container named container1 that will store product data and product category data and will primarily support read requests.

You need to configure a partition key for container1. The solution must meet the following requirements:

Minimize the size of the partition.

Minimize maintenance effort.

Which two characteristics should you prioritize? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. unique

B. high cardinality

C. low cardinality

D. static

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?

A. Log

B. Metrics

C. Activity Log

D. Resource Health

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?

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.

You need to implement a solution to meet the product catalog requirements. What should you do to implement the conflict resolution policy.

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.