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…

The correct answer is C. Azure SQL Managed instance. Azure SQL Database does not support service broker and mail. You need the Managed Instance. https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql

Submitted by parkjh· Mar 30, 2026Identify considerations for relational data on Azure

Question

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?

Options

AAzure SQL Database single database
Ban Azure SQL Database elastic pool
CAzure SQL Managed instance
DSQL Server on Azure virtual machines

How the community answered

(30 responses)

A
3% (1)
B
3% (1)
C
83% (25)
D
10% (3)

Explanation

Azure SQL Database does not support service broker and mail. You need the Managed Instance. https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql

Topics

#Azure SQL Managed Instance#migration#Database Mail#Service Broker

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice