DP-420 exam questions

1. Question 1 Litware, inc

   Single answer

   Case study: Litware, inc

   Litware, incOverview

   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 Core (SQL) API 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 are troubleshooting the current issues caused by the application updates.

   Which action can address the application updates issue without affecting the functionality of the application?

   • A

     Enable time to live for the con-product container.

   • B

     Set the default consistency level of account1 to strong.

   • C

     Set the default consistency level of account1 to bounded staleness.

   • D

     Add a custom indexing policy to the con-product container.

   Reveal answer

   Correct answer

   • C

     Set the default consistency level of account1 to bounded staleness.

   Explanation

   Bounded staleness is frequently chosen by globally distributed applications that expect low write latencies but require total global order guarantee. Bounded staleness is great for applications featuring group collaboration and sharing, stock ticker, publish-subscribe/queueing etc.

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

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

2. Question 2 Litware, inc

   Multiple answer

   You need to provide a solution for the Azure Functions notifications following updates to con-product. The solution must meet the business requirements and the product catalog requirements.

   Which two actions should you perform? Each correct answer presents part of the solution.

   NOTE: Each correct selection is worth one point.

   • A

     Configure the trigger for each function to use a different leaseCollectionPrefix

   • B

     Configure the trigger for each function to use the same leaseCollectionNair.e

   • C

     Configure the trigger for each function to use a different leaseCollectionName

   • D

     Configure the trigger for each function to use the same leaseCollectionPrefix

   Reveal answer

   Correct answer

   • A

     Configure the trigger for each function to use a different leaseCollectionPrefix

   • C

     Configure the trigger for each function to use a different leaseCollectionName

   Explanation

   leaseCollectionPrefix: when set, the value is added as a prefix to the leases created in the Lease collection for this Function. Using a prefix allows two separate Azure Functions to share the same Lease collection by using different prefixes.

   Scenario: Use Azure Functions to send notifications about product updates to different recipients.

   Trigger the execution of two Azure functions following every update to any document in the con-product container.

   https://docs.microsoft.com/en-us/azure/azure-functions/functions-bindings-cosmosdb-v2-trigger

3. Question 3 Litware, inc

   Hotspot

   You need to recommend indexes for con-product and con-productVendor. The solution must meet the product catalog requirements and the business requirements.

   Which type of index should you recommend for each container? To answer, select the appropriate options in the answer area.

   NOTE: Each correct selection is worth one point.

   

   Reveal answer

   Correct answer

   

4. Getting the hang of it? 199 more DP-420 questions are waiting, each with its answer. Unlock them all

5. Question 4

   Ordering

   You have an app that stores data in an Azure Cosmos DB Core (SQL) API account The app performs queries that return large result sets.

   You need to return a complete result set to the app by using pagination. Each page of results must return 80 items.

   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.

   

   • A

     Configure the MaxItemCount in QueryRequestOptions

   • B

     Run the query and provide a continuation token

   • C

     Configure MaxBufferedItemCount in QueryRequestOptions

   • D

     Append the results to a variable

   • E

     Run the query and increment MaxItemCount

   Reveal answer

   Correct order

   1. 1 A

      Configure the MaxItemCount in QueryRequestOptions

   2. 2 B

      Run the query and provide a continuation token

   3. 3 D

      Append the results to a variable

6. Question 5 Mix Questions

   Drag and drop

   Case study: Mix Questions

   Mix QuestionsDP-420 Mix Questions IN THIS CASE STUDY

   You have an Azure Cosmos DB Core (SQL) API account that is configured for multi-region writes. The account contains a database that has two containers named container1 and container2.

   The following is a sample of a document in container1:

   {

   "customerId": 1234,

   "firstName": "John",

   "lastName": "Smith",

   "policyYear": 2021

   }

   The following is a sample of a document in container2:

   {

   "gpsId": 1234,

   "latitude": 38.8951,

   "longitude": -77.0364

   }

   You need to configure conflict resolution to meet the following requirements:

   For container1 you must resolve conflicts by using the highest value for policyYear.

   For container2 you must resolve conflicts by accepting the distance closest to latitude: 40.730610 and longitude: -73.935242.

   Administrative effort must be minimized to implement the solution.

   What should you configure for each container? To answer, drag the appropriate configurations to the correct containers. Each configuration 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.

   

   Reveal answer

   Correct answer

   

   Explanation

   https://docs.microsoft.com/en-us/azure/cosmos-db/conflict-resolution-policies

   https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-manage-conflicts

7. Question 6 Locked Unlock to see this question
8. Question 7 Locked Unlock to see this question

Back to the DP-420 exam page