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

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

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

by sghaha at April 28, 2022, 4:25 p.m.

Comments

Submit Cancel

[Removed]

Highly Voted 2 years, 8 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, 9 months ago

Got this in 09/22 , went with SQL and Item Id, score 927.

upvoted 24 times

...

130nk3r5

Most Recent 1 year, 5 months ago

Got this today. Went with answer here. Score 927

upvoted 7 times

Gauravbio

1 year ago

Core sql api removed now, it should be no sql api

upvoted 1 times

...

Tarajee

1 year, 9 months ago

On my exam 2023sept

upvoted 8 times

...

NightshadeRC

1 year, 10 months ago

Had this question in today's exam: 2023-07-26

upvoted 5 times

...

[Removed]

1 year, 11 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, 2 months 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, 12 months ago

where can one find these case studies?

upvoted 3 times

CarlosTheBoldest

1 year, 6 months ago

Page 32 and above

upvoted 1 times

Puja079888

1 year, 3 months ago

did contributor access is needed to pass the exam?

upvoted 1 times

Christian_garcia_martin

9 months, 3 weeks ago

yes it is

upvoted 1 times

...

warchoon

2 years, 3 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, 4 months ago

given answers are correct

upvoted 2 times

...

OPT_001122

2 years, 6 months ago

SQL and Item Id

upvoted 2 times

...

rol204

2 years, 7 months ago

correct

upvoted 2 times

...

kampatra

2 years, 8 months ago

Answer is correct: https://docs.microsoft.com/en-us/azure/cosmos-db/choose-api

upvoted 4 times

...

dtctx

3 years, 1 month 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, 6 months ago

Table API is for manage tables, SQL is for queries

upvoted 1 times

...

sghaha

3 years, 1 month ago

https://docs.microsoft.com/ko-kr/azure/cosmos-db/choose-api

upvoted 1 times

...