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

QUESTION NO: 1
Case Study 1 - Litware, inc
Overview
Litware, Inc. is a United States-based grocery retailer. Litware has a main office and a primary datacenter in Seattle. The company has 50 retail stores across the United States and an emerging online presence. Each store connects directly to the internet. Existing environment.
Cloud and Data Service Environments. Litware has an Azure subscription that contains the resources shown in the following table.

Each container in productdb is configured for manual throughput. The con-product container stores the company's product catalog data. Each document in con-product includes a con- productvendor value. Most queries targeting the data in con-product are in the following format.
SELECT * FROM con-product p WHERE p.con-productVendor - 'name'
Most queries targeting the data in the con-productVendor container are in the following format SELECT * FROM con-productVendor pv ORDER BY pv.creditRating, pv.yearFounded Existing environment.
Current Problems.
Litware identifies the following issues:
- Updates to product categories in the con-productVendor container do not propagate automatically to documents in the con-product container.
- Application updates in con-product frequently cause HTTP status code 429 "Too many requests".
- You discover that the 429 status code relates to excessive request unit (RU) consumption during the updates.
Requirements.
Planned Changes
Litware plans to implement a new Azure Cosmos DB for NoSQL account named account2 that will contain a database named iotdb. The iotdb database will contain two containers named con- iot1 and con-iot2.
Litware plans to make the following changes:
- Store the telemetry data in account2.
- Configure account1 to support multiple read-write regions.
- Implement referential integrity for the con-product container.
- Use Azure Functions to send notifications about product updates to different recipients.
- Develop an app named App1 that will run from all locations and query the data in account1.
- Develop an app named App2 that will run from the retail stores and query the data in account2.
- App2 must be limited to a single DNS endpoint when accessing account2.
Requirements.
Business Requirements
Litware identifies the following business requirements:
- Whenever there are multiple solutions for a requirement, select the solution that provides the best performance, as long as there are no additional costs associated.
- Ensure that Azure Cosmos DB costs for IoT-related processing are predictable.
- Minimize the number of firewall changes in the retail stores.
Requirements.
Product Catalog Requirements
Litware identifies the following requirements for the product catalog:
- Implement a custom conflict resolution policy for the product catalog data.
- Minimize the frequency of errors during updates of the con-product container.
- Once multi-region writes are configured, maximize the performance of App1 queries against the data in account1.
- Trigger the execution of two Azure functions following every update to any document in the con- product container.
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?

QUESTION NO: 2
Hotspot Question
You plan to create a container named Container1 in an Azure Cosmos DB for NoSQL account.
Container1 will store items that contain user sign-in session data from multiple organizations.
Each user is assigned to a single organization.
Container1 will include the following properties:
- UserId
- SessionId
- SessionStart
- OrganizationID
The following are common queries served by Container1.
SELECT SessionID,SessionStart,UserID FROM c WHERE OrganizationId = 6 AND UserId =
50143
SELECT SessionID,SessionStart,UserID FROM c WHERE OrganizationId = 6
You need to recommend a partitioning scheme for Container1 that meets the following requirements:
- Maximizes performance
- Minimizes the cost of read queries
- Minimizes the possibility of reaching the partition size limits
Which type of partition key and which partition key properties should you include in the recommendation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION NO: 3
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 for NoSQL account named account1 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 Azure Event Grid to send events to the function by using an Event Grid trigger in the function.
Does this meet the goal?

QUESTION NO: 4
You are designing an Azure Cosmos DB for NoSQL solution to store data from IoT devices.
Writes from the devices will occur every second. Data will be retained indefinitely.
The following is a sample of the data.

You need to select a partition key that meets the following requirements for writes:
- Minimizes the partition skew
- Avoids capacity limits
- Avoids hot partitions
What should you do?

QUESTION NO: 5
Hotspot Question
You have an Azure Cosmos DB for NoSQL account that contains a container named container1.
You plan to use container1 as a key-value store that will perform point reads on the item ID and partition key.
You need to define an indexing policy for container1. The solution must meet the following requirements:
- Provide the ability to set DefaultTimeToLive for container1.
- Minimize implementation time.
- Minimize costs.
How should you complete the JSON definition of the indexing policy? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION NO: 6
You have a database in an Azure Cosmos DB for NoSQL 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?

QUESTION NO: 7
You have an application that queries an Azure Cosmos DB for NoSQL account.
You discover that the following two queries run frequently.

You need to minimize the request units (RUs) consumed by reads and writes.
What should you create?

QUESTION NO: 8
You have a database in an Azure Cosmos DB for NoSQL account. The database contains a container named container1. The indexing mode of 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?

QUESTION NO: 9
You have an Azure Cosmos DB for NoSQL account named account1.
You plan to implement a multi-region write scenario.
You enable multi-region writes for account1.
Which two actions should you perform next? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.

QUESTION NO: 10
Hotspot Question
You have an Azure Cosmos DB for NoSQL account named account1.
You need to disable key-based authentication for account1.
How should you complete the Azure Command-Line Interface (CLI) script? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION NO: 11
You have an Azure Cosmos DB account named account1 that uses the Core (SQL) API.
You have a web service that receives JSON-based messages.
You need to recommend a solution that will process and store the messages in a container in account1. The solution must minimize latency.
What should you include in the recommendation?

QUESTION NO: 12
Hotspot Question
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. The account contains a container named Container1 that stores product data and stock level information.
You need to implement a stored procedure that will accept the following parameters:
- productid
- productName
- initialStockLevel
The solution must create the following:
- An item that contains the product data
- An item that contains the stock level data of each product
How should you complete the stored procedure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

QUESTION NO: 13
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?