exam questions

Exam AZ-204 All Questions

View all questions & answers for the AZ-204 exam

Exam AZ-204 topic 6 question 22 discussion

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

You are creating an app that will use CosmosDB for data storage. The app will process batches of relational data.
You need to select an API for the app.
Which API should you use?

  • A. MongoDB API
  • B. Table API
  • C. SQL API
  • D. Cassandra API
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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 1 year, 8 months ago
Finally a question I can answer without any knowledge of Azure!
upvoted 19 times
CafeLago
8 months, 2 weeks ago
It could have been Core just to confuse you! HaHa
upvoted 1 times
...
...
DongKG
Highly Voted 3 years ago
Selected Answer: C
Because the app will process batches of relational data
upvoted 6 times
...
Zezere
Most Recent 3 months ago
Selected Answer: C
SQL API ist not SQL. It allows to use SQL queries, but the database itself is not relational. It has recently been renamed in " API for NoSQL". If we want a relational database, we have to use API for PostgreSQL, but it is not proposed. The question lacks information. How to choose?? I would still say C because at least this is the only API were we can use SQL language
upvoted 1 times
...
Ciupaz
1 year, 7 months ago
Selected Answer: C
Why not Table API? The Table API in Azure Cosmos DB is specifically designed for storing semi-structured or NoSQL data in a schema-less fashion, not for storing traditional relational data. Here are some reasons why the Table API is not a good choice for handling relational data.
upvoted 1 times
overhill
5 months, 1 week ago
Legit question, from the two SQL API is the more suitable I would say.
upvoted 1 times
...
...
escame
2 years, 2 months ago
Selected Answer: C
C is correct
upvoted 3 times
...
mark_1234
2 years, 2 months ago
Selected Answer: C
SQL is the only relational data storage type there.
upvoted 1 times
...
OPT_001122
2 years, 5 months ago
Selected Answer: C
C - correct answer
upvoted 3 times
...
Chief2110
2 years, 7 months ago
Selected Answer: C
C should be the answer
upvoted 3 times
...
Frefren
2 years, 7 months ago
Selected Answer: C
Relational data
upvoted 4 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