Designing Azure Infrastructure Solutions — Question 114

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

Azure SQL Database Premium is the correct choice as it offers high availability features that allow for failover without data loss and can sustain availability during zone outages. The other options do not provide the same level of high availability or are not suited for minimizing costs effectively while achieving these requirements.