Microsoft DP-420 Actual Free Exam Questions & Community Discussion
Hotspot Question
You have a database in an Azure Cosmos DB Core (SQL) API account.
You plan to create a container that will store employee data for 5,000 small businesses. Each business will have up to 25 employees. Each employee item will have an emailAddress value.
You need to ensure that the emailAddress value for each employee within the same company is unique.
To what should you set the partition key and the unique key? 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 Core (SQL) API account.
You plan to create a container that will store employee data for 5,000 small businesses. Each business will have up to 25 employees. Each employee item will have an emailAddress value.
You need to ensure that the emailAddress value for each employee within the same company is unique.
To what should you set the partition key and the unique key? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Box 1: CompanyID
After you create a container with a unique key policy, the creation of a new or an update of an existing item resulting in a duplicate within a logical partition is prevented, as specified by the unique key constraint. The partition key combined with the unique key guarantees the uniqueness of an item within the scope of the container.
For example, consider an Azure Cosmos container with Email address as the unique key constraint and CompanyID as the partition key. When you configure the user's email address with a unique key, each item has a unique email address within a given CompanyID. Two items can't be created with duplicate email addresses and with the same partition key value.
Box 2: emailAddress
UniqueKey will need to be set to emailAddress, since the job of a unique key is to ensure uniqueness of a value within a logical partition.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/unique-keys
You have an Azure Cosmos DB account named account1 that contains a database named DB1 and a container name Container1. account1 uses the Core (SQL) API.
You have an app named App1 that stores a large volume of data in Container1. The data is partitioned by using the int1 attribute. The items stored in Container1 have the following format.
App1 runs the following query.
You need to recommend a solution to minimize the required request units (RUs) when performing read and write operations. What should you recommend?
You have an app named App1 that stores a large volume of data in Container1. The data is partitioned by using the int1 attribute. The items stored in Container1 have the following format.
App1 runs the following query.
You need to recommend a solution to minimize the required request units (RUs) when performing read and write operations. What should you recommend?
Correct Answer: D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
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 function that uses Azure Cosmos DB for NoSQL change feed as a trigger and Azure event hub as the output.
Does this meet the goal?
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 function that uses Azure Cosmos DB for NoSQL change feed as a trigger and Azure event hub as the output.
Does this meet the goal?
Correct Answer: A
Vote an answer
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL database named db1. The subscription is linked to a Microsoft Entra tenant that contains a user named User1.
You need to delegate permissions to User1 to meet the following requirements:
- Ensure that User1 can manage db1.
- Prevent User1 from accessing connection strings.
- Prevent User1 from accessing the data stored in db1.
Which role should you assign to User1?
You need to delegate permissions to User1 to meet the following requirements:
- Ensure that User1 can manage db1.
- Prevent User1 from accessing connection strings.
- Prevent User1 from accessing the data stored in db1.
Which role should you assign to User1?
Correct Answer: B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You plan to create an Azure Cosmos DB for NoSQL 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 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.
Correct Answer: B,C,G
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You plan to create an operational system that will store data in an Azure Cosmos DB Core (SQL) API 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 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.
Correct Answer: A,B,F
Vote an answer
Drag and Drop Question
You have an Azure Cosmos DB for NoSQL database that hosts a container named Container1.
Container1 stores customer documents that have the following structure.
You need to retrieve the city of residence and the age of each customer who is older than 40.
Which three statements should you run in sequence to build the query? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.
You have an Azure Cosmos DB for NoSQL database that hosts a container named Container1.
Container1 stores customer documents that have the following structure.
You need to retrieve the city of residence and the age of each customer who is older than 40.
Which three statements should you run in sequence to build the query? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.
Correct Answer:
You have a container in an Azure Cosmos DB for NoSQL account.
You need to create an alert based on a custom Log Analytics query.
Which signal type should you use?
You need to create an alert based on a custom Log Analytics query.
Which signal type should you use?
Correct Answer: D
Vote an answer
Hotspot Question
You have an Azure Cosmos DB for NoSQL account named account1. account1 hosts a container named Container1 that has provisioned throughput.
You have an app named App1 that uses Container1.
You use Azure Monitor to review the performance and capacity of account1.
Users report intermittent request failures during peak traffic, and the logs for App1 show an HTTP
429 Too many requests error.
You need to identify whether a hot physical partition is causing uneven throughput consumption.
What should you use in Azure Cosmos DB Insights? 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. account1 hosts a container named Container1 that has provisioned throughput.
You have an app named App1 that uses Container1.
You use Azure Monitor to review the performance and capacity of account1.
Users report intermittent request failures during peak traffic, and the logs for App1 show an HTTP
429 Too many requests error.
You need to identify whether a hot physical partition is causing uneven throughput consumption.
What should you use in Azure Cosmos DB Insights? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
You develop an application that uses Azure Cosmos DB Core (SQL) API.
You create an Azure pipeline to build and deploy the application.
You need to change the pipeline to run integration tests that you wrote for the application. The solution must execute entirely in the pipeline.
What should you add to the pipeline?
You create an Azure pipeline to build and deploy the application.
You need to change the pipeline to run integration tests that you wrote for the application. The solution must execute entirely in the pipeline.
What should you add to the pipeline?
Correct Answer: B
Vote an answer
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 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?
Correct Answer: B
Vote an answer
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 select the partition key for con-iot1. The solution must meet the IoT telemetry requirements.
What should you select?
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 select the partition key for con-iot1. The solution must meet the IoT telemetry requirements.
What should you select?
Correct Answer: D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
0
0
0
10