New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft AZ-204 Exam - Topic 8 Question 25 Discussion

Actual exam question for Microsoft's AZ-204 exam
Question #: 25
Topic #: 8
[All AZ-204 Questions]

You are developing an Azure Cosmos DB solution by using the Azure Cosmos DB SQL API. The data includes millions of documents. Each document may contain hundreds of properties.

The properties of the documents do not contain distinct values for partitioning. Azure Cosmos DB must scale individual containers in the database to meet the performance needs of the application by spreading the workload evenly across all partitions over time.

You need to select a partition key.

Which two partition keys can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer: A, C

You can form a partition key by concatenating multiple property values into a single artificial partitionKey property. These keys are referred to as synthetic keys.

Another possible strategy to 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.

Note: It's the best practice to have a partition key with many distinct values, such as hundreds or thousands. The goal is to distribute your data and workload evenly across the items associated with these partition key values. If such a property doesn't exist in your data, you can construct a synthetic partition key.

References:

https://docs.microsoft.com/en-us/azure/cosmos-db/synthetic-partition-keys


by Serina at May 03, 2022, 09:37 PM

Limited Time Offer

25%

Off

Get Premium AZ-204 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Tasia
4 months ago
Agree, the random suffix idea seems like a smart way to distribute load.
upvoted 0 times
...
Ming
4 months ago
Surprised that a value containing the collection name is not a good option!
upvoted 0 times
...
Rodolfo
4 months ago
Not sure about using a single property value that appears frequently.
upvoted 0 times
...
Erasmo
5 months ago
I think a hash suffix appended to a property value could work too!
upvoted 0 times
...
Filiberto
5 months ago
A concatenation of multiple property values with a random suffix sounds solid.
upvoted 0 times
...
Kami
5 months ago
I’m leaning towards the collection name as a partition key, but I recall that it might not provide enough variability for scaling.
upvoted 0 times
...
Asha
5 months ago
I practiced a similar question where we had to choose between different partition keys, and I feel like the hash suffix option could help distribute the load better.
upvoted 0 times
...
Bobbye
5 months ago
I think a concatenation of multiple property values could work, but I’m a bit confused about how that would scale with millions of documents.
upvoted 0 times
...
Ronald
5 months ago
I remember we discussed that using a single property value that appears frequently might not be ideal for partitioning, but I’m not sure about the hash suffix option.
upvoted 0 times
...
Candra
5 months ago
This seems like a straightforward question about the role of a business analyst. I'm pretty confident I can figure this out.
upvoted 0 times
...
Yuriko
5 months ago
This seems like a straightforward question. The business analyst is responsible for discovering, synthesizing, and analyzing information within an enterprise, so I'll go with option B.
upvoted 0 times
...

Save Cancel