Exam AZ-305 topic 2 question 1 discussion

CLR is supported on SQL Managed instance and not on Azure SQL Database.

This question is on today's exam. I passed the exam today 17-09-2023 with a score of 906/1000. The exam is easier than AZ-104.

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.

Today's exam question

This question was in the exam August 2024 and I answered with this same answer. I scored 870

Explanation: Azure SQL Managed Instance: Minimized Management Overhead: It is a fully managed PaaS service that reduces management tasks compared to running SQL Server on VMs. Azure AD Authentication: Supports Azure AD integration, allowing users to authenticate using Azure AD credentials. Compatibility: It offers high compatibility with SQL Server, minimizing the need for changes during migration, especially for databases using CLR stored procedures.

Given answer is correct Keyword is CLR as SQL MI one that supports it

Some high-level guidelines might be: -Use Elastic pools if you need to group a large number of single database that don't need all instance Transact-SQL functionalities that exist in SQL Server. -Use Managed Instance if you want to migrate a large number of SQL Server database that heavily use instance level features such as CLR, Service Broker, SQL Agent, etc.

Correct Answer - B: Azure SQL Managed Instance Given the requirements and the need for a seamless migration with reduced management overhead, Azure SQL Managed Instance is the most appropriate choice. Reduced Management Overhead - As a fully managed instance in Azure, it offloads many of the administrative tasks, such as backups, patching, and scaling. Azure AD Authentication - Natively supports Azure Active Directory (Azure AD) credentials, providing integrated and secure authentication. Minimal Database Changes - Offers broad compatibility with SQL Server features, ensuring a smooth transition from on-premises SQL Server 2014 environments. CLR Support - Supports Common Language Runtime (CLR) procedures, which is essential given that your stored procedures use CLR. Database Size - Capable of handling databases of significant size, ensuring it can accommodate databases that approach or exceed 3 TB.

B. Azure SQL Managed Instance Azure SQL Managed Instance is a fully managed SQL Server instance hosted in Azure that supports most of the SQL Server features. It provides easier migration from on-premises SQL Server with minimal database changes, while also minimizing management overhead. Here's how Azure SQL Managed Instance meets your requirements: Minimizes management overhead: As a fully managed service, Azure SQL Managed Instance handles many administrative tasks like automatic backups, patching, and monitoring. Azure AD authentication: Azure SQL Managed Instance supports Azure Active Directory (Azure AD) authentication, which allows users to authenticate using their Azure AD credentials. Minimizes database changes: Since Azure SQL Managed Instance is highly compatible with SQL Server, migrating to it requires minimal changes to the databases. It supports features like CLR, which are not available in Azure SQL Database.

B is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql#features-of-sql-database-and-sql-managed-instance Azure SQL Managed Instance Common language runtime - CLR - Yes, but without access to file system in CREATE ASSEMBLY statement

B is correct

B. Azure SQL Managed Instance

B. Azure SQL Managed Instance

B was my first guess.

Exam Question 12/28/2022

why not D, https://learn.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview?view=azuresql#comparison-table support all feature, up to 256 TB, full control, easiest migration ,requirement only mentioned an easy way to migrate, not maintenance, not high availability,