Designing Azure Infrastructure Solutions — Question 5

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?

Answer options

Correct answer: A

Explanation

The correct choice, Azure Cosmos DB SQL API, meets all the specified requirements as it supports SQL commands, allows for multi-master writes, and offers low latency reads. The other options do not fulfill all of these criteria; for instance, Azure SQL Database with active geo-replication does not support multi-master writes, while Azure SQL Database Hyperscale and Azure Database for PostgreSQL do not guarantee the same level of low latency in read operations.