Designing Azure Infrastructure Solutions — Question 60

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

Azure SQL Database Premium is designed for high availability with features that ensure no data loss during failover, making it suitable for your requirements. Other options like Azure SQL Managed Instance General Purpose and Hyperscale may not guarantee the same level of availability and data loss prevention. The Business Critical option, while highly available, may not align with the requirement to minimize costs.