Exam AZ-305 topic 2 question 1 discussion

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

B is correct

Today's exam question

B is correct

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.

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.

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