Examkin

Question

Difficulty: MediumRelational Data Storage Solutions

A company is planning to migrate an on-premises inventory application to Azure. The application database tier consists of three databases that frequently execute cross-database queries using three-part names. The databases also rely on SQL Server Agent for scheduled data-cleansing jobs. You need to design a relational data storage solution that supports these database features while minimizing the operational effort required to manage operating system patching and backups.

Which Azure SQL deployment option should you recommend?

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

Answer

Azure SQL Database Managed Instance
The correct answer is Azure SQL Database Managed Instance. It supports near 100% compatibility with the on-premises SQL Server database engine, including native support for SQL Server Agent and cross-database queries. As a Platform as a Service (PaaS) offering, it automatically handles operating system updates, database engine patching, and backups, which satisfies the requirement to minimize administrative overhead.

Step-by-Step Solution

1
Analyze the technical requirements of the on-premises database tier.
Identify the need for SQL Server Agent for scheduled jobs and cross-database query support (three-part names).
Determining compatibility constraints is the first step in mapping workloads to the correct Azure SQL service.
2
Evaluate the management and administrative overhead constraints.
Note that the solution must minimize operational effort for OS patching and backups.
This requirement points toward a Platform as a Service (PaaS) solution rather than an Infrastructure as a Service (IaaS) solution.
3
Match requirements against the capabilities of Azure SQL tiers.
Select Azure SQL Database Managed Instance because it offers near-complete compatibility with SQL Server features like SQL Server Agent and cross-database queries, while operating as a fully managed PaaS database service.
Only the Managed Instance tier satisfies all technical features without requiring the operational overhead of managing virtual machines.

Key Concept

Selecting Azure SQL deployment options based on legacy SQL Server feature requirements and management boundaries.
Estimated Time:1m 30s
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic