Microsoft
AZ-305 · Question #281
Hotspot Question You have an on-premises Microsoft SQL Server database named SQL1. You plan to migrate SQL1 to Azure. You need to recommend a hosting solution for SQL1. The solution must meet the foll
Sign in or unlock AZ-305 to reveal the answer and full explanation for question #281. The question stem and answer options stay visible for context.
Submitted by chiamaka_o· Mar 6, 2026Design business continuity solutions
Question
Hotspot Question You have an on-premises Microsoft SQL Server database named SQL1. You plan to migrate SQL1 to Azure. You need to recommend a hosting solution for SQL1. The solution must meet the following requirements: - Support the deployment of multiple secondary, read-only replicas. - Support automatic replication between primary and secondary replicas. - Support failover between primary and secondary replicas within a 15- minute recovery time objective (RTO). What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer:
Exhibits
Answer Area
- Azure service or service tier:Azure SQL DatabaseAzure SQL managed InstanceThe Hyperscale service tier
- Replication mechanism:Active geo-replicationAuto-failover groupsStandard geo-replication
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.
Topics
#Azure SQL Database#Hyperscale#Auto-failover groups#Read replicas#RTO