You are designing an Azure Cosmos DB Core (SQL) API solution to store data from...

Microsoft DP-420 Question Answer

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?

Use timestamp as the partition key.

Create a new synthetic key that contains deviceId and sensor1Value.

Create a new synthetic key that contains deviceId and deviceManufacturer.

Create a new synthetic key that contains deviceId and a random number.

DP-420 PDF/Engine

Get 65% Discount on All Products, Use Coupon: "ac4s65"