Examkin

Question

Difficulty: MediumRelational Data Storage Solutions

A healthcare provider plans to host a new medical record system in Azure. The database layer consists of three databases that must perform cross-database transactions using the three-part naming convention. The system requires SQL Server Agent for scheduling maintenance tasks. To comply with regulatory standards, the database environment must be isolated within a private subnet, and the provider wants to minimize the effort required to manage operating system updates and database engine patches.

Which relational database solution should you recommend?

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

Answer

Azure SQL Database Managed Instance
Azure SQL Database Managed Instance is a fully managed relational database service (PaaS) that minimizes the effort required to patch the operating system and SQL Server engine. It natively supports SQL Server Agent, native cross-database queries using three-part names, and is designed to be deployed into a private subnet within an Azure Virtual Network.

Step-by-Step Solution

1
Analyze compatibility and feature requirements.
The solution requires SQL Server Agent and native cross-database transactions. This rules out Azure SQL Database single database and Azure SQL Database elastic pools, as they do not support these features natively.
Identifying mandatory feature requirements narrows down the valid Azure SQL deployment options.
2
Analyze network isolation and management overhead requirements.
The solution must support private subnet deployment (VNet injection) and minimize administrative patching overhead. SQL Server on Azure VMs supports the features but has high patching overhead (IaaS). Azure SQL Database Managed Instance supports VNet injection and is fully managed (PaaS).
Evaluating administrative overhead and network constraints helps distinguish between IaaS (virtual machines) and PaaS (Managed Instance) options.
3
Select the optimal database service.
Azure SQL Database Managed Instance meets all functional, network isolation, and low administrative overhead requirements.
Managed Instance combines the feature compatibility of SQL Server with the fully managed benefits of Azure SQL Database.

Key Concept

Selecting the appropriate Azure SQL relational database deployment option based on feature compatibility, network isolation, and management overhead.
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic