Examkin

Question

Difficulty: EasyRelational Data Storage Solutions

A company plans to migrate an on-premises SQL Server database to Azure. The database requires the use of SQL Server Agent to run scheduled maintenance jobs, and cross-database queries are heavily utilized. The database administration team wants to minimize administrative overhead for managing the underlying operating system. Which Azure SQL deployment option should you recommend?

  1. Azure SQL Managed InstanceAnswer
  2. B
    Azure SQL Database single database
  3. C
    SQL Server on Azure Virtual Machines
  4. D
    Azure SQL Database elastic pool

Answer

Azure SQL Managed Instance
Azure SQL Managed Instance is a fully managed Platform-as-a-Service (PaaS) relational database engine that provides near 100% compatibility with on-premises SQL Server. It supports instance-level capabilities such as SQL Server Agent, cross-database queries, and Common Language Runtime (CLR), while eliminating the administrative overhead of managing the underlying operating system and hardware.

Step-by-Step Solution

1
Identify the legacy SQL Server features required by the workload.
The workload requires SQL Server Agent and cross-database queries.
These features are standard SQL Server features but are not supported by all Azure SQL deployment tiers.
2
Identify the administrative overhead requirements.
The customer wants to minimize administrative overhead for the operating system.
This rules out Infrastructure-as-a-Service (IaaS) options like SQL Server on Azure VMs, which require OS patching and management.
3
Evaluate Platform-as-a-Service (PaaS) options against the feature requirements.
Azure SQL Managed Instance supports both SQL Server Agent and cross-database queries, while Azure SQL Database (single database and elastic pools) does not support them natively.
This leaves Azure SQL Managed Instance as the only deployment option that satisfies both the legacy features and the managed OS requirements.

Key Concept

Selecting the appropriate Azure SQL deployment option based on SQL Server feature compatibility and management requirements.
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic