Microsoft
AZ-305 · Question #401
Hotspot Question You have an on-premises server that runs Windows Server 2016 and hosts an instance of Microsoft SQL Server Enterprise named SQL1. You have an Azure subscription that contains a virtua
Sign in or unlock AZ-305 to reveal the answer and full explanation for question #401. The question stem and answer options stay visible for context.
Submitted by dimitri_ru· Mar 6, 2026Design infrastructure solutions
Question
Hotspot Question You have an on-premises server that runs Windows Server 2016 and hosts an instance of Microsoft SQL Server Enterprise named SQL1. You have an Azure subscription that contains a virtual network named VNet1. VNet1 is connected to the on-premises network by using a Site-to-Site (S2S) VPN. You plan to migrate the databases in SQL1 to an Azure SOL managed instance named SQLMI1 that will be deployed to VNet1. The migration is expected to take two weeks. On-premises apps will require access to the databases during the migration. You need to recommend a migration solution for the databases and the endpoint that provides on-premises access to the migrated databases. The solution must meet the following requirements: - Maximize the availability of the databases in SQL1 during the migration. - Provide read access to the databases in SQLMI1 during the migration. What should you include in the recommendation? To answer, select the appropriate options in the answer area. Answer:
Exhibit
Answer Area
- Migrate by using:Log Replay Service (LRS)Managed instance linkSQL Data Sync
- Provide on-premises access by using:A private endpointA public endpointA VNet-local endpoint
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 Managed Instance migration#Log Replay Service#online migration#public endpoint
