Microsoft Azure Fundamentals (AZ-900)Describe Azure architecture and servicesMedium
A financial institution is developing a new online banking application. They require a database solution that offers high availability, global distribution with multi-master capabilities, and low-latency access for users worldwide. Which Azure database service is best suited for these requirements?
- AAzure Database for MySQL
- BAzure Table Storage
- CAzure SQL Database
- DAzure Cosmos DB
Show answer & explanationAnswer & explanation
Correct answer: D. Azure Cosmos DB
Azure Cosmos DB is a globally distributed, multi-model database service that offers multi-master replication, guaranteeing low-latency access and high availability for applications worldwide.
Why the other options are wrong
- A. Azure Database for MySQL is a relational database service, not designed for global multi-master distribution and low-latency worldwide access in the same way as Cosmos DB.
- B. Azure Table Storage is a NoSQL key-value store, suitable for massive amounts of structured non-relational data, but lacks multi-master global distribution for complex applications.
- C. Azure SQL Database is a relational database and while highly available, it doesn't inherently provide global multi-master distribution out-of-the-box like Cosmos DB.
Azure Cosmos DB
Microsoft's globally distributed, multi-model database service for managing data at planet-scale with guaranteed high availability and low latency.
- Globally distributed.
- Multi-master replication.
- Multi-model (document, key-value, graph, column-family).
- Guaranteed low latency and high availability.
Memory trick: Cosmos is for global, fast, and flexible data needs.