Microsoft Azure Data Fundamentals — Question 229

You have an on-premises Microsoft SQL Server database.
You need to migrate the database to the cloud. The solution must meet the following requirements:
* Minimize maintenance effort.
* Support the Database Mail and Service Broker features.
What should you include in the solution?

Answer options

• A. Azure SQL Database single database
• B. an Azure SQL Database elastic pool
• C. Azure SQL Managed instance
• D. SQL Server on Azure virtual machines

Correct answer: C

Explanation

The correct answer is C, Azure SQL Managed instance, as it offers full SQL Server compatibility and supports the required features while minimizing maintenance. Options A and B do not support the full set of SQL Server features, and option D requires more management overhead due to the virtual machine setup.