nerdexam
Microsoft

AZ-305 · Question #26

You have 100 servers that run Windows Server and host Microsoft SQL Server 2014 instances. The instances host databases that have the following characteristics: Stored procedures are implemented by…

The correct answer is B. Azure SQL Managed Instance. 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…

Submitted by weili_xi· Mar 6, 2026Design data storage solutions

Question

You have 100 servers that run Windows Server 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 AD credentials. Minimize the number of database changes required to facilitate the migration. What should you include in the recommendation?

Options

  • AAzure SQL Database elastic pools
  • BAzure SQL Managed Instance
  • CAzure SQL Database single databases
  • DSQL Server 2016 on Azure virtual machines

How the community answered

(19 responses)
  • A
    11% (2)
  • B
    63% (12)
  • C
    21% (4)
  • D
    5% (1)

Explanation

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. https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full AZ-305 Practice