Your company is migrating a critical on-premises database to Azure SQL Managed Instance. The database is 500 GB and requires minimal downtime during migration. You need to choose the best migration approach. What should you recommend?
Azure Database Migration Service with online migration is the correct choice because it performs an initial full copy of the schema and data, then uses a continuous replication stream to keep the target synchronized with the source as transactions occur. It supports a controlled cutover where you can validate the target, stop writes on the source, and switch applications with near-zero downtime. DMS automates the heavy lifting, handles large databases like 500 GB, and is designed specifically for minimal-downtime migrations to Azure SQL, eliminating the need for manual log shipping or custom replication code.
Why this answer
Azure Database Migration Service (DMS) with online migration is the correct choice because it supports minimal downtime by continuously replicating changes from the source SQL Server to Azure SQL Managed Instance using a log-based change capture mechanism. This allows you to cut over to the target with only a brief pause, meeting the critical requirement for a 500 GB database.
Exam trap
The trap here is that candidates often confuse transactional replication (Option C) with a managed migration service, but DMS is the purpose-built Azure tool for online migrations with minimal downtime, whereas replication requires more manual configuration and is not optimized for one-time migrations.
How to eliminate wrong answers
Option A is wrong because the export/import bacpac method is an offline process that exports the database schema and data to a .bacpac file, which requires the database to be quiesced or taken offline, causing significant downtime for a 500 GB database. Option B is wrong because Azure Data Factory is designed for bulk data movement and orchestration, not for live transactional replication with minimal downtime; it would require a full copy and cannot handle ongoing changes without complex custom logic. Option C is wrong because transactional replication requires manual setup of publishers, distributors, and subscribers, and while it can provide near-real-time synchronization, it is not a managed migration service and does not handle the full schema and data migration as seamlessly as DMS, often requiring additional steps to ensure consistency.