You are designing an Azure Cosmos DB for NoSQL 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…

Question

Exhibit

Options

• AUse timestamp as the partition key.
• BCreate a new synthetic key that contains deviceId and sensor1Value.
• CCreate a new synthetic key that contains deviceId and deviceManufacturer.
• DCreate a new synthetic key that contains deviceId and a random number.

• A
  5% (1)
• B
  10% (2)
• C
  5% (1)
• D
  81% (17)

Explanation

Use a partition key with a random suffix. 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.

No community discussion yet for this question.