exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

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 (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Coolfrenesie
Highly Voted 1 year, 9 months ago
Selected Answer: A
cosmos for the multi writer postgre is not good at reading
upvoted 10 times
Debosree
1 year, 8 months ago
No SQL supports SQLquery ?
upvoted 4 times
erikdran
6 months ago
:))) it sounds funny.
upvoted 2 times
...
Lonlystar
1 year, 4 months ago
It is not a "No SQL", it is a "Not Only SQL". Hence, it does support SQL query. Hope it helps.
upvoted 36 times
xRiot007
9 months, 3 weeks 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 7 times
...
...
jozir8
1 year, 7 months 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, 7 months ago
microsoft is weird
upvoted 16 times
...
...
...
...
NotMeAnyWay
Highly Voted 1 year, 8 months 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
...
robinhoHH
Most Recent 1 week ago
Selected Answer: D
Considering the need for SQL support, multi-master writes, and low-latency reads, Azure Cosmos DB for PostgreSQL is the optimal choice, as it combines the familiarity of PostgreSQL with the distributed capabilities of Azure Cosmos DB.
upvoted 1 times
...
SeMo0o0o0o
3 weeks, 1 day ago
Selected Answer: A
A is correct
upvoted 1 times
...
Lazylinux
7 months, 1 week 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 2 times
...
Zein135
8 months, 3 weeks 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
12 months 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
1 year, 4 months 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
1 year, 5 months ago
As for speed, NoSQL is generally faster than SQL, especially for key-value storage in our experiment
upvoted 2 times
...
zellck
1 year, 9 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, 8 months 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, 9 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, 9 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 ...