Question

your organization plans to migrate its on - premises sql server database to azure. you need to recommend a paas solution that gives developers greater control over the underlying database virtual server. which azure resource should you recommend?
a azure sql database
b azure synapse
c azure sql database managed instance
d azure virtual machine

Explanation:

Azure SQL Database Managed Instance is a PaaS (Platform - as - a - Service) offering. It provides a high - level of compatibility with on - premises SQL Server. It gives developers more control over aspects like instance - level features (such as SQL Server Agent, Service Broker etc.) compared to Azure SQL Database (which is more focused on database - level isolation and simplicity). Azure Synapse is more for analytics. Azure Virtual Machine is an IaaS (Infrastructure - as - a - Service) not a PaaS.

Answer:

C. Azure SQL Database Managed Instance