You need to migrate a 2 TB on-premises SQL Server 2016 OLTP database to Azure SQL Database with near-zero downtime. You will provision Azure Database Migration Service (DMS) in Azure. Which two prerequisites must you meet to use an online migration with DMS?
Choose an answer
Tap an option to check your answer.
Correct answer: Enable Change Data Capture (CDC) on the source database (and tables as required)., Provision DMS in an Azure virtual network that has network connectivity to both the source SQL Server and the target Azure SQL Database..
Why this is the answer
Online migrations with Azure Database Migration Service (DMS) for SQL Server to Azure SQL Database require Change Data Capture (CDC) to track changes on the source database during the initial data load. This ensures that all transactions are captured and applied to the target, enabling near-zero downtime. Additionally, DMS needs network connectivity to both the on-premises source SQL Server and the target Azure SQL Database. This is typically achieved by provisioning DMS within an Azure virtual network that can reach both endpoints, often through VPN or ExpressRoute for the on-premises connection. Setting the recovery model to SIMPLE is incorrect; Full recovery model is usually required for CDC and transactional replication. Uploading full backups to Azure Blob Storage is part of offline migration or initial seeding, not the continuous synchronization aspect of online migration. App Service Migration Assistant is for web apps, not SQL Server databases.
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