Free Microsoft DP-420 Exam Questions

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

You have an Azure Cosmos DB for NoSQL account configured for global distribution across four regions.

At connection time, the SQL SDK needs to identify the optimal endpoint for reading and writing.

Which two factors can influence the SDK? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You have a container of books with JSON documents that have a string property named title. The JSON documents also have a property named tags which is an array of string values. You need to authorize a SQL query that will create a cross-product of the document titles and tags. Which of the following SQL query would you use?

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 result, 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 DB 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 Custom. You set ResolutionProcedure to a custom

stored procedure. You configure the custom stored procedure to use the isTombstone parameter to resolve

conflicts.

Does this meet the goal?