Designing Microsoft Azure Infrastructure Solutions AZ-305 — Topic 4 Question 219

Question

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?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Azure SQL Database Premium Azure SQL Database is a fully managed relational database with automatic patching, backups, and scaling. By spanning multiple Availability Zones / adding redundancy, this option provides the high availability and resilience required.

Designing Microsoft Azure Infrastructure Solutions AZ-305 — Question 219