Microsoft DP-420 Actual Free Exam Questions & Community Discussion
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 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?
Correct Answer: C
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
The settings for a container in an Azure Cosmos DB for NoSQL account are configured as shown in the following exhibit.
Which statement describes the configuration of the container?
Which statement describes the configuration of the container?
Correct Answer: C
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Gateway mode using the dedicated gateway is one of the ways to connect to an Azure Cosmos DB account. Which of the following statement(s) is/are true about a dedicated gateway?
Correct Answer: D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Hotspot Question
You have an Azure Cosmos DB for NoSQL account named Account1 that uses provisioned throughput capacity mode.
Account1 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 that uses provisioned throughput capacity mode.
Account1 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.
Correct Answer:
Drag and Drop Question
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. The account contains a database named DB1 and an Azure Key Vault named KV1.
You need to create a container named Container1 in DB1. The solution must ensure that the properties of the items in container1 are encrypted by using Always Encrypted.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You have an Azure subscription that contains an Azure Cosmos DB for NoSQL account. The account contains a database named DB1 and an Azure Key Vault named KV1.
You need to create a container named Container1 in DB1. The solution must ensure that the properties of the items in container1 are encrypted by using Always Encrypted.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Correct Answer:
You have an Azure Cosmos DB account named account1.
You have several apps that connect to account1 by using the account's secondary key.
You then configure the apps to authenticate by using service principals.
You need to ensure that account1 will only allow apps to connect by using an Azure AD identity.
Which account property should you modify?
You have several apps that connect to account1 by using the account's secondary key.
You then configure the apps to authenticate by using service principals.
You need to ensure that account1 will only allow apps to connect by using an Azure AD identity.
Which account property should you modify?
Correct Answer: D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Hotspot Question
You have an Azure Cosmos DB container named container1 that has a provisioned throughput and two physical partitions.
You monitor the following metrics for container1:
- Normalized RU consumption
- The percentage of requests that have an HTTP status code of 429
You need to confirm that contained is configured to maximize resource utilization.
What are the optimal values for each metric? 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 that has a provisioned throughput and two physical partitions.
You monitor the following metrics for container1:
- Normalized RU consumption
- The percentage of requests that have an HTTP status code of 429
You need to confirm that contained is configured to maximize resource utilization.
What are the optimal values for each metric? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Hotspot Question
You have an Azure Cosmos DB for NoSQL account that hosts a container named Customers.
You need to add customers to Customers by using the Azure Cosmos DB Spark Connector.
How should you complete the 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 that hosts a container named Customers.
You need to add customers to Customers by using the Azure Cosmos DB Spark Connector.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
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?
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?
Correct Answer: D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
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.
Hotspot Question
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 IoT telemetry requirements.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
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.
Hotspot Question
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 IoT telemetry requirements.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Box 1: On (3,600 seconds)
Note: Litware identifies the following IoT telemetry requirements:
Automatically delete items in con-iot1 after one hour unless a per-item time to live is set.
Box 2: Off
Ensure that the items in con-iot2 persist regardless of the per-item time to live setting.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/sql/time-to-live
You have operational data in an Azure Cosmos DB for NoSQL database.
Database users report that the performance of the database degrades significantly when a business analytics team runs large Apache Spark-based queries against the database.
You need to reduce the impact that running the Spark-based queries has on the database users.
What should you implement?
Database users report that the performance of the database degrades significantly when a business analytics team runs large Apache Spark-based queries against the database.
You need to reduce the impact that running the Spark-based queries has on the database users.
What should you implement?
Correct Answer: B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Drag and Drop Question
You have an Azure subscription that contains the resources shown in the following table.
You need to create a container in db1 that has the following attributes:
- Name: Container1
- Encryption: Client-side encryption with Always Encrypted
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You have an Azure subscription that contains the resources shown in the following table.
You need to create a container in db1 that has the following attributes:
- Name: Container1
- Encryption: Client-side encryption with Always Encrypted
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Correct Answer:
0
0
0
10