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:

VARSHA commented on December 24, 2024
GOOD QUSTIOENS.. LIKED IT
Anonymous
upvote

Robin commented on December 24, 2024
nice course
Anonymous
upvote

Rama laksmana commented on December 23, 2024
Good question
UNITED STATES
upvote

Chandru commented on December 23, 2024
Nice questions
UNITED STATES
upvote

Amr commented on December 23, 2024
Good tutorial
Anonymous
upvote

hari commented on December 23, 2024
Preparing for exam
INDIA
upvote

Ichigo Kurosaki commented on December 23, 2024
Can I pass the exam, if I have done suppose 150 questions from here?
MALAYSIA
upvote

Emma commented on December 23, 2024
Really helpful for preparing the exam
FRANCE
upvote

Siva commented on December 23, 2024
Good ones with the quick start
INDIA
upvote

sj commented on December 22, 2024
good set of questions
Anonymous
upvote

sj commented on December 22, 2024
Questions that are typically not covered as part of the aws learning course videos
Anonymous
upvote

sowmya commented on December 22, 2024
helpfull to prepare for the exam
Anonymous
upvote

Leandro commented on December 22, 2024
very usefull
BRAZIL
upvote

vishal solanke commented on December 22, 2024
Please try to post explanations
Anonymous
upvote

Suchi Poddar commented on December 22, 2024
Good set and nice to see that so much help for the students. Thankyou so much.
Anonymous
upvote

Prashant commented on December 22, 2024
good practise
Anonymous
upvote

shree sri commented on December 22, 2024
great work for learning
UNITED STATES
upvote

M Ajaykumar commented on December 21, 2024
Literally helpful
Anonymous
upvote

Narasimha commented on December 21, 2024
it is helpful for ACE GCP Exsm
INDIA
upvote

shan commented on December 21, 2024
Nice questions
Anonymous
upvote

resha commented on December 21, 2024
Very nicely explained
Anonymous
upvote

Abhishek commented on December 21, 2024
It was Nice
Anonymous
upvote

Sumeet G Hongekar commented on December 21, 2024
I am eger to write cad exaam
UNITED STATES
upvote

KAREEM ROFIAT BOLANLE commented on December 21, 2024
not yet written the exam
Anonymous
upvote

Subham commented on December 21, 2024
Good set of question for practice
Anonymous
upvote

Krish commented on December 20, 2024
Good to have test papers
INDIA
upvote

Ashish Sharma commented on December 20, 2024
Very elaborative explanation and apt questions
CANADA
upvote

Ashish Sharma commented on December 20, 2024
Very Useful
CANADA
upvote

Ashwani commented on December 20, 2024
Nice questions
UNITED KINGDOM
upvote

hardik commented on December 20, 2024
Very good content
UNITED STATES
upvote

Test commented on December 20, 2024
its helpful
Anonymous
upvote

haardik commented on December 20, 2024
Good so far
UNITED STATES
upvote

priya commented on December 20, 2024
good to prepare for the exam
Anonymous
upvote

Nagaraj commented on December 20, 2024
The questions help me to review
Anonymous
upvote