Microsoft Exam AZ-305 Topic 8 Question 40 Discussion

Actual exam question for Microsoft's AZ-305 exam

Question #: 40
Topic #: 8

You are designing an app that will use Azure Cosmos DB to collate sales data from multiple countries. You need to recommend an API for the app. The solution must meet the following requirements:

* Support SQL queries.

* Support geo-replication.

* Store and access data relationally.

Which API should you recommend?

APostgreSQL

BNoSQL

CApache Cassandra

DMongoDB

Show Suggested Answer

Suggested Answer: C

by Bobbye at Jul 09, 2023, 07:22 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Jamey

3 days ago

The requirements clearly point to Azure Cosmos DB, so I would recommend option B) NoSQL. It supports SQL queries, geo-replication, and stores data relationally.

upvoted 0 times

...

Dante

16 days ago

I see both points, but I think Apache Cassandra might be the best option as it supports SQL queries, geo-replication, and can store data relationally.

upvoted 0 times

...

Natalie

18 days ago

I disagree, I believe we should recommend MongoDB because it supports geo-replication and can store data relationally as well.

upvoted 0 times

...

Meaghan

21 days ago

I think we should recommend PostgreSQL because it supports SQL queries and can store data relationally.

upvoted 0 times

...

Paris

22 days ago

But MongoDB is a NoSQL database, it may not be the best choice for storing data relationally.

upvoted 0 times

...

Celestina

25 days ago

I disagree, I believe we should recommend MongoDB because it also supports SQL queries and geo-replication.

upvoted 0 times

...

Paris

28 days ago

I think we should recommend PostgreSQL because it supports SQL queries and can store data relationally.

upvoted 0 times

...