You are migrating a legacy on-premises SQL Server application to Azure. The application relies heavily on SQL Server Agent jobs, cross-database queries, and CLR (Common Language Runtime) integration. The business requires a fully managed PaaS service to reduce OS maintenance overhead. Which service should you recommend?

Answer options:

Azure SQL Database.

Azure SQL Managed Instance.

SQL Server on Azure Virtual Machines.

Azure Synapse Analytics.

How to approach this question

Match the legacy SQL features (Agent, CLR) with the appropriate PaaS offering.

Full Answer

B.Azure SQL Managed Instance.✓ Correct

Azure SQL Managed Instance.

Azure SQL Managed Instance is the PaaS deployment option that provides the broadest SQL Server database engine compatibility, supporting features like SQL Server Agent, Service Broker, and CLR.

Common mistakes

Choosing SQL on VM (IaaS) when the prompt explicitly requests a PaaS solution.

Question 16 All questions Question 18

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 →