exam questions

Exam AZ-204 All Questions

View all questions & answers for the AZ-204 exam

Exam AZ-204 topic 3 question 24 discussion

Actual exam question from Microsoft's AZ-204
Question #: 24
Topic #: 3
[All AZ-204 Questions]

HOTSPOT -
You are developing an application to collect the following telemetry data for delivery drivers: first name, last name, package count, item id, and current location coordinates. The app will store the data in Azure Cosmos DB.
You need to configure Azure Cosmos DB to query the data.
Which values should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Core (SQL)
Core(SQL) API stores data in document format. It offers the best end-to-end experience as we have full control over the interface, service, and the SDK client libraries. SQL API supports analytics and offers performance isolation between operational and analytical workloads.

Box 2: item id -
item id is a unique identifier and is suitable for the partition key.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/choose-api
https://docs.microsoft.com/en-us/azure/cosmos-db/partitioning-overview

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
[Removed]
Highly Voted 2 years, 7 months ago
Without knowing the functionality or the usage pattern or what it is for. Good lord, Microsoft
upvoted 43 times
...
serpevi
Highly Voted 2 years, 7 months ago
Got this in 09/22 , went with SQL and Item Id, score 927.
upvoted 24 times
...
130nk3r5
Most Recent 1 year, 3 months ago
Got this today. Went with answer here. Score 927
upvoted 7 times
Gauravbio
11 months, 3 weeks ago
Core sql api removed now, it should be no sql api
upvoted 1 times
...
...
Tarajee
1 year, 7 months ago
On my exam 2023sept
upvoted 8 times
...
NightshadeRC
1 year, 9 months ago
Had this question in today's exam: 2023-07-26
upvoted 5 times
...
[Removed]
1 year, 9 months ago
Answer seems correct, but the question is very bad. It doesn't even tell about the usage, so it could be Table API as well
upvoted 7 times
...
sarmaria
2 years, 1 month ago
Got this question in the exam on 16/03/2023. Went with SQL and Item Id . Make sure to prepare for case studies. I got city and lights case study.
upvoted 5 times
MarcoStewart
1 year, 10 months ago
where can one find these case studies?
upvoted 3 times
CarlosTheBoldest
1 year, 5 months ago
Page 32 and above
upvoted 1 times
Puja079888
1 year, 2 months ago
did contributor access is needed to pass the exam?
upvoted 1 times
Christian_garcia_martin
8 months, 2 weeks ago
yes it is
upvoted 1 times
...
...
...
...
...
warchoon
2 years, 2 months ago
They changed names again. "Core (SQL)" is "Api for NoSQL" now. Its wonderful to choose "SQL" for "NoSQL". https://www.c-sharpcorner.com/article/road-to-az-2044/#:~:text=Core%20SQL%20API%2C%20default%20API%20for%20using%20Azure%20Cosmos%20DB%20enables%20querying%20your%20data%20with%20a%20language%20very%20close%20to%20SQL%3B https://learn.microsoft.com/en-us/azure/cosmos-db/choose-api#coresql-api:~:text=API%20for%20NoSQL%20is%20native%20to%20Azure%20Cosmos%20DB.
upvoted 12 times
...
Esward
2 years, 3 months ago
given answers are correct
upvoted 2 times
...
OPT_001122
2 years, 5 months ago
SQL and Item Id
upvoted 2 times
...
rol204
2 years, 6 months ago
correct
upvoted 2 times
...
kampatra
2 years, 7 months ago
Answer is correct: https://docs.microsoft.com/en-us/azure/cosmos-db/choose-api
upvoted 4 times
...
dtctx
3 years ago
Received this in test on 4/29 and passed the test. Went with Table API and Item ID. I do not know if Table API is correct, but I am confident that Item ID is.
upvoted 4 times
CarlosTheBoldest
1 year, 5 months ago
Table API is for manage tables, SQL is for queries
upvoted 1 times
...
...
sghaha
3 years ago
https://docs.microsoft.com/ko-kr/azure/cosmos-db/choose-api
upvoted 1 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