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

Dante

2 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

4 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

7 days ago

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

upvoted 0 times

...

Paris

8 days ago

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

upvoted 0 times

...

Celestina

11 days ago

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

upvoted 0 times

...

Paris

14 days ago

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

upvoted 0 times

...