Designing Azure Infrastructure Solutions — Question 95

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 Azure SQL Database Premium option supports high availability with no data loss during failover and is designed to handle zone outages effectively. The Business Critical tier offers more features but at a higher cost, while Basic and Hyperscale options do not meet the required availability and failover capabilities.