Designing Azure Infrastructure Solutions — Question 47

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 provides the necessary features for high availability and failover without data loss, making it suitable for mission-critical applications. In contrast, Hyperscale is designed for scalability rather than high availability, Basic does not support the required features for failover, and Serverless may not guarantee the level of availability needed during a zone outage.