DP-420 exam

Topic 2, Misc. Questions 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...

You have an Azure Cosmos DB Core (SQL) API account. You run the following query against a container in the account. SELECT IS_NUMBER("1234") AS A, IS_NUMBER(1234) AS B, IS_NUMBER({prop: 1234}) AS C What is the output of the query?A . [{"A": false, "B": true, "C": false}]B . [{"A": true, "B":...

You need to implement a solution to meet the product catalog requirements. What should you do to implement the conflict resolution policy.A . Remove frequently changed field from the index policy of the con-product container.B . Disable indexing on all fields in the index policy of the con-product container.C ....

Topic 1: Litware, inc Case Study 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...

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

HOTSPOT You have a database in an Azure Cosmos DB Core (SQL) API account. You plan to create a container that will store employee data for 5,000 small businesses. Each business will have up to 25 employees. Each employee item will have an email Address value. You need to ensure...

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

You have the following query. SELECT * FROM с WHERE c.sensor = "TEMP1" AND c.value < 22 AND c.timestamp >= 1619146031231 You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by the query. What should you recommend?A . a composite index for (sensor...

HOTSPOT You provision Azure resources by using the following Azure Resource Manager (ARM) template. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: No An alert is triggered when the...

HOTSPOT You have a container named container1 in an Azure Cosmos DB Core (SQL) API account. The container1 container has 120 GB of data. The following is a sample of a document in container1. The orderId property is used as the partition key. For each of the following statements, select...