Exam AZ-305 topic 2 question 10 discussion

Correct answer - A

Exam Question 12/28/2022. Instead of the Cosmos DB SQL, the option was Cosmos DB NoSQL

Got this on may. 02, 2025 , Score 925, the given answer is correct

The answer is A, Cosmos DB SQL API. - Azure Cosmos DB supports multi-master writes. - The SQL API in Cosmos DB allows for SQL-like queries

A is correct

Azure Cosmos DB SQL API Why not the other options: Azure SQL Database that uses active geo-replication: While it supports SQL commands and multi-master writes, it might not be as scalable and globally distributed as Cosmos DB. It's better suited for traditional relational database workloads. Azure SQL Database Hyperscale: This is a high-performance option for relational data, but it might not be the best choice for a globally distributed application with high write throughput. Azure Database for PostgreSQL: While it's a popular open-source database, it might not offer the same level of global distribution and scalability as Cosmos DB. Therefore, Azure Cosmos DB SQL API is the optimal choice for your application, as it meets all the required criteria and offers excellent performance and scalability.

Given answer A is correct Azure Cosmos DB SQL API or can be rewarded to Azure Cosmos DB for NOSQL API Azure Cosmos DB for NoSQL Azure Cosmos DB's core, or native API for working with documents. Supports fast, flexible development with familiar SQL query language and client libraries for .NET, JavaScript, Python, and Java.

Got this on Nov. 17, 2023

Azure SQL Database that uses active geo-replication cannot be an answer because it does not offer multi-master write. Active geo-replication is a feature that lets you create a continuously synchronized readable secondary database for a primary database. The secondary database is read-only. So, Cosmos DB SQL is the only right answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview?view=azuresql

A. Azure Cosmos DB SQL API Azure Cosmos DB is a globally distributed, multi-model database service. It offers turnkey global distribution, automatically replicating your data to any number of Azure regions so you can achieve low latency access from anywhere in the world. Cosmos DB supports various APIs for data access including SQL (Core) API, which uses SQL commands. It provides multi-master support, which allows you to perform writes on any of your replicas and replicate data across all of them for high availability. So it will cover your requirement of supporting multi-master writes. In terms of guaranteeing low latency read operations, Azure Cosmos DB offers <10 ms latencies at the 99th percentile for reads and writes, which would serve your need of low latency reads.

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; https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/how-to-multi-master?tabs=api-async#:~:text=data%20globally%20pane.-,Under%20the%20Multi%2Dregion%20writes%20option%2C%20choose%20enable.%20It%20automatically%20adds%20the%20existing%20regions%20to%20read%20and%20write%20regions.,-You%20can%20add

A. Azure Cosmos DB SQL API As Ghoshy mentioned, the option could have been Cosmos DB NoSQL also

In the exam I had in Jan 2023, I got the same question with different answering items. There was no “Azure Cosmos DB SQL API ”, and the answering items presented were Azure Cosmos DB for NoSQL Azure Cosmos DB for PostgreSQL

Correct answer - A https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-multi-master?tabs=api-async

Correct answer - A https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-multi-master?tabs=api-async

In my exam, 9 april 22, 817/1000, I chose this answer