Microsoft Azure Architect Design (AZ-301) Practice Exam

Disable ads (and more) with a membership for a one time $2.99 payment

Prepare for the Microsoft Azure Architect Design (AZ-301) Exam with interactive quizzes featuring flashcards and multiple-choice questions, each packed with hints and explanations to ace your certification test!

Each practice test/flash card set has 50 randomly selected questions from a bank of over 500. You'll get a new set of questions each time!

Practice this question and more.

What is the recommended Azure service for migrating SQL databases that prioritize management overhead and require Active Directory authentication?

Azure SQL Database single databases.
SQL Server 2016 on Azure virtual machines.
Azure SQL Database Managed Instance.
Azure SQL Database elastic pools.

The correct answer is: Azure SQL Database Managed Instance.

The recommended Azure service for migrating SQL databases that emphasizes reduced management overhead and supports Active Directory authentication is Azure SQL Database Managed Instance. This service combines the best features of both Azure SQL Database and on-premises SQL Server, providing a fully managed, scalable, and high-performance database service with compatibility for many SQL Server features. Azure SQL Database Managed Instance offers easier migration options for existing SQL Server databases, as it supports a wide range of SQL Server features, including those that Active Directory authentication can leverage. It requires minimal administrative effort compared to hosting SQL Server on Azure virtual machines because it abstracts the infrastructure management, allowing organizations to focus on their applications. Other services like Azure SQL Database single databases and elastic pools are primarily focused on smaller or more specific architectural scopes and may not fully cater to all the laid-down requirements, including management overhead alleviation for larger, more complex environments. SQL Server 2016 on Azure virtual machines, while providing full control and SQL Server feature support, does not reduce management overhead effectively as it requires you to manage the underlying VMs and OS, which can complicate the overall administration compared to a fully managed instance.