AZ-305 ยท Migration design
Migrating databases to Azure
Azure Database Migration Service online vs offline, target choice (SQL Database, Managed Instance, SQL on VM), Managed Instance link, migrating PostgreSQL/MySQL.
Key points
- Targets: SQL Database (most managed), Managed Instance (instance features), SQL Server on VMs (rehost).
- Offline: app stops; online: initial copy, continuous sync, short cutover.
- DMS: SQL Database offline only; Managed Instance, VMs online or offline.
- Managed Instance link: distributed availability groups, SQL Server 2016+, minimal downtime; DR failback with 2022/2025.
- PostgreSQL: migration service, offline or online.
Source: https://learn.microsoft.com/en-us/azure/dms/dms-overview
Practice questions
Which SQL Server migration target does Azure Database Migration Service support only in offline mode?
- Azure SQL Managed Instance
- SQL Server on Azure Virtual Machines
- Azure SQL Database
- SQL Managed Instance Business Critical
Show answer
Answer: C. Azure SQL Database
DMS migrates to Azure SQL Database offline, while SQL Managed Instance and SQL Server on Azure VMs support both online and offline migrations.
Which statements correctly describe an online database migration compared with an offline one?
- Applications keep using the source while data is copied
- An initial copy is followed by ongoing replication until cutover
- It is more complex and has a higher chance of failure
- It removes the need for any cutover moment
- Offline migration cannot handle large databases
Show answer
Answer: A. Applications keep using the source while data is copied, B. An initial copy is followed by ongoing replication until cutover, C. It is more complex and has a higher chance of failure
Online migration keeps applications running: an initial copy is followed by continuous replication, then a short cutover. It is more complex and has more ways to fail than offline. It still needs a brief cutover, and offline migrations have no inherent size limit; they simply need a downtime window.
The Managed Instance link replicates SQL Server logins and SQL Agent jobs to the managed instance along with the user database.
Show answer
Answer: False
False. The link replicates user databases only; server-level objects, agent jobs and logins are not replicated and must be moved separately before cutover.
Practice 8 questions on this topic in Bitzu
Short lessons, instant explanations and spaced review of what you get wrong. Free on iOS and Android.
