exam questions

Exam AZ-204 All Questions

View all questions & answers for the AZ-204 exam

Exam AZ-204 topic 3 question 18 discussion

Actual exam question from Microsoft's AZ-204
Question #: 18
Topic #: 3
[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.

  • A. a single property value that does not appear frequently in the documents
  • B. a value containing the collection name
  • C. a single property value that appears frequently in the documents
  • D. a concatenation of multiple property values with a random suffix appended
  • E. a hash suffix appended to a property value
Show Suggested Answer Hide Answer
Suggested Answer: DE 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
TEMPKAKAM
Highly Voted 4 years, 5 months ago
The given answer is correct
upvoted 74 times
...
mlantonis
Highly Voted 3 years, 11 months ago
D and E Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/synthetic-partition-keys
upvoted 18 times
...
vizay
Most Recent 4 days, 1 hour ago
Selected Answer: DE
Use a custom key — like: A combination of fields (e.g., userId + timestamp) Or a random ID/hash to spread documents evenly "A hash suffix appended to a property value" means: Take a property value (like a userId), then add a random or hashed number to the end to make it more unique. Partition key = "user123#1" Partition key = "user123#2" Partition key = "user123#3"
upvoted 1 times
...
wafa_chaari
3 months ago
Selected Answer: DE
you must construct a synthetic partition key. 1-by concatenating multiple property values into a single partitionkey (expl: name=azure , date= 2024--> partitionkey= azure2024) 2-use a partition key with a random suffix ( expl azure1 , azure3..)
upvoted 1 times
...
Vichu_1607
5 months, 4 weeks ago
Selected Answer: DE
D. a concatenation of multiple property values with a random suffix appended E. a hash suffix appended to a property value
upvoted 1 times
...
jobolesonihal
1 year, 1 month ago
Selected Answer: CE
Copilot says C and E With D - random suffice for each item may be an overkill.
upvoted 1 times
...
JoseManel
1 year, 5 months ago
Selected Answer: DE
D. a concatenation of multiple property values with a random suffix appended Most Voted E. a hash suffix appended to a property value Most Voted
upvoted 2 times
...
[Removed]
1 year, 9 months ago
Given answer is incorrect. Correct answer: AE
upvoted 1 times
Net_IT
1 year, 6 months ago
That is not the given answer? It is D and E.
upvoted 1 times
...
...
narenazure
2 years, 3 months ago
Selected Answer: DE
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
upvoted 2 times
...
mdg3501
2 years, 4 months ago
got this on 2022-12-7
upvoted 5 times
...
OPT_001122
2 years, 5 months ago
Selected Answer: DE
D. a concatenation of multiple property values with a random suffix appended Most Voted E. a hash suffix appended to a property value Most Voted
upvoted 2 times
...
TheExamMaster2020
2 years, 5 months ago
Did my exam on 15th November 2022. This question was on it.
upvoted 4 times
...
coffecold
2 years, 6 months ago
at option E : a hash value will always deliver the same result on the same data. It is not a random value as stated in the proposed solution. Since A,B and C fall off, and two answers must be chosen still I would go for D,E.
upvoted 2 times
...
xRiot007
2 years, 10 months ago
Selected Answer: DE
If no property in the document data will have unique values, you need to make one. This is called a synthetic partition key. These sorts of keys are made by adding a unique suffix at the end of some property. One other way is to create a property that will have the hashed data + a random suffix. The objective is to have a property that is random enough so that you can rely on it to be your key.
upvoted 6 times
...
Eltooth
2 years, 10 months ago
Selected Answer: DE
D & E are the correct answers.
upvoted 1 times
...
Rini100
3 years ago
Got this on 20 Apr 2022
upvoted 2 times
...
oescm
3 years, 2 months ago
Got this one 02/2022. Went with highly voted answer.
upvoted 6 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago