Designing Azure Infrastructure Solutions — Question 18

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 correct answer is C, Azure SQL Database Business Critical, as it provides high availability with no data loss and ensures the database remains operational during zone failures. Options A and B do not meet the high availability requirements, while option D, although capable, is typically more expensive than option C.