Designing Azure Infrastructure Solutions — Question 107

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

• A. Azure SQL Managed Instance Business Critical
• B. Azure SQL Managed Instance General Purpose
• C. Azure SQL Database Business Critical
• D. Azure SQL Database Serverless

Correct answer: D

Explanation

The correct answer is D, Azure SQL Database Serverless, as it provides a cost-effective solution while ensuring high availability and automatic scaling. Options A and C offer higher performance and features but at a greater cost, while option B lacks the required high availability features for maintaining operations during a zone outage.