Exam DP-420 topic 1 question 19 discussion

Actual exam question from Microsoft's DP-420

Question #: 19
Topic #: 1

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?

A. Create a new synthetic key that contains deviceId and timestamp
B. Use timestamp as the partition key
C. Use deviceManufacturer as the partition key
D. Use sensor1Value as the partition key

Show Suggested Answer

Suggested Answer: A 🗳️

by imando at March 31, 2023, 11:56 a.m.

Comments

Submit Cancel

Tuopikson

3 months, 2 weeks ago

Selected Answer: A

A is correct answer. Device id + timestamp avoid hot partitions, minimize partition skew and capacity limits. Choosing timestamp alone or static values like deviceManufacturer or sensor1Value wouldn't provide the dynamic distribution needed to handle frequent writes effectively. Thus, a combination key such as deviceId and timestamp is the most efficient way to achieve balanced partitioning for IoT device data.

upvoted 1 times

...

imando

7 months ago

Selected Answer: A

Correct answer

upvoted 4 times

...

Exam DP-420 All Questions

View all questions & answers for the DP-420 exam

Exam DP-420 topic 1 question 19 discussion

Comments

Tuopikson

imando

SY0-701