You are designing an application that aggregates content for users. The database solution must support SQL queries, allow multi-master (multi-region) writes, and guarantee low-latency read operations. Which database should you recommend?
Choose an answer
Tap an option to check your answer.
Correct answer: Azure Cosmos DB SQL API.
Why this is the answer
Azure Cosmos DB SQL API is the correct choice because it natively supports SQL queries, offers multi-master write capabilities across regions, and provides guaranteed low-latency reads (single-digit millisecond latencies). This aligns perfectly with all the requirements. Azure SQL Database with active geo-replication primarily focuses on disaster recovery and read-scale out, but it does not support multi-master writes. Azure SQL Database Hyperscale is a single-region solution designed for large databases, not multi-master writes or global distribution. Azure Database for PostgreSQL is a relational database that also lacks native multi-master write capabilities across regions and guaranteed low-latency global reads.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed