Microsoft Designing and Implementing Cloud-Native Applications Using Azure Cosmos DB DP-420 Dumps in PDF

Free Microsoft DP-420 Real Questions (page: 3)


Case Study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs.
When you are ready to answer a question, click the Question button to return to the question.
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 HTTPS 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. IoT Telemetry Requirements
Litware identifies the following IoT telemetry requirements:
-Write the telemetry data from streamanalytics1 to the con-iot1 container as the data arrives. Use streamanalytics1 to create hopping window aggregated telemetry readings once per hour and write the data to con-iot2.
-Automatically delete items in con-iot1 after one hour unless a per-item time to live is set.
-Optimize the partitioning of con-iot1 for queries that support historical data of a specific device.
-Aggregate the telemetry data by device by using streamanalytics1 and write the aggregate data to con-iot2.
-Ensure that the items in con-iot2 persist regardless of the per-item time to live setting.
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 have an Azure subscription that contains an Azure Cosmos DB for NoSQL account named account1.
In account1, you create a container that has the following configurations:
-Partition key: CompanyID
-Composite unique key: UserName and EmailAddress
To the container, you plan to add the data items shown in the following table.

How many conflicts will occur?

  1. 0
  2. 1
  3. 2
  4. 3

Answer(s): A

Explanation:

Based on the configuration, there would be 0 conflicts. Azure Cosmos DB unique keys are enforced within a specific logical partition (defined by the /ID partition key). The unique key constraint is defined on a combination of User and EmailAddress. Each item is analyzed for uniqueness only against other items within the same ID (Company1 or Company2).
Analysis of Actions:
{ID Company1, user1, user1@contoso.com}: Added (First in Company1).
{ID Company1, user2, U1@contoso.com}: Added (New combination in Company1).
Note: Unique keys are case-sensitive, so user1@contoso.com and U1@contoso.com are different.
{ID Company1, user2, user2@outlook.com}: Added (New combination in Company1).
{ID Company2, user1, user1@litwareinc.com.com}: Added (First in Company2).
{ID Company2, user2, user1@outlook.com}: Added (New combination in Company2).
All pairs of (User, EmailAddress) within their respective /ID partitions are unique.


Reference:

https://learn.microsoft.com/en-us/azure/cosmos-db/unique-keys




Case Study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs.
When you are ready to answer a question, click the Question button to return to the question.
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 HTTPS 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. IoT Telemetry Requirements
Litware identifies the following IoT telemetry requirements:
-Write the telemetry data from streamanalytics1 to the con-iot1 container as the data arrives. Use streamanalytics1 to create hopping window aggregated telemetry readings once per hour and write the data to con-iot2.
-Automatically delete items in con-iot1 after one hour unless a per-item time to live is set.
-Optimize the partitioning of con-iot1 for queries that support historical data of a specific device.
-Aggregate the telemetry data by device by using streamanalytics1 and write the aggregate data to con-iot2.
-Ensure that the items in con-iot2 persist regardless of the per-item time to live setting.
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 (Drag and Drop is not supported)
You have an Azure Cosmos DB for NoSQL database named db1.
You run the following code:

For each of the following statements, select Yes if the statements true. Otherwise, select No.
Note: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Yes
Yes - Items inserted into the customers container without a ttl value will never expire.
Time to Live (TTL) in Azure Cosmos DB
Time to live for containers and items
The time to live value is set in seconds, and is interpreted as a delta from the time that an item was last modified. You can set time to live on a container or an item within the container:
1. Time to Live on a container (set using DefaultTimeToLive):
If missing (or set to null), items aren't expired automatically.
*-> If present and the value is set to "-1", it's equal to infinity, and items don’t expire by default.
If present and the value is set to some nonzero number "n" – items will expire "n" seconds after their last modified time.
2. Time to Live on an item (set using ttl):
Etc.
Box 2: No
No - All items inserted into the customers container must include a customerID field.
There is a Customer field. There is no CustomerID field.
Note: ContainerProperties Constructors
* ContainerProperties()
Initializes a new instance of the ContainerProperties class for the Azure Cosmos DB service.
public ContainerProperties ();
* ContainerProperties(String, String)
Initializes a new instance of the ContainerProperties class for the Azure Cosmos DB service.
public ContainerProperties (string id, string partitionKeyPath);
Parameters
Id String
The Id of the resource in the Azure Cosmos service.
partitionKeyPath String
The path to the partition key. Example: /location
* Etc.
Box 3: No
After 12 seconds, not 12 days.
Note: Time me to live for containers and items
The time to live value is set in seconds, and is interpreted as a delta from the time that an item was last modified. You can set time to live on a container or an item within the container:
Time to Live on a container (set using DefaultTimeToLive):
If missing (or set to null), items aren't expired automatically.
If present and the value is set to "-1", it's equal to infinity, and items don’t expire by default.
*-> If present and the value is set to some nonzero number "n" – items will expire "n" seconds after their last modified time.


Reference:

https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/time-to-live https://learn.microsoft.com/en-us/dotnet/api/microsoft.azure.cosmos.containerproperties.-ctor




Case Study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs.
When you are ready to answer a question, click the Question button to return to the question.
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 HTTPS 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. IoT Telemetry Requirements
Litware identifies the following IoT telemetry requirements:
-Write the telemetry data from streamanalytics1 to the con-iot1 container as the data arrives. Use streamanalytics1 to create hopping window aggregated telemetry readings once per hour and write the data to con-iot2.
-Automatically delete items in con-iot1 after one hour unless a per-item time to live is set.
-Optimize the partitioning of con-iot1 for queries that support historical data of a specific device.
-Aggregate the telemetry data by device by using streamanalytics1 and write the aggregate data to con-iot2.
-Ensure that the items in con-iot2 persist regardless of the per-item time to live setting.
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 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?

  1. Use deviceManufacturer as the partition key.
  2. Create a new synthetic key that contains deviceId and timestamp.
  3. Create a new synthetic key that contains deviceId and deviceManufacturer.
  4. Use deviceId as the partition key.

Answer(s): B

Explanation:

Correct:
* Create a new synthetic key that contains deviceId and a random number.
Use a partition key with a random suffix. Distribute the workload more evenly is to append a random number at the end of the partition key value.
When you distribute items in this way, you can perform parallel write operations across partitions.
* Create a new synthetic key that contains deviceId and timestamp.
Concatenate multiple properties of an item.
You can form a partition key by concatenating multiple property values into a single artificial partitionKey property. These keys are referred to as synthetic keys.
For example, consider the following example document:
{
"deviceId": "abc-123",
"date": 2018
}
For the previous document, one option is to set /deviceId or /date as the partition key. Use this option, if you want to partition your container based on either device ID or date. Another option is to concatenate these two values into a synthetic partitionKey property that's used as the partition key.
{
"deviceId": "abc-123",
"date": 2018,
"partitionKey": "abc-123-2018"
Incorrect:
* Create a new synthetic key that contains deviceId and deviceManufacturer.
All the devices could have the same manufacturer.
* Create a new synthetic key that contains deviceId and sensor1Value.
Senser1Value has only two values.
* Use deviceId as the partition key.
* Use deviceManufacturer as the partition key.
All the devices could have the same manufacturer.
* Use sensor1Value as the partition key
* Use timestamp as the partition key.
You will also not like to partition the data on “DateTime”, because this will create a hot partition. Imagine you have partitioned the data on time, then for a given minute, all the calls will hit one partition. If you need to retrieve the data for a customer, then it will be a fan-out query because data may be distributed on all the partitions.


Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/sql/synthetic-partition-keys https://docs.microsoft.com/en-us/azure/cosmos-db/concepts-limits




Case Study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs.
When you are ready to answer a question, click the Question button to return to the question.
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 HTTPS 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. IoT Telemetry Requirements
Litware identifies the following IoT telemetry requirements:
-Write the telemetry data from streamanalytics1 to the con-iot1 container as the data arrives. Use streamanalytics1 to create hopping window aggregated telemetry readings once per hour and write the data to con-iot2.
-Automatically delete items in con-iot1 after one hour unless a per-item time to live is set.
-Optimize the partitioning of con-iot1 for queries that support historical data of a specific device.
-Aggregate the telemetry data by device by using streamanalytics1 and write the aggregate data to con-iot2.
-Ensure that the items in con-iot2 persist regardless of the per-item time to live setting.
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 (Drag and Drop is not supported)
You have an Azure subscription that is linked to a Microsoft Entra tenant. The tenant contains two users named User1 and User2.
You plan to deploy an Azure Cosmos DB for NoSQL database that will host a container named Container1.
You need to provide User1 and User2 with the keys for Container1. The solution must meet the following requirements:
● Ensure that User1 can successfully load data to Container1.
● Ensure that User2 can manage data efficiently and optimize data retrieval for Container1.
Which type of key should you provide to each user? To answer, select the appropriate options in the answer area.
Note: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Partition
Partition key is the type of key the user's data items must include to successfully load data into the container.
In Azure Cosmos DB, every container requires a partition key to be defined upon creation.
When loading data or performing write operations, the SDK or application must supply both the item data and its corresponding partition key value so that the service can efficiently distribute and store the data across logical and physical partitions.
Box 2: Partition
The user needs a partition key to manage data efficiently and optimize data retrieval for the Azure Cosmos DB container.
In Azure Cosmos DB, a partition key is the logical boundary used to distribute data across physical partitions.
Efficiency & Scaling: It allows Azure Cosmos DB to scale horizontally by distributing data across multiple physical shards.
Optimized Retrieval: Queries that include the partition key can be routed directly to the specific partition holding the data (known as a "single-partition query"). This minimizes the Request Units (RUs) consumed and prevents expensive "cross-partition queries" that scan the entire container.
How it compares: While primary, unique, and foreign keys are standard relational database concepts used for integrity and identification, Azure Cosmos DB is a non-relational (NoSQL) database where data distribution and query performance depend entirely on the choice of a partition key.


Reference:

https://learn.microsoft.com/en-us/azure/cosmos-db/partitioning




Case Study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs.
When you are ready to answer a question, click the Question button to return to the question.
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 HTTPS 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. IoT Telemetry Requirements
Litware identifies the following IoT telemetry requirements:
-Write the telemetry data from streamanalytics1 to the con-iot1 container as the data arrives. Use streamanalytics1 to create hopping window aggregated telemetry readings once per hour and write the data to con-iot2.
-Automatically delete items in con-iot1 after one hour unless a per-item time to live is set.
-Optimize the partitioning of con-iot1 for queries that support historical data of a specific device.
-Aggregate the telemetry data by device by using streamanalytics1 and write the aggregate data to con-iot2.
-Ensure that the items in con-iot2 persist regardless of the per-item time to live setting.
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 implement a trigger in Azure Cosmos DB for NoSQL 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.

  1. Append pre to the name of the JavaScript function trigger.
  2. For each create request, set the access condition in RequestOptions.
  3. Register the trigger as a pre-trigger.
  4. For each create request, set the consistency level to session in RequestOptions.
  5. For each create request, set the trigger name in RequestOptions.

Answer(s): C

Explanation:

C: When triggers are registered, you can specify the operations that it can run with.
F: When executing, pre-triggers are passed in the RequestOptions object by specifying PreTriggerInclude and then passing the name of the trigger in a List object.


Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-use-stored-procedures-triggers-udfs




Case Study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs.
When you are ready to answer a question, click the Question button to return to the question.
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 HTTPS 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. IoT Telemetry Requirements
Litware identifies the following IoT telemetry requirements:
-Write the telemetry data from streamanalytics1 to the con-iot1 container as the data arrives. Use streamanalytics1 to create hopping window aggregated telemetry readings once per hour and write the data to con-iot2.
-Automatically delete items in con-iot1 after one hour unless a per-item time to live is set.
-Optimize the partitioning of con-iot1 for queries that support historical data of a specific device.
-Aggregate the telemetry data by device by using streamanalytics1 and write the aggregate data to con-iot2.
-Ensure that the items in con-iot2 persist regardless of the per-item time to live setting.
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 (Drag and Drop is not supported)
You plan to use a multi-region Azure Cosmos DB for NoSQL account to store data for a new application suite. The suite contains the applications shown in the following table.

Each application should use the weakest consistency level possible.
Which consistency level should you configure for each application? To answer, select the appropriate options in the answer area.
Note: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Eventual
Eventual consistency
Like all consistency levels weaker than Strong, writes are replicated to a minimum of three replicas (in a four replica set) in the local region, with asynchronous replication to all other regions.
In Eventual consistency, the client issues read requests against any one of the four replicas in the specified region. This replica may be lagging and could return stale or no data.
Eventual consistency is the weakest form of consistency because a client may read the values that are older than the ones it read in the past. Eventual consistency is ideal where the application doesn't require any ordering guarantees. Examples include count of Retweets, Likes, or non-threaded comments. The following graphic illustrates the eventual consistency with musical notes.
Box 2: Bounded Staleness
Reads when using Bounded Staleness returns the latest data available in that region by reading from two available replicas in that region. Since writes within a region always replicate to a local majority (three out of four replicas), consulting two replicas return the most updated data available in that region.
Box 3: Strong
Strong consistency
Strong consistency offers a linearizability guarantee. Linearizability refers to serving requests concurrently. The reads are guaranteed to return the most recent committed version of an item. A client never sees an uncommitted or partial write. Users are always guaranteed to read the latest committed write.
Note: Azure Cosmos DB offers five well-defined levels. From strongest to weakest, the levels are:
Strong
Bounded staleness
Session
Consistent prefix
Eventual


Reference:

https://learn.microsoft.com/en-us/azure/cosmos-db/consistency-levels




Case Study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs.
When you are ready to answer a question, click the Question button to return to the question.
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 HTTPS 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. IoT Telemetry Requirements
Litware identifies the following IoT telemetry requirements:
-Write the telemetry data from streamanalytics1 to the con-iot1 container as the data arrives. Use streamanalytics1 to create hopping window aggregated telemetry readings once per hour and write the data to con-iot2.
-Automatically delete items in con-iot1 after one hour unless a per-item time to live is set.
-Optimize the partitioning of con-iot1 for queries that support historical data of a specific device.
-Aggregate the telemetry data by device by using streamanalytics1 and write the aggregate data to con-iot2.
-Ensure that the items in con-iot2 persist regardless of the per-item time to live setting.
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.
-

DRAG DROP (Drag and Drop is not supported)
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, if 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 or scroll to view content.
Note: Each correct selection is worth one point.
Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:




VALUE: The subquery should select the age of each pet, so VALUE is used to extract just the age value from each pet document.
IN: The correct keyword to iterate through the pets array within each owner is IN.




Case Study
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs.
When you are ready to answer a question, click the Question button to return to the question.
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 HTTPS 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. IoT Telemetry Requirements
Litware identifies the following IoT telemetry requirements:
-Write the telemetry data from streamanalytics1 to the con-iot1 container as the data arrives. Use streamanalytics1 to create hopping window aggregated telemetry readings once per hour and write the data to con-iot2.
-Automatically delete items in con-iot1 after one hour unless a per-item time to live is set.
-Optimize the partitioning of con-iot1 for queries that support historical data of a specific device.
-Aggregate the telemetry data by device by using streamanalytics1 and write the aggregate data to con-iot2.
-Ensure that the items in con-iot2 persist regardless of the per-item time to live setting.
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.
-

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 the function to have an Azure Cosmos DB trigger.
Does this meet the goal?

  1. Yes
  2. No

Answer(s): B

Explanation:

Instead configure an Azure Monitor alert to trigger the function.
You can set up alerts from the Azure Cosmos DB pane or the Azure Monitor service in the Azure portal.


Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/create-alerts



Share your comments for Microsoft DP-420 exam with other users:

M
Matthew Dievendorf
5/30/2023 9:37:00 PM

question 39, should be answer b, directions stated is being sudneted from /21 to a /23. a /23 has 512 ips so 510 hosts. and can make 4 subnets out of the /21

A
Adhithya
8/11/2022 12:27:00 AM

beautiful test engine software and very helpful. questions are same as in the real exam. i passed my paper.

S
SuckerPumch88
4/25/2022 10:24:00 AM

the questions are exactly the same in real exam. just make sure not to answer all them correct or else they suspect you are cheating.

S
soheib
7/24/2023 7:05:00 PM

question: 78 the right answer i think is d not a

S
srija
8/14/2023 8:53:00 AM

very helpful

T
Thembelani
5/30/2023 2:17:00 AM

i am writing this exam tomorrow and have dumps

A
Anita
10/1/2023 4:11:00 PM

can i have the icdl excel exam

B
Ben
9/9/2023 7:35:00 AM

please upload it

A
anonymous
9/20/2023 11:27:00 PM

hye when will post again the past year question for this h13-311_v3 part since i have to for my test tommorow…thank you very much

R
Randall
9/28/2023 8:25:00 PM

on question 22, option b-once per session is also valid.

T
Tshegofatso
8/28/2023 11:51:00 AM

this website is very helpful

P
philly
9/18/2023 2:40:00 PM

its my first time exam

B
Beexam
9/4/2023 9:06:00 PM

correct answers are device configuration-enable the automatic installation of webview2 runtime. & policy management- prevent users from submitting feedback.

R
RAWI
7/9/2023 4:54:00 AM

is this dump still valid? today is 9-july-2023

A
Annie
6/7/2023 3:46:00 AM

i need this exam.. please upload these are really helpful

S
Shubhra Rathi
8/26/2023 1:08:00 PM

please upload the oracle 1z0-1059-22 dumps

S
Shiji
10/15/2023 1:34:00 PM

very good questions

R
Rita Rony
11/27/2023 1:36:00 PM

nice, first step to exams

A
Aloke Paul
9/11/2023 6:53:00 AM

is this valid for chfiv9 as well... as i am reker 3rd time...

C
Calbert Francis
1/15/2024 8:19:00 PM

great exam for people taking 220-1101

A
Ayushi Baria
11/7/2023 7:44:00 AM

this is very helpfull for me

A
alma
8/25/2023 1:20:00 PM

just started preparing for the exam

C
CW
7/10/2023 6:46:00 PM

these are the type of questions i need.

N
Nobody
8/30/2023 9:54:00 PM

does this actually work? are they the exam questions and answers word for word?

S
Salah
7/23/2023 9:46:00 AM

thanks for providing these questions

R
Ritu
9/15/2023 5:55:00 AM

interesting

R
Ron
5/30/2023 8:33:00 AM

these dumps are pretty good.

S
Sowl
8/10/2023 6:22:00 PM

good questions

B
Blessious Phiri
8/15/2023 2:02:00 PM

dbua is used for upgrading oracle database

R
Richard
10/24/2023 6:12:00 AM

i am thrilled to say that i passed my amazon web services mls-c01 exam, thanks to study materials. they were comprehensive and well-structured, making my preparation efficient.

J
Janjua
5/22/2023 3:31:00 PM

please upload latest ibm ace c1000-056 dumps

M
Matt
12/30/2023 11:18:00 AM

if only explanations were provided...

R
Rasha
6/29/2023 8:23:00 PM

yes .. i need the dump if you can help me

A
Anonymous
7/25/2023 8:05:00 AM

good morning, could you please upload this exam again?

AI Tutor 👋 I’m here to help!