Administering Relational Databases on Microsoft Azure — Question 43

You have an on-premises Microsoft SQL Server 2019 database named SQL1 that uses merge replication.

You need to migrate SQL1 to Azure.

Which service should you use?

Answer options

• A. Azure SQL Edge
• B. Azure SQL Database
• C. SQL Server on Azure Virtual Machines
• D. Azure SQL Managed Instance

Correct answer: C

Explanation

The correct answer is C, SQL Server on Azure Virtual Machines, as it allows for a direct lift-and-shift of SQL Server, preserving the merge replication setup. Other options like Azure SQL Database and Azure SQL Managed Instance do not support all SQL Server features, particularly merge replication, making them unsuitable for this specific migration.