Free DP-420 Exam Braindumps (page: 3)

Page 2 of 23

HOTSPOT (Drag and Drop is not supported).
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 Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Yes
Records with different OrderIDs will match.

Box 2: Yes
Records with different OrderIDs will match.

Box 3: No
Only records with one speci c OrderId will match



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?

  1. Use timestamp as the partition key.
  2. Create a new synthetic key that contains deviceId and sensor1Value.
  3. Create a new synthetic key that contains deviceId and deviceManufacturer.
  4. Create a new synthetic key that contains deviceId and a random number.

Answer(s): D

Explanation:

Use a partition key with a random su x. Distribute the workload more evenly is to append a random number at the end of the partition key value. When you distribute items in this way, you can perform parallel write operations across partitions.
Incorrect Answers:
A: You will also not like to partition the data on DateTime , because this will create a hot partition. Imagine you have partitioned the data on time, then for a given minute, all the calls will hit one partition. If you need to retrieve the data for a customer, then it will be a fan-out query because data may be distributed on all the partitions.
B: Senser1Value has only two values.
C: All the devices could have the same manufacturer.


Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/sql/synthetic-partition-keys
D (78%) C (22%)



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?

  1. Create 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.
  2. Create Author, Book, and Bookauthorlnk documents in the same container.
  3. Create a container that contains a document for each Author and a document for each Book. In each Book document, embed authorId.
  4. Create a container for Author and a container for Book. In each Author document and Book document embed the data from Bookauthorlnk.

Answer(s): A

Explanation:

Store multiple entity types in the same container.



You have an Azure Cosmos DB Core (SQL) API account.
You run the following query against a container in the account.



What is the output of the query?

  1. [{"A": false, "B": true, "C": false}]
  2. [{"A": true, "B": false, "C": true}]
  3. [{"A": true, "B": true, "C": false}]
  4. [{"A": true, "B": true, "C": true}]

Answer(s): A

Explanation:

IS_NUMBER returns a Boolean value indicating if the type of the speci ed expression is a number.
"1234" is a string, not a number.


Reference:

https://docs.microsoft.com/en-us/azure/cosmos-db/sql/sql-query-is-number






Post your Comments and Discuss Microsoft DP-420 exam with other Community members: