Designing Azure Infrastructure Solutions — Question 73

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 Azure SQL Database Premium, as it provides the necessary high availability features and ensures no data loss during failover. The other options, although they offer various benefits, either do not meet the availability requirements or may incur higher costs without the same level of data protection.