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 characte...
Microsoft AZ-305 Exam
Questions Number: 68 out of 268 Questions
25.37%
Question 68
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?
SQL Managed Instance allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes. At the same time, SQL Managed Instance preserves all PaaS capabilities (automatic patching and version updates, automated backups, high availability) that drastically reduce management overhead and TCO. Reference: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance
