Microsoft Azure Architect Design (2020, legacy) — Question 61

You need to design a highly available Azure SQL database that meets the following requirements:
✑ Failover between replicas of the database must occur without any data loss.
✑ The database must remain available in the event of a zone outage.
✑ Costs must be minimized.
Which deployment option should you use?

Answer options

Correct answer: C

Explanation

The Azure SQL Database Business Critical option provides high availability with no data loss during failover and supports zone redundancy, making it ideal for the given requirements. The other options, such as Standard and Basic, do not offer the necessary failover capabilities or zone resilience, while Serverless may not guarantee consistent availability.