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?
Click on the arrows to vote for the correct answer
A. B. C. D.A
With Cosmos DB's novel multi-region (multi-master) writes replication protocol, every region supports both writes and reads. The multi-region writes capability also enables:
Unlimited elastic write and read scalability.
99.999% read and write availability all around the world.
Guaranteed reads and writes served in less than 10 milliseconds at the 99th percentile.
https://docs.microsoft.com/en-us/azure/cosmos-db/distribute-data-globallyFor the given requirements, the best recommendation would be Azure Cosmos DB SQL API (Option A).
Azure Cosmos DB is a globally distributed, multi-model database service. It provides support for NoSQL data, and also provides a SQL API that allows users to perform SQL-like queries over the data. It also provides multi-master replication, which means that users can write to any replica of the database, and the changes will be propagated to all other replicas in near-real-time. This makes it ideal for applications that require high write throughput and low-latency reads.
Let's take a look at each of the options and why they might not be the best choice:
Option B: Azure SQL Database that uses active geo-replication Azure SQL Database is a managed SQL database service provided by Microsoft. While it does support SQL commands, it does not support multi-master writes. Active geo-replication is a feature that allows you to replicate your database to one or more secondary regions, but it does not provide multi-master writes.
Option C: Azure SQL Database Hyperscale Azure SQL Database Hyperscale is a variant of Azure SQL Database that is designed for large-scale applications with high storage requirements. It does support SQL commands, but it does not support multi-master writes. While it does provide low latency read operations, it is not designed for high write throughput.
Option D: Azure Database for PostgreSQL Azure Database for PostgreSQL is a managed PostgreSQL database service provided by Microsoft. While it does support SQL commands, it does not support multi-master writes. Additionally, it is not designed for low latency read operations, as it is optimized for analytical workloads rather than transactional workloads.
Therefore, based on the requirements provided, Azure Cosmos DB SQL API (Option A) is the best recommendation.