Microsoft
AZ-305 · Question #155
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
Sign in or unlock AZ-305 to reveal the answer and full explanation for question #155. The question stem and answer options stay visible for context.
Submitted by chiamaka_o· Mar 6, 2026Design data storage solutions
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?
Options
- AAzure SQL Database Standard
- BAzure SQL Database Serverless
- CAzure SQL Managed Instance General Purpose
- DAzure SQL Database Premium
Unlock AZ-305 to see the answer
You've previewed enough free AZ-305 questions. Unlock AZ-305 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.