Designing Azure Infrastructure Solutions — Question 56

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: A

Explanation

The Azure SQL Database Business Critical tier offers high availability with no data loss during failover and is designed to remain operational even in the event of a zone outage. Options B and C do not provide the same level of availability and redundancy as required, while D, although scalable, does not meet the specific failover requirements outlined.