Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Azure Solutions Architect Expert · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Azure SQL Managed Instance, CLR and minimize overhead. CLR isnt supported by elastic pools nor Database single database. The last one SQL on Azure machine,although it is supported CLR it is definitely ruled out minimise the overhead since we need to take care for OS patching and related.
B. Azure SQL Managed Instace for CLR support.
For hosting these SQL Server 2014 databases in Azure while meeting the stated requirements. Azure SQL Managed Instance Minimizes management overhead: Azure SQL Managed Instance offers full SQL Server compatibility, including built-in high availability, automated patching, and backup management. Supports Azure AD authentication: Enables users to authenticate using Azure AD without requiring traditional SQL authentication. Minimizes database changes: Since Azure SQL Managed Instance maintains compatibility with SQL Server features like CLR stored procedures, it requires fewer modifications during migration. Alternative: SQL Server on Azure Virtual Machines If complex SQL Agent jobs, legacy features, or highly customized configurations need to be retained, SQL Server on an Azure VM (IaaS) could be an option. Requires higher management overhead than Managed Instance but provides full SQL Server feature parity.