DP-420 practice questions 61–70

1. Question 61 · 106 in bank

   You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that hosts a container named Devices. Devices has a partition key named type. You plan to execute the following query. SELECT d.deviceName - FROM d - WHERE d.deviceId = 'ABC102' AND d.type = 'car' AND d.importanceId = 4 - You are evaluating the resource utilization of the query. How will the query be executed?

   • Aas an in-partition query
   • Bas a parallel cross-partition query
   • Cas a cross-partition query

   Show answer

   Answer: A

   Next question

2. Question 62 · 106 in bank

   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?

   • ACreate a new synthetic key that contains deviceId and timestamp
   • BUse timestamp as the partition key
   • CUse deviceManufacturer as the partition key
   • DUse sensor1Value as the partition key

   Show answer

   Answer: A

   Next question

3. Question 63 · 106 in bank

   Select 2

   You have an Azure Cosmos DB for NoSQL container named Contained that has a provisioned throughput of 1,000 request units per second (RU/s). Contained is queried by using an app named App1. Users of App1 report that several times a day, they receive the following error message: “HTTP error code 429” You need to improve the reliability of App1 without affecting the performance of the app. What are two ways to improve the reliability? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • AAdd a trigger to Container1.
   • BUpdate App1 to split large requests into several smaller requests.
   • CUpdate App1 to reduce the size of each request to less than 1 MB.
   • DIncrease the provisioned throughout of Container1.
   • EAdd retry logic to App1.

   Show answer

   Answer: DE

   Next question

4. Question 64 · 106 in bank

   Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. You need to make the contents of container1 available as reference data for an Azure Stream Analytics job. Solution: You create an Azure function that uses Azure Cosmos DB for NoSQL change feed as a trigger and Azure event hub as the output. Does this meet the goal?

   • AYes
   • BNo

   Show answer

   Answer: A

   Next question

5. Question 65 · 106 in bank

   You have an Azure Cosmos DB Core (SQL) API account. You need to create an Azure Monitor query that lists recent modifications to the regional failover policy. Which Azure Monitor table should you query?

   • ACDBControlPlaneRequests
   • BCDBQueryRunTimeStatistics
   • CCDBPartitionKeyStatistics
   • DCDBDataPlaneRequests

   Show answer

   Answer: A

   Next question

6. Question 66 · 106 in bank

   You have an Azure subscription. You plan to create an Azure Cosmos DB for NoSQL database named DB1 that will store author and book data for authors that have each published up to ten books. Typical and frequent queries of the data will include: • All books written by an individual author • The synopsis of individual books You need to recommend a data model for DB1. The solution must meet the following requirements: • Support transactional updates of the author and book data. • Minimize read operation costs. What should you recommend?

   • ACreate a single container that stores author items and book items, and then items that represent the relationship between the authors and their books.
   • BCreate three containers, one that stores author items, a second that stores book items, and a third that stores items that represent the relationship between the authors and their books.
   • CCreate two containers, one that stores author items and another that stores book items. Embed a list of each author’s books in the corresponding author item.
   • DCreate a single container that stores author items and book items. Embed a list of each author’s books in the corresponding author item.

   Show answer

   Answer: D

   Next question

7. Question 67 · 106 in bank

   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?

   • AIn a directory container, create a document for each company and a document for each user. Use the company ID as the partition key.
   • BCreate 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.
   • CIn a user container, create a document for each user. Embed the company into each user document. Use the user ID as the partition key.
   • DIn a company container, create a document for each company. Embed the users into company documents. Use the company ID as the partition key.

   Show answer

   Answer: D

   Next question

8. Question 68 · 106 in bank

   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?

   • AdisableKeyBasedMetadataWriteAccess
   • BdisableLocalAuth
   • CuserAssignedIdentities
   • DallowedOrigins

   Show answer

   Answer: B

   Next question

9. Question 69 · 106 in bank

   You have an Azure subscription. The subscription contains an Azure Cosmos DB for NoSQL account named account1 that hosts a container named Container1. Container1 has a provisioned throughput of 100 request units per second (RU/s) and uses a single physical partition. You are evaluating the available throughput for Container1. What is the maximum burst capacity that Container1 can accumulate?

   • A300 RU/s
   • B1,000 RU/s
   • C30,000 RU/s
   • D100,000 RU/s

   Show answer

   Answer: C

   Next question

10. Question 70 · 106 in bank

    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. You need to make the contents of container1 available as reference data for an Azure Stream Analytics job. Solution: You create an Azure Data Factory pipeline that uses Azure Cosmos DB for NoSQL as the input and Azure Blob Storage as the output. Does this meet the goal?

    • AYes
    • BNo

    Show answer

    Answer: A

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-420 practice, question 61. 106 questions available.