Designing Azure Infrastructure Solutions — Question 103

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 Azure SQL Database Premium option provides high availability and guarantees no data loss during failover, making it suitable for your needs. The other options either do not provide the same level of availability or failover capabilities, or they may not be designed to handle zone outages effectively.