CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-420

Free DP-420 Exam Braindumps (page: 2)

Page 2 of 23
PDF with 157 Questions

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



Page 2 of 23



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

Yeshwanth commented on November 14, 2024
Nice Questions and helpful for exam preparation.
Anonymous
upvote

Jenil Gandhi commented on November 14, 2024
Hi everyone could sone share the certification voucher for PD2.
INDIA
upvote

Nicole commented on November 13, 2024
I am working towards my exam. Finding these prep to be very useful
CANADA
upvote

Nicole commented on November 13, 2024
Very helpful
CANADA
upvote

Bianca commented on November 13, 2024
Consistent questions
Anonymous
upvote

Larry commented on November 13, 2024
Good content
Anonymous
upvote

Dipu commented on November 13, 2024
Great Source , i feel really good questions
Anonymous
upvote

Dipu commented on November 13, 2024
Nice questions
Anonymous
upvote

Nathaniel Okeke commented on November 13, 2024
nice way to practice for the exam
Anonymous
upvote

Ashwini commented on November 13, 2024
I would appreciate for resources you can provide
INDIA
upvote

Ganiyu Ogunlana commented on November 13, 2024
Great Insight into the exams
Anonymous
upvote

Vuyo commented on November 13, 2024
Very Helpful
Anonymous
upvote

Suleman khan commented on November 13, 2024
Huawei is my favourite I'm enjoying these questions
PAKISTAN
upvote

Pandiyan Venkatraman commented on November 13, 2024
good question
Anonymous
upvote

Eb'Oney commented on November 12, 2024
I think the answer here should be B. Split the Logged column by using at as the delimiter
UNITED STATES
upvote

Hadiza commented on November 12, 2024
useful for exam preparation
Anonymous
upvote

Hadiza commented on November 12, 2024
inspiring and educative
Anonymous
upvote

Hadiza commented on November 12, 2024
Highly resourceful
Anonymous
upvote

Naomie commented on November 12, 2024
Good material very helpful.
Anonymous
upvote

dodol commented on November 12, 2024
ok real exam
Anonymous
upvote

PA commented on November 11, 2024
This questions are valid in Canada. I passed the exam.
CANADA
upvote

JP commented on November 11, 2024
Très intéréssant pour valider son apprentissage
SWITZERLAND
upvote

JP commented on November 11, 2024
Good for exam preparation
SWITZERLAND
upvote

K.U commented on November 11, 2024
@Dane, Yes, questions are very similar to content of real exam. I managed to pass the test.
Anonymous
upvote

siva N commented on November 11, 2024
this absolutely make the test easy!!!
INDIA
upvote

Isadora Guimarães commented on November 10, 2024
Very good to study
UNITED STATES
upvote

Noah commented on November 10, 2024
Does this dump include the lab solution as well?
Anonymous
upvote

Cardo commented on November 10, 2024
Helpful explanations
Anonymous
upvote

Anonymous commented on November 10, 2024
Good ONE FOR mcd l2
INDIA
upvote

derar commented on November 10, 2024
The study material was very helpful
Anonymous
upvote

Kavya M T commented on November 09, 2024
Good questions
Anonymous
upvote

Ali commented on November 09, 2024
This dump helped me pass my exam. Relevant content.
Canada
upvote

Bahawan commented on November 09, 2024
This website provides these questions for free which is appreciated. A massing assistance to my preparation.
INDIA
upvote

Rasmita commented on November 09, 2024
This is a good braindumps. So many questions in the exam from this dump.
Anonymous
upvote