You will migrate databases from SQL Server 2014 on Windows Server 2012 R2 (largest database 3 TB, none exceeding 4 TB) to Azure. Requirements: minimize management overhead, support Azure AD authentication, and minimize database changes. Which service should you recommend to host the databases?
Choose an answer
Tap an option to check your answer.
Correct answer: Azure SQL Managed Instance.
Why this is the answer
Azure SQL Managed Instance is the best choice because it offers near 100% compatibility with SQL Server 2014, minimizing database changes. It supports Azure AD authentication and significantly reduces management overhead compared to IaaS solutions. Its instance-scoped features are crucial for a seamless migration from an on-premises SQL Server. Azure SQL Database elastic pools and single databases are PaaS offerings that reduce management overhead and support Azure AD authentication, but they have some compatibility differences with on-premises SQL Server that might require more database changes. SQL Server 2016 on Azure virtual machines is an IaaS solution that offers full compatibility but requires significant management overhead for patching, backups, and high availability, which violates the requirement to minimize management overhead.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed