You must migrate a 50-GB on-premises SQL Server 2008 database to an Azure SQL managed instance with minimal downtime. Which tool should you use?
Choose an answer
Tap an option to check your answer.
Correct answer: Azure Data Studio.
Why this is the answer
Azure Data Studio, with its SQL Migration extension, is the recommended tool for migrating SQL Server databases to Azure SQL Managed Instance with minimal downtime. It supports online migrations, allowing the source database to remain operational during most of the migration process. Azure Migrate is primarily for assessing and migrating virtual machines and servers, not specifically for database online migrations. WANdisco LiveData Platform for Azure is for large-scale data replication and synchronization, often for big data scenarios, not direct SQL database migration. SQL Server Management Studio (SSMS) is a database administration tool and can be used for backup/restore or import/export, but it doesn't offer the integrated online migration capabilities of Azure Data Studio's extension.
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