You have an on-premises SQL Server instance named SQL1 that hosts 50 databases and plan to migrate it to an Azure SQL Managed Instance using an offline migration. The solution must minimize administrative effort. Which service or tool should you include in the migration plan?
Choose an answer
Tap an option to check your answer.
Correct answer: Azure Database Migration Service.
Why this is the answer
Azure Database Migration Service (DMS) is the correct choice because it supports large-scale, offline migrations of SQL Server to Azure SQL Managed Instance with minimal administrative effort. DMS orchestrates the entire migration workflow, including schema and data transfer, and handles cutover. Azure Migrate is a discovery and assessment tool, not a migration tool for databases. SQL Server Migration Assistant (SSMA) is a client-side tool primarily for schema conversion and data migration to various Azure SQL targets, but it requires more manual effort for large-scale offline migrations compared to DMS. Data Migration Assistant (DMA) assesses SQL Server instances for compatibility and identifies breaking changes but does not perform the migration itself.
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