Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 2 question 1 discussion

Actual exam question from Microsoft's AZ-305

Question #: 1
Topic #: 2

You have 100 servers that run Windows Server 2012 R2 and host Microsoft SQL Server 2014 instances. The instances host databases that have the following characteristics:
✑ Stored procedures are implemented by using CLR.
✑ The largest database is currently 3 TB. None of the databases will ever exceed 4 TB.
You plan to move all the data from SQL Server to Azure.
You need to recommend a service to host the databases. The solution must meet the following requirements:
✑ Whenever possible, minimize management overhead for the migrated databases.
✑ Ensure that users can authenticate by using Azure Active Directory (Azure AD) credentials.
✑ Minimize the number of database changes required to facilitate the migration.
What should you include in the recommendation?

A. Azure SQL Database elastic pools
B. Azure SQL Managed Instance
C. Azure SQL Database single databases
D. SQL Server 2016 on Azure virtual machines

Show Suggested Answer

Suggested Answer: B 🗳️

by Shadow983 at Dec. 14, 2021, 5:14 p.m.

Comments

Submit Cancel

Redimido

Highly Voted 3 years, 4 months ago

Selected Answer: B

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

upvoted 47 times

magichappens

2 years, 10 months ago

But it is also supported for elastic pools and these are probably easier to manage? SQL Manage Instance is a service to reach nearly 100% compatibility with your on-prem machines but that was not required here.

upvoted 3 times

rtony69

2 years, 5 months ago

As far as I know, CLR is not supported in AZ SQL database elastic pools. Do you have a doc reference to prove your statement?

upvoted 6 times

ayadmawla

1 year, 5 months ago

See my comment for reference

upvoted 1 times

...

[Removed]

Highly Voted 3 years, 5 months ago

Selected Answer: B

B is correct

upvoted 12 times

...

Aikendrum

Most Recent 1 month, 1 week ago

Selected Answer: C

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.

upvoted 1 times

...

shaiketisalat

7 months ago

Today's exam question

upvoted 3 times

...

[Removed]

7 months ago

Selected Answer: B

B is correct

upvoted 1 times

...

Len83

10 months, 1 week ago

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

upvoted 2 times

...

23169fd

11 months, 4 weeks ago

Selected Answer: B

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.

upvoted 5 times

23169fd

11 months, 4 weeks ago

Why Not Other Options: A. Azure SQL Database elastic pools: Designed for managing multiple databases with variable and unpredictable usage patterns, but might require significant changes for databases using CLR. C. Azure SQL Database single databases: Like elastic pools, it might require significant changes for databases using CLR and doesn't provide the same level of compatibility as Managed Instance. D. SQL Server 2016 on Azure virtual machines: Increases management overhead since it requires maintaining VMs and SQL Server instances, which is against the goal of minimizing management overhead.

upvoted 5 times

...

Lazylinux

1 year, 1 month ago

Selected Answer: B

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

upvoted 1 times

...

ayadmawla

1 year, 5 months ago

Selected Answer: B

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.

upvoted 3 times

ayadmawla

1 year, 5 months ago

See: https://learn.microsoft.com/en-us/answers/questions/842070/elastic-pool-in-azure-sql-sql-server-managed-insta

upvoted 1 times

...

stonwall12

1 year, 8 months ago

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.

upvoted 8 times

...

memo454

1 year, 9 months ago

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.

upvoted 9 times

...

NotMeAnyWay

2 years, 2 months ago

Selected Answer: B

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.

upvoted 7 times

...

zellck

2 years, 3 months ago

Selected Answer: B

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

upvoted 4 times

...