Designing Azure Infrastructure Solutions — Question 22

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

• A. Azure SQL Database Business Critical
• B. Azure SQL Managed Instance Business Critical
• C. Azure SQL Database Standard
• D. Azure SQL Managed Instance General Purpose

Correct answer: A

Explanation

The Azure SQL Database Business Critical tier provides high availability with a built-in high availability feature that ensures no data loss during failover. The other options either do not guarantee zero data loss or are not optimized for high availability in the event of a zone outage, making them less suitable for this scenario.