DP-420 Practice Test

DP-420 Practice Test practice questions, page 8 of 11, with answer review and explanations.

Question 36

You have an Azure Cosmos DB for NoSQL account named account1. You need to create a container named Container1 in account1 by using the Azure Cosmos DB .NET SDK. The solution must ensure that the items in Container1 never expire. What should you set?

  1. TimeToLivePropertyPath to null
  2. TimeToLivePropertyPath to 0
  3. DefaultTimeToLive to null
  4. DefaultTimeToLive to –1

Question 37

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.

Question 38

You have an Azure Cosmos DB for NoSQL container named Contacts that is configured as shown in the following exhibit. Contacts contains the items shown in the following table. To Contacts, you plan to Insert the items shown in the following table. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Question 39

You plan to create an Azure Cosmos DB container named account that will contain items in the following format. You need to define a query that will return the ids of all accounts that have ever recorded a negative value for balance. How should you complete the query? To answer select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 40

You have the Azure Cosmos DB for NoSQL containers shown in the following table. You have the items shown in the following table. When will each item expire? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.