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

You have a container in an Azure Cosmos DB for NoSQL account. The database that has a manual throughput of 30,000 request units per second (RU/s). The current consumption details are shewn in the following chart.

Normalized RU Consumption (%) By PartitionKeyRangeID

Use the drop-down menus to select the answer choice that answers each question 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 named account1 that stores loT telemetry from 50.000 devices across 10 distinct. Each device writes one 1-KB document per second, Each document includes three properties named deviceld, districtld-. and tinestamp.

You need to implement a partitioning solution that meets the following requirements:

* Ensures that queries for a single device remain routable without scanning all the partitions *Ensures that no single device5 data can exceed the logical partition limit of account1

* Prevents concentrating all the writes for a time window into a single logical partition

What should you configure? To answer, select the appropriate options in the answer area

NOTE: Each correct selection is worth one point.

You are creating a database in an Azure Cosmos DB Core (SQL) API account. The database will be used by an application that will provide users with the ability to share online posts. Users will also be able to submit comments on other users ' posts.

You need to store the data shown in the following table.

The application has the following characteristics:

Users can submit an unlimited number of posts.

The average number of posts submitted by a user will be more than 1,000.

Posts can have an unlimited number of comments from different users.

The average number of comments per post will be 100, but many posts will exceed 1,000 comments.

Users will be limited to having a maximum of 20 interests.

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

NOTE: Each correct selection is worth one point.

You have the following query.

SELECT * FROM с

WHERE c.sensor = " TEMP1 "

AND c.value < 22

AND c.timestamp > = 1619146031231

You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by the query.

What should you recommend?

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

You plan to deploy two Azure Cosmos DB Core (SQL) API accounts that will each contain a single database. The accounts will be configured as shown in the following table.

How should you provision the containers within each account to minimize costs? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB for NoSQL container.

All queries to the container use the Bounded Stateness consistency level.

You discover that when many queries are executed against the container, an HTTP 429 error is returned.

What are two ways to reduce the number of HTTP 429 errors? Each correct answer presents a complete solution.

NOTE Each correct selection is worth one point.

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?

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.

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?

You plan to create an Azure Cosmos DB for NoSQL account that will have a single write region and three read regions. You need to set the consistency level for the account. The solution must meet the following requirements:

• In the write region, writes must replicate synchronously across at least three replicas.

• In the read regions, reads must see writes in order for transactional batches.

• Throughput for reads and writes must be maximized.

Which consistency level should you select?

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

You add a composite index to the default indexing policy of Container1. The index has the following definition.

FirstName ASC, age ASC

You plan to execute the following query against Container1.

You need to optimize the performance of the query by adding an additional index.

How should you complete the additional index? To answer, select the appropriate options in the answer area

NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB account named Account1 that has the East US Azure region as the write region and the West Europe Azure region as the read region.

Vou plan to perform a disaster recovery drill. As part of the drill, you will promote the West Europe region as the new write region.

You install the Az-CosmosDB PowerShetl module and verify the configuration and redundancy settings of Account1.

You need to initiate a failover.

What should you do for Account1 before initiating the failover?

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL database named DB1. The shared throughput provisioned for DB1 is 10,000 DTU/s. DB1 contains the containers shown in the following table.

You need to modify the throughput for the containers. The solution must meet the following requirements:

• The maximum throughput for Container1 must be 4,000 DTU/s.

• The throughput for Contained must be shared across the containers.

• Administrative effort must be minimized.

What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

You plan to implement con-iot1 and con-iot2.

You need to configure the default Time to Live setting for each container. The solution must meet the loT telemetry requirements.

What should you configure? To answer, select the appropriate options in the answer NOTE: Each correct selection is worth one point.

You need to implement a trigger in Azure Cosmos DB Core (SQL) API that will run before an item is inserted into a container.

Which two actions should you perform to ensure that the trigger runs? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB for NoSQL account named account! that has a periodic backup policy with a four-hour backup interval and an eight-hour retention period. The account account contains a single database named db1 and containers that have stored procedures.

An administrator deletes db1 accidentally.

You need to ensure that the contents of db1, including all of its items, is available as soon as possible.

How should you perform the procedure? To answer, drag the missing actions to the correct order. Each action 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 have an Azure Cosmos DB database that hosts a container named container1.

You need to ensure that the items stored in contained will NOT expire unless their TTL value is set explicitly. What should you do?

You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account

You need to write a SQL query that will return multiple items. The solution must meet the following requirements:

• For each item returned, include the current Coordinated Universal Time (UTC) date and time, formatted as an ISO 8601 string.

• Minimize development effort.

What should you use?

You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that hosts a container named Devices. Devices has a partition key named type.

You are evaluating the resource utilization of the query. How will the query be executed?

You have a database named db1 in an Azure Cosmos DB for NoSQL

You are designing an application that will use dbl.

In db1, you are creating a new container named coll1 that will store in coll1.

The following is a sample of a document that will be stored in coll1.

The application will have the following characteristics:

• New orders will be created frequently by different customers.

• Customers will often view their past order history.

You need to select the partition key value for coll1 to support the application. The solution must minimize costs.

To what should you set the partition key?

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 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 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 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 implement a solution to meet the product catalog requirements.

What should you do to implement the conflict resolution policy.