Exam AZ-305 topic 2 question 25 discussion

cosmos for the multi writer postgre is not good at reading

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.

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.

A is correct

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.

Why "D - Azure Cosmos DB for PostgreSQL" is incorrect ? Azure Cosmos DB for PostgreSQL fulfils all the requirements in the question

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.

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

As for speed, NoSQL is generally faster than SQL, especially for key-value storage in our experiment

Same as Question 10. https://www.examtopics.com/discussions/microsoft/view/67751-exam-az-305-topic-2-question-10-discussion

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.

correct answer