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

You plan to store order data in Azure Cosmos DB for NoSQL account. The data contains information about orders and their associated items.

You need to develop a model that supports order read operations. The solution must minimize the number or requests.

You have an Azure Cosmos DB container named owners. Each item in owners represents an owner and their pets. The following is a sample of the JSON

You are writing a query that will retrieve the average age of each pet owned by each owner, il the pet is older than two years.

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes 01 scroll to view content.

NOTE: Each correct selection is worth one point.

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?

You have an Azure Cosmos DB for NoSQL container named Container1 that has a provisioned throughput of 1.000 request units per second (RU/s). Container1 is queried by using an app named App1.

Users of App1 report that several times a day, they receive the following error message: " HTTP error code 429. " You need to improve the reliability of App1 without affecting the performance of the app. What are two ways to improve the reliability? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

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 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?

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?

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

You need to provide a user named User1 with the ability to insert items into container1 by using role-based access control (RBAC). The solution must use the principle of least privilege.

Which roles should you assign to User1?

The settings for a container in an Azure Cosmos DB Core (SQL) API account are configured as shown in the following exhibit.

Which statement describes the configuration of the container?

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?

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

In account 1, you plan to create a container named container1 that will contain data continuously collected from sell-driving cars. The items in container! will be accessed mostly by using queries that target data collected from a specific car during a given day. Each car is identifiable by using a property named Vehicle-Identification-Number.

You need to identify a partition strategy for container1. The strategy must meet the following requirements:

• Maximize read and write performance.

• Minimize the costs of data reads and writes.

What should you identify?

You have an Azure subscription that contains the resources shown in the following table.

You need to configure the sink connector for KafkaConnect1 to deliver messages from Topic1 to Container1.

How should you configure the value converter for the sink connector? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You plan to use a multi-region Azure Cosmos DB for NoSQL account to store data for a new application suite. The suite contains the applications shown in the following table.

Each application should use the weakest consistency level possible.

Which consistency level should you configure for each application? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

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.

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?

You have an Azure subscription.

You plan to implement an Azure Cosmos DB for NoSQL single-region write account named account1 that will replicate across two Azure regions.

You need to set the default consistency level for account1. The solution must meet the following requirements:

• Writes must be performed to a local majority in a single region.

• Reads must be performed from a local minority in a single region.

Which consistency level should you select?

You have an Azure Cosmos DB for NoSQL account.

You need to implement Always Encrypted for all the data stored in the account. The solution must minimize administrative effort.

At which level should you define the encryption policy and set the data encryption key? To answer, drag the appropriate levels to the correct requirements. Each level may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

You configure Azure Cognitive Search to index a container in an Azure Cosmos DB Core (SQL) API account as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB for NoSQL account. The account hosts a container that has the change feed enabled. You are building an app by using the Azure Cosmos DB SDK. The app will read items from the change feed by using a pull model. You need to ensure that multiple threads can read the change feed in parallel. What should you include?

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.

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

What should you do to implement the conflict resolution policy.

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.

You need to identify which connectivity mode to use when implementing App2. The solution must support the planned changes and meet the business requirements.

Which connectivity mode should you identify?

You need to recommend indexes for con-product and con-productVendor. The solution must meet the product catalog requirements and the business requirements.

Which type of index should you recommend for each container? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

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

What should you select?

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?

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?