Designing Azure Infrastructure Solutions — Question 94

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

Explanation

The correct answer is B, Azure SQL Database Business Critical, as it offers high availability and data redundancy features necessary for zero data loss during failovers and continues to operate during zone outages. Options A and D may not provide the same level of high availability, and option C does not meet the requirements for high availability or fault tolerance.