Microsoft Azure Fundamentals AZ-900
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You are tasked with deploying a database solution on Azure that must be highly available, scalable, and support automatic failover and read replicas to ensure business continuity and performance. The solution should also consider cost-effectiveness and compliance with data residency requirements. Given these requirements, which Azure database service would you choose, and why? Please select the best option from the following. (Choose one correct option)
A
Azure SQL Database, due to its built-in high availability and scalability features, including automatic failover and read replicas, which meet the requirements without additional configuration.
B
Azure Cosmos DB, for its global distribution and multi-region writes capability, which might exceed the specified requirements and increase costs unnecessarily.
C
Azure Database for MySQL, offering a managed MySQL service with high availability options, but may not fully support automatic failover as seamlessly as Azure SQL Database.
D
Azure Database for PostgreSQL, providing a managed PostgreSQL service with read replicas, yet it might not offer the same level of built-in high availability features as Azure SQL Database.