Designing Azure Infrastructure Solutions — Question 42

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 correct answer is Azure SQL Database Premium as it provides high availability with no data loss during failover and can sustain availability during zone outages. The other options may not meet all the requirements, particularly in terms of high availability and disaster recovery features.