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

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: A. The correct answer is A. Option A: Azure SQL Database Business Critical 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 229