You are migrating a 5 TB on-premises SQL Server database to Azure SQL Managed Instance. The application requires 24/7 availability, and the business has mandated that the migration cutover downtime must be less than 15 minutes. Which migration strategy should you use?

Answer options:

Offline migration using Azure Database Migration Service (DMS).

Online migration using Azure Database Migration Service (DMS).

Backup to URL and restore.

Azure Data Box.

How to approach this question

Choose the migration method that supports continuous replication for near-zero downtime.

Full Answer

B.Online migration using Azure Database Migration Service (DMS).✓ Correct

Online migration using Azure Database Migration Service (DMS).

An online migration using Azure DMS continuously replicates data from the source to the target. This allows the final cutover to happen very quickly (usually minutes), meeting strict downtime requirements.

Common mistakes

Choosing offline migration, which is simpler but incurs massive downtime for large databases.

Question 47 All questions Question 49

Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 6

55 questions · hints · full answers · grading

More questions from this exam

Q01Contoso Ltd is a global manufacturing company with 50,000 employees. They operate a mix of on-pre...Medium Q02A financial institution has 500 Windows Server VMs on-premises and 200 VMs in Azure. They need to...Hard Q03An enterprise uses Azure Sentinel and Log Analytics. They ingest 500 GB of logs daily. The IT bud...Hard Q04You are designing a monitoring strategy for a new Azure deployment consisting of App Service, Azu...Easy Q05A healthcare company uses Microsoft Entra ID (Azure AD). They need to implement a security policy...Medium

View all 55 questions →