DP-420 practice test

1. Question 1 · 1

   HOTSPOT - You are creating a database in an Azure Cosmos DB Core (SQL) API account. The database will be used by an application that will provide users with the ability to share online posts. Users will also be able to submit comments on other users' posts. You need to store the data shown in the following table. The application has the following characteristics: ✑ Users can submit an unlimited number of posts. ✑ The average number of posts submitted by a user will be more than 1,000. ✑ Posts can have an unlimited number of comments from different users. ✑ The average number of comments per post will be 100, but many posts will exceed 1,000 comments. ✑ Users will be limited to having a maximum of 20 interests. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area:

   Choose an option for each prompt.

   

   

   If you embed the posts data into the users data instead of creating a separate document for each post, you will increase the write operation costs for new posts

   • • Yes
   • • No

   If you embed the comments data into the posts data instead of creating a separate document for each comment you will increase the write operation costs for new comments

   • • Yes
   • • No

   If you embed the interests data into the users data instead of creating a separate document for each interest, you will increase the read operation costs for displaying the users and their associated interests

   • • Yes
   • • No

   Read explanation

   Box 1: Yes - Non-relational data increases write costs, but can decrease read costs. Box 2: Yes - Non-relational data increases write costs, but can decrease read costs. Box 3: No - Non-relational data increases write costs, but can decrease read costs.

2. Question 2 · 1

   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 Core (SQL) API account named account 1 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 an Azure Monitor alert to trigger the function. Does this meet the goal?

   Choose one answer.

   • Yes
   • No

3. Question 3 · 1

   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 Core (SQL) API account named account 1 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 CosmosDB trigger. Does this meet the goal?

   Choose one answer.

   • Yes
   • No

4. Question 4 · 1

   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 Core (SQL) API account named account 1 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 an application to use the change feed processor to read the change feed and you configure the application to trigger the function. Does this meet the goal?

   Choose one answer.

   • Yes
   • No

5. Question 5 · 1

   You have a database named db1 in an Azure Cosmos DB Core (SQL) API account. You are designing an application that will use db1. In db1, you are creating a new container named coll1 that will store online orders. The following is a sample of a document that will be stored in coll1. The application will have the following characteristics: ✑ New orders will be created frequently by different customers. ✑ Customers will often view their past order history. You need to select the partition key value for coll1 to support the application. The solution must minimize costs. To what should you set the partition key?

   Choose one answer.

   

   • orderId
   • customerId
   • orderDate
   • id

6. Question 6 · 1

   You have a container in an Azure Cosmos DB Core (SQL) API account that stores data about orders. The following is a sample of an order document. Documents are up to 2 KB. You plan to receive one million orders daily. Customers will frequently view their past order history. You are the evaluating whether to use orderDate as the partition key. What are two effects of using orderDate as the partition key? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   Choose all answers that apply.

   

   • You will exceed the maximum number of partition key values
   • You will exceed the maximum storage per partition
   • There will always be a hot partition
   • Queries will run cross-partition

7. Question 7 · 1

   You have a container in an Azure Cosmos DB Core (SQL) API account. The container stores data about families. Data about parents, children, and pets are stored as separate documents. Each document contains the address of each family. Members of the same family share the same partition key named familyId. You need to update the address for each member of the same family that share the same address. The solution must meet the following requirements: ✑ Be atomic, consistent, isolated, and durable (ACID). ✑ Provide the lowest latency. What should you do?

   Choose one answer.

   • Update the document of each family member separately by using a patch operation
   • Update the document of each family member separately and set the consistency level to strong
   • Update the document of each family member by using a transactional batch operation

8. Question 8 · 1

   You are designing an Azure Cosmos DB Core (SQL) API solution to store data from IoT devices. Writes from the devices will be occur every second. 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?

   Choose one answer.

   

   • Create a new synthetic key that contains deviceId and timestamp
   • Use timestamp as the partition key
   • Use deviceManufacturer as the partition key
   • Use sensor1Value as the partition key

9. Question 9 · 1

   You need to create a data store for a directory of small and medium-sized businesses (SMBs). The data store must meet the following requirements: ✑ Store companies and the users employed by them. Each company will have less than 1,000 users. ✑ Some users have data that is greater than 2 KB. ✑ Associate each user to only one company. ✑ Provide the ability to browse by company. ✑ Provide the ability to browse the users by company. ✑ Whenever a company or user profile is selected, show a details page for the company and all the related users. ✑ Be optimized for reading data. Which design should you implement to optimize the data store for reading data?

   Choose one answer.

   • In a directory container, create a document for each company and a document for each user. Use the company ID as the partition key.
   • Create a user container that uses the user ID as the partition key and a company container that uses the company ID as the partition key. Add the company ID to each user document.
   • In a user container, create a document for each user. Embed the company into each user document. Use the user ID as the partition key.
   • In a company container, create a document for each company. Embed the users into company documents. Use the company ID as the partition key.

10. Question 10 · 1

    You are building an application that will store data in an Azure Cosmos DB Core (SQL) API account. The account uses the session default consistency level. The account is used by five other applications. The account has a single read-write region and 10 additional read region. Approximately 20 percent of the items stored in the account are updated hourly. Several users will access the new application from multiple devices. You need to ensure that the users see the same item values consistently when they browse from the different devices. The solution must NOT affect the other applications. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

    Choose all answers that apply.

    • Set the default consistency level to eventual
    • Associate a session token to the device
    • Use implicit session management when performing read requests
    • Provide a stored session token when performing read requests
    • Associate a session token to the user account

11. Question 11 · 1

    You have an application named App1 that reads the data in an Azure Cosmos DB Core (SQL) API account. App1 runs the same read queries every minute. The default consistency level for the account is set to eventual. You discover that every query consumes request units (RUs) instead of using the cache. You verify the IntegratedCacheiteItemHitRate metric and the IntegratedCacheQueryHitRate metric. Both metrics have values of 0. You verify that the dedicated gateway cluster is provisioned and used in the connection string. You need to ensure that App1 uses the Azure Cosmos DB integrated cache. What should you configure?

    Choose one answer.

    • the indexing policy of the Azure Cosmos DB container
    • the consistency level of the requests from App1
    • the connectivity mode of the App1 CosmosClient
    • the default consistency level of the Azure Cosmos DB account

12. Question 12 · 1

    You plan to store order data in an Azure Cosmos DB Core (SQL) API account. The data contains information about orders and their associated items. You need to develop a model that supports order read operations. The solution must minimize the number of requests. What should you do?

    Choose one answer.

    • Create a database for orders and a database for order items.
    • Create a single database that contains a container for orders and a container for order items.
    • Create a single database that contains one container. Store orders and order items in separate documents in the container.
    • Create a single database that contains one container. Create a separate document for each order and embed the order items into the order documents.

13. Question 13 · 1

    You have a container in an Azure Cosmos DB Core (SQL) API account. The container stores telemetry data from IoT devices. The container uses telemetryId as the partition key and has a throughput of 1,000 request units per second (RU/s). Approximately 5,000 IoT devices submit data every five minutes by using the same telemetryId value. You have an application that performs analytics on the data and frequently reads telemetry data for a single IoT device to perform trend analysis. The following is a sample of a document in the container. You need to reduce the amount of request units (RUs) consumed by the analytics application. What should you do?

    Choose one answer.

    

    • Decrease the offerThroughput value for the container.
    • Increase the offerThroughput value for the container.
    • Move the data to a new container that uses a partition key of deviceId.
    • Move the data to a new container that uses a partition key of temp.

14. Question 14 · 1

    HOTSPOT - You plan to use a multi-region Azure Cosmos DB Core (SQL) API 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.

    Choose an option for each prompt.

    

    

    Reporting:

    • • Bounded staleness
    • • Consistent prefix
    • • Eventual
    • • Session
    • • Strong

    Purchasing:

    • • Bounded staleness
    • • Consistent prefix
    • • Eventual
    • • Session
    • • Strong

    Fulfillment:

    • • Bounded staleness
    • • Consistent prefix
    • • Eventual
    • • Session
    • • Strong

15. Question 15 · 1

    HOTSPOT - You are designing a data model for an Azure Cosmos DB Core (SQL) API account. What are the partition limits for request units per second (RU/s) and storage? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

    Choose an option for each prompt.

    

    Maximum RU/s per physical partition:

    • • 400
    • • 5,000
    • • 10,000
    • • Unlimited

    Maximum storage per logical partition:

    • • 10 GB
    • • 20 GB
    • • 50 GB
    • • Unlimited

Paid access to all 101 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.