DP-420 practice questions 11–20

1. Question 11 · 106 in bank

   The settings for a container in an Azure Cosmos DB Core (SQL) API account are configured as shown in the following exhibit.

   

   Which statement describes the configuration of the container?

   • AAll items will be deleted after one year.
   • BItems stored in the collection will be retained always, regardless of the items time to live value.
   • CItems stored in the collection will expire only if the item has a time to live value.
   • DAll items will be deleted after one hour.

   Show answer

   Answer: C

   Next question

2. Question 12 · 106 in bank

   You have the following query.

   

   You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by the query. What should you recommend?

   • Aa composite index for (sensor ASC, value ASC) and a composite index for (sensor ASC, timestamp ASC)
   • Ba composite index for (sensor ASC, value ASC, timestamp ASC) and a composite index for (sensor DESC, value DESC, timestamp DESC)
   • Ca composite index for (value ASC, sensor ASC) and a composite index for (timestamp ASC, sensor ASC)
   • Da composite index for (sensor ASC, value ASC, timestamp ASC)

   Show answer

   Answer: A

   Next question

3. Question 13 · 106 in bank

   You need to create a database in an Azure Cosmos DB Core (SQL) API account. The database will contain three containers named coll1, coll2, and coll3. The coll1 container will have unpredictable read and write volumes. The coll2 and coll3 containers will have predictable read and write volumes. The expected maximum throughput for coll1 and coll2 is 50,000 request units per second (RU/s) each. How should you provision the collection while minimizing costs?

   • ACreate a serverless account.
   • BCreate a provisioned throughput account. Set the throughput for coll1 to Autoscale. Set the throughput for coll2 and coll3 to Manual.
   • CCreate a provisioned throughput account. Set the throughput for coll1 to Manual. Set the throughput for coll2 and coll3 to Autoscale.

   Show answer

   Answer: B

   Next question

4. Question 14 · 106 in bank

   You have a database in an Azure Cosmos DB Core (SQL API) account. The database contains a container named container1. The indexing mode of container1 is set to none. You configure Azure Cognitive Search to extract data from container1 and make the data searchable. You discover that the Cognitive Search index is missing all the data from the Azure Cosmos DB index. What should you do to resolve the issue?

   • AModify the index attributes in Cognitive Search to Searchable
   • BModify the index attributes in Cognitive Search to Retrievable
   • CModify the indexing policy of container1 to exclude the /* path
   • DChange the indexing mode of container1 to consistent

   Show answer

   Answer: D

   Next question

5. Question 15 · 106 in bank

   You have an Azure Cosmos DB Core (SQL) API account named account1 that is configured for automatic failover. The account1 account has a single read-write region in West US and a read region in East US. You run the following PowerShell command. Update-AzCosmosDBAccountFailoverPriority -ResourceGroupName `rg1` -Name `account1` -FailoverPolicy @(`East US`, `West US`) What is the effect of running the command?

   • AThe account will be unavailable to writes during the change
   • BThe provisioned throughput for account1 will increase
   • CThe account will be configured for multi-region writes
   • DA manual failover will occur

   Show answer

   Answer: D

   Next question

6. Question 16 · 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 for NoSQL account. You need to make the contents of container1 available as reference data for an Azure Stream Analytics job. Solution: You create an Azure Synapse 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: B

   Next question

7. Question 17 · 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?

   • AUse timestamp as the partition key.
   • BCreate a new synthetic key that contains deviceId and sensor1Value.
   • CCreate a new synthetic key that contains deviceId and deviceManufacturer.
   • DCreate a new synthetic key that contains deviceId and a random number.

   Show answer

   Answer: D

   Next question

8. Question 18 · 106 in bank

   You maintain a relational database for a book publisher. The database contains the following tables.

   

   The most common query lists the books for a given authorId. You need to develop a non-relational data model for Azure Cosmos DB Core (SQL) API that will replace the relational database. The solution must minimize latency and read operation costs. What should you include in the solution?

   • ACreate a container for Author and a container for Book. In each Author document, embed bookId for each book by the author. In each Book document embed authorId of each author.
   • BCreate Author, Book, and Bookauthorlnk documents in the same container.
   • CCreate a container that contains a document for each Author and a document for each Book. In each Book document, embed authorId.
   • DCreate a container for Author and a container for Book. In each Author document and Book document embed the data from Bookauthorlnk.

   Show answer

   Answer: C

   Next question

9. Question 19 · 106 in bank

   You have a container named container1 in an Azure Cosmos DB Core (SQL) API account named account1 that is set to the session default consistency level. The average size of an item in contained is 20 KB. You have an application named App1 that uses the Azure Cosmos DB SDK and performs a point read on the same set of items in container1 every minute. You need to minimize the consumption of the request units (RUs) associated to the reads by App1. What should you do?

   • AIn App1, modify the connection policy settings
   • BIn App1, change the consistency level of read requests to consistent prefix
   • CIn account1, provision a dedicated gateway and integrated cache
   • DIn account1, change the default consistency level to bounded staleness

   Show answer

   Answer: C

   Next question

10. Question 20 · 106 in bank

    You have a global ecommerce application that stores data in an Azure Cosmos DB Core (SQL) API account. The account is configured for multi-region writes. You need to create a stored procedure for a custom conflict resolution policy for a new container. In the event of a conflict caused by a deletion, the deletion must always take priority. Which parameter should you check in the stored procedure function?

    • AisTombstone
    • BconflictingItems
    • CexistingItem
    • DincomingItem

    Show answer

    Answer: A

    Next question

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

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