Examkin

Question

Difficulty: MediumAzure Database Services (Relational, Non-Relational, and Cosmos DB)

A company plans to migrate its on-premises Microsoft SQL Server database to Microsoft Azure. The database uses instance-level features, including SQL Server Agent jobs and Linked Servers. The IT department wants to migrate to a fully managed Platform as a Service (PaaS) database service to eliminate operating system patching and VM management. Which Azure service should they select?

  1. A
    Azure SQL Database
  2. B
    SQL Server on Azure Virtual Machines
  3. Azure SQL Managed InstanceAnswer
  4. D
    Azure Cosmos DB

Answer

Azure SQL Managed Instance
Azure SQL Managed Instance is the correct choice because it is a Platform as a Service (PaaS) database service that provides near 100% compatibility with SQL Server enterprise features, including instance-scoped features like SQL Server Agent and Linked Servers, while removing the administrative overhead of managing the underlying virtual machine and operating system.

Step-by-Step Solution

1
Identify the migration source and features required.
The source is an on-premises Microsoft SQL Server database requiring instance-level features like SQL Server Agent jobs and Linked Servers.
This establishes compatibility requirements for the target database service.
2
Identify the management model requested.
The company wants a fully managed Platform as a Service (PaaS) option to eliminate VM management and OS patching.
This rules out Infrastructure as a Service (IaaS) options like SQL Server on Azure Virtual Machines.
3
Select the service that satisfies both the relational/instance-level compatibility and the PaaS requirements.
Azure SQL Managed Instance provides the required SQL Server instance-level features in a fully managed PaaS offering, whereas Azure SQL Database lacks support for these instance-scoped features.
This identifies the correct service that matches all constraints.

Key Concept

Azure SQL Managed Instance vs Azure SQL Database vs SQL Server on Azure VMs
Rate this question

Topics

Azure Database Services (Relational, Non-Relational, and Cosmos DB)

More questions from this topic