Microsoft DP-420 Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB Exam Practice Test

You have an Azure subscription that contains a resource group named RG1. RG1 contains an Azure Cosmos DB for NoSQL account named account1.

You plan to audit changes to the control plane of account1.

You need to ensure that audit events include the details of the security principal that performs each control plane change.

How should you complete the az command? 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 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 have an Azure Cosmos DB database named databaset contains a container named container1. The container1 container store product data and has the following indexing policy.

Which path will be indexed?

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:

• Support Spark queries.

• Support the analysis of data from the last six months.

• 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.

You have an Azure Cosmos DB for NoSQL database that hosts a container named Container^

You are developing a new app named App1 that will use Container 1.

You need to ensure that when App1 attempts to delete a document in Container1, the action is blocked, and an error is returned to the app.

What should you use?

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 development environment that uses multiple Azure subscriptions.

You plan to deploy a single Azure Cosmos DB account that will contain a single database in each subscription.

You need to automate the deployment by using an Azure Resource Manager (ARM) template. The solution must meet the following requirements:

• Minimize Azure Cosmos DB-related charges.

• Maximize the available request units per second (RU/s) without increasing costs.

How should you complete the template? 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 account that uses a custom conflict resolution policy. The account has a registered merge procedure that throws a runtime exception. The runtime exception prevents conflicts from being resolved.

You need to use an Azure function to resolve the conflicts. What should 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 an Azure Cosmos DB Core (SQL) API account named account 1 that uses autoscale throughput.

You need to run an Azure function when the normalized request units per second for a container in account1 exceeds a specific value.

Solution: You configure an Azure Monitor alert to trigger the function.

Does this meet the goal?

You have an Azure Cosmos DB for NoSQL database named db1 that writes to multiple Azure regions. You need to test the performance of db1 in the secondary region. Which command should you run first?

You maintain a relational database for a book publisher. The database contains the following tables.

The most common query lists the books for a given authorId.

You need to develop a non-relational data model for Azure Cosmos DB Core (SQL) API that will replace the relational database. The solution must minimize latency and read operation costs.

What should you include in the solution?

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?

You have an Azure Cosmos DB for NoSQL account.

You need to create an Azure Monitor query that lists recent modifications to the regional failover policy.

Which Azure Monitor table should you query?

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?

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

You need to use the Azure Cosmos DB SDK to replace a document by using optimistic concurrency.

What should you include in the code? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a database in an Azure Cosmos DB SQL API Core (SQL) account that is used for development.

The database is modified once per day in a batch process.

You need to ensure that you can restore the database if the last batch process fails. The solution must minimize costs.

How should you configure the backup settings? 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 database named DB1 that hosts a container named Contained. The partition key for Container! is /city.

You are developing a cloud-native app named App1 that will store customer information in DB1. App1 will perform transactional batch operations to update the items in Contained.

You need to configure App1 to meet the following requirements:

• Ensure that batch operations are rolled back if an item ' s ETag value has changed since the value was last read.

• Ensure that all operations in the batch apply to a single partition key value.

How should you complete the C# code? 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 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?

You have an Azure Cosmos DB Core (SQL) API account named storage1 that uses provisioned throughput capacity mode.

The storage1 account contains the databases shown in the following table.

The databases contain the containers shown in the following table.

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 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 are designing an Azure Cosmos DB for NoSQL solution.

You plan to create a new container named Container1 that will store product data for automotive repair pans as shown in the following table.

The data will be stored in Container! as shown in the following table

You need to recommend a data partitioning solution for the database. The solution must spread the workload to minimize I/O contention.

Which column should you recommend for the physical partition key and the logical partition key? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You configure a backup for an Azure Cosmos DB for NoSQL 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 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 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.

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?

You have an Azure Cosmos DB for NoSQL account that has multiple write regions.

You need to receive an alert when requests that target the database exceed the available request units per second (RU/s).

Which Azure Monitor signal should you use?

You have a database named db1 in an Azure Cosmos DB for NoSQL account named account1. The db1 database has a manual throughput of 4,000 request units per second (RU/s).

You need to move db1 from manual throughput to autoscale throughput by using the Azure CLI. The solution must provide a minimum of 4,000 RU/s and a maximum of 40,000 RU/s.

How should you complete the CLI statements? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have an Azure Cosmos DB Core (SQL) API account that uses a custom conflict resolution policy. The account has a registered merge procedure that throws a runtime exception.

The runtime exception prevents conflicts from being resolved.

You need to use an Azure function to resolve the conflicts.

What should you use?

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

You have an application named App1 that caches customers and must be notified when the list of customers changes.

You implement a change feed. The Time to Live settings have the default values.

You discover the following:

• Notifications for INSERT and UPDATE operations are received within 10 seconds.

• Notifications for DELETE operations are NOT received.

Which two actions should you perform to ensure that App1 receives notifications for DELETE operations? Each correct answer present part of the solution.

NOTE: Each correct selection is worth one point.

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 provision an Azure Cosmos DB for NoSQL container. You set the throughput to Autoscale, and the maximum request units per second {RU/s) to 20,000.

For how many RU/s will you be charged when the actual RU/s usage is zero?

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

What should you do to implement the conflict resolution policy.

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