Microsoft
AZ-305 · Question #309
Hotspot Question You have two on-premises Microsoft SQL Server 2017 instances that host an Always On availability group named AG1. AG1 contains a single database named DB1. You have an Azure subscript
Sign in or unlock AZ-305 to reveal the answer and full explanation for question #309. The question stem and answer options stay visible for context.
Submitted by akirajp· Mar 6, 2026Design business continuity solutions
Question
Hotspot Question You have two on-premises Microsoft SQL Server 2017 instances that host an Always On availability group named AG1. AG1 contains a single database named DB1. You have an Azure subscription that contains a virtual machine named VM1. VM1 runs Linux and contains a SQL Server 2019 instance. You need to migrate DB1 to VM1. The solution must minimize downtime on DB1. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer:
Exhibit
Answer Area
- Prepare for the migration by:Adding a secondary replica to AG1Creating an Always On availability group on VM1Upgrading the on-premises SQL Server instances
- Perform the migration by using:A distributed availability groupAzure MigrateLog shipping
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
#SQL Server Always On AG#secondary replica#Azure Migrate#minimal downtime migration