You need to migrate an on-premises SQL Server 2016 instance with multiple databases to Azure with minimal code changes. The solution must support SQL Agent jobs, cross-database queries, and CLR. The databases must be accessible only over private networking via existing ExpressRoute and the cutover must incur minimal downtime. Which two actions should you take?
Choose an answer
Tap an option to check your answer.
Correct answer: Deploy Azure SQL Managed Instance into a dedicated subnet of an Azure virtual network and connect from on-premises via ExpressRoute or site-to-site VPN, Use Azure Database Migration Service in online mode to replicate and cut over with minimal downtime.
Why this is the answer
Azure SQL Managed Instance is the best choice because it offers near 100% compatibility with SQL Server 2016, supporting SQL Agent jobs, cross-database queries, and CLR, while providing private network access within a VNet. Azure Database Migration Service (DMS) in online mode facilitates minimal downtime by continuously replicating data and allowing a seamless cutover. Azure SQL Database Hyperscale doesn't fully support SQL Agent jobs or cross-database queries. Exporting to BACPAC is an offline migration method, causing significant downtime. Hosting SQL on an Azure VM would require managing the OS and SQL Server, and exposing a public endpoint violates the private networking requirement.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed