Designing Azure Infrastructure Solutions — Question 53

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: D

Explanation

The correct choice is D, Azure SQL Database Business Critical, as it provides high availability with automatic failover and data redundancy, ensuring no data loss. The other options either do not provide the necessary high availability features (A, B, C) or are not optimized for such scenarios.