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

Jessenia

29 days ago

As a certified Azure expert, I can confidently say that B) NoSQL is the way to go here. Cosmos DB is the perfect fit for this scenario. *winks* Didn't even need to think twice about it.

upvoted 0 times

...

Tawanna

1 months ago

Hold on, didn't you say we need to store and access data relationally? In that case, I'd go with A) PostgreSQL. Can't go wrong with a good ol' SQL database!

upvoted 0 times

...

Kenia

1 months ago

Hah, PostgreSQL? Really? That's a relational database, not NoSQL. Definitely going with B) NoSQL.

upvoted 0 times

Nan

5 days ago

I agree, NoSQL is the best choice for storing and accessing data relationally.

upvoted 0 times

...

Dallas

10 days ago

NoSQL is the way to go for this app.

upvoted 0 times

...

Stephanie

1 months ago

I think option D) MongoDB is the best choice here. It meets all the requirements and is a popular NoSQL database choice.

upvoted 0 times

Marica

2 days ago

But MongoDB also supports geo-replication, which is important for this app.

upvoted 0 times

...

Talia

9 days ago

I think PostgreSQL might be a better option since it supports SQL queries.

upvoted 0 times

...

Beatriz

13 days ago

I agree, MongoDB is a great choice for this scenario.

upvoted 0 times

...

Jamey

2 months 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

Tracey

15 days ago

I agree, NoSQL is the most suitable API for this scenario.

upvoted 0 times

...

Helga

18 days ago

NoSQL is the way to go for supporting SQL queries and geo-replication.

upvoted 0 times

...

Skye

1 months ago

B) NoSQL would be the best option for this app.

upvoted 0 times

...

Dante

2 months 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

2 months 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

2 months ago

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

upvoted 0 times

...

Paris

2 months ago

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

upvoted 0 times

...

Celestina

2 months ago

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

upvoted 0 times

...

Paris

2 months ago

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

upvoted 0 times

...