Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam AZ-305 topic 2 question 25 discussion

Actual exam question from Microsoft's AZ-305
Question #: 25
Topic #: 2
[All AZ-305 Questions]

You are designing an application that will aggregate content for users.

You need to recommend a database solution for the application. The solution must meet the following requirements:

• Support SQL commands.
• Support multi-master writes.
• Guarantee low latency read operations.

What should you include in the recommendation?

  • A. Azure Cosmos DB for NoSQL
  • B. Azure SQL Database that uses active geo-replication
  • C. Azure SQL Database Hyperscale
  • D. Azure Cosmos DB for PostgreSQL
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Coolfrenesie
Highly Voted 1 year, 2 months ago
Selected Answer: A
cosmos for the multi writer postgre is not good at reading
upvoted 10 times
Debosree
1 year, 1 month ago
No SQL supports SQLquery ?
upvoted 3 times
Lonlystar
10 months ago
It is not a "No SQL", it is a "Not Only SQL". Hence, it does support SQL query. Hope it helps.
upvoted 28 times
xRiot007
3 months ago
This is an unfortunate abbreviation, to say the least :) Should have called it SQL+ or something that shows SQL availability, plus other options.
upvoted 4 times
...
...
jozir8
1 year ago
Yes, it does. https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/how-to-dotnet-query-items - The Azure Cosmos DB for NoSQL supports the use of Structured Query Language (SQL) to perform queries on items in containers.
upvoted 8 times
GS300
1 year ago
microsoft is weird
upvoted 15 times
...
...
...
...
NotMeAnyWay
Highly Voted 1 year, 1 month ago
Selected Answer: A
2 / 2 A. Azure Cosmos DB for NoSQL Azure Cosmos DB is a globally distributed, multi-model database service that supports SQL commands, multi-master writes, and guarantees low latency read operations. It supports a variety of NoSQL data models including document, key-value, graph, and column-family. Azure Cosmos DB provides automatic and instant scalability, high availability, and low latency globally by replicating and synchronizing data across multiple Azure regions. On the other hand, Azure SQL Database and Azure SQL Database Hyperscale are traditional relational database services that do not natively support multi-master writes.
upvoted 6 times
...
Lazylinux
Most Recent 2 weeks, 2 days ago
Selected Answer: A
Given answer A is correct Cosmo DB for NOSQL or Cosmo DB SQL API provides the following features • Support SQL commands. • Support multi-master writes. • Guarantee low latency read operations.
upvoted 1 times
...
Zein135
2 months ago
Why "D - Azure Cosmos DB for PostgreSQL" is incorrect ? Azure Cosmos DB for PostgreSQL fulfils all the requirements in the question
upvoted 1 times
...
BShelat
5 months, 1 week ago
Content aggregation is the main objective. Content can be structured or unstructured. NoSQL = "Not Only SQL" i.e. it can deal with any kind of content - structured or unstructured. Cosmos DB support multi master writes synchronously during replication and provide low latency for reads across regions as long as distributed DBs are nearer (local) to users who access it. So answer is Azure Cosmos DB for NoSQL.
upvoted 2 times
...
dave22339
9 months, 3 weeks ago
Although Azure Cosmos supports Multi Region Writes, Azure Cosmos for PostgreSQL does not. https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/introduction#fully-managed-resilient-database
upvoted 3 times
...
jwu2023
10 months, 2 weeks ago
As for speed, NoSQL is generally faster than SQL, especially for key-value storage in our experiment
upvoted 2 times
...
zellck
1 year, 2 months ago
Same as Question 10. https://www.examtopics.com/discussions/microsoft/view/67751-exam-az-305-topic-2-question-10-discussion
upvoted 4 times
Debosree
1 year, 1 month ago
nope . Here it is Cosmos DB for NoSQL earlier question had right optionAzure Cosmos DB for SQL API.
upvoted 6 times
...
...
zellck
1 year, 2 months ago
Selected Answer: A
A is the answer. https://learn.microsoft.com/en-us/azure/cosmos-db/introduction#key-benefits - Gain unparalleled SLA-backed speed and throughput, fast global access, and instant elasticity. Real-time access with fast read and write latencies globally, and throughput and consistency all backed by SLAs - Multi-region writes and data distribution to any Azure region with just a button.
upvoted 3 times
...
Alessandro365
1 year, 2 months ago
Selected Answer: A
correct answer
upvoted 1 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 ...