Examkin

Question

Difficulty: MediumRelational Data Storage Solutions

A financial services company is designing the deployment of a relational database on Azure to store sensitive transaction logs. The database has the following requirements:
- The database must be deployed directly into a private subnet of an Azure Virtual Network (VNet) with no public IP address or public endpoints allowed.
- The system must run scheduled maintenance and data archival scripts natively using SQL Server Agent.
- The administrative team wants to minimize OS-level management tasks, such as patching and backups.

Which database solution should you recommend?

  1. Azure SQL Managed InstanceAnswer
  2. B
    Azure SQL Database Single Database with a private endpoint
  3. C
    SQL Server on Azure Virtual Machines
  4. D
    Azure SQL Database Elastic Pool with a private endpoint

Answer

Azure SQL Managed Instance
The correct solution is Azure SQL Managed Instance because it satisfies the VNet injection requirement (deploying directly into a private subnet), provides native support for SQL Server Agent to run scheduled scripts, and is a fully managed Platform-as-a-Service (PaaS) that handles operating system updates and automated backups.

Step-by-Step Solution

1
Analyze the management overhead and hosting model requirements.
Identify that the solution must minimize OS-level management tasks, directing the choice toward a Platform-as-a-Service (PaaS) option like Azure SQL Database or Azure SQL Managed Instance rather than SQL Server on Azure VMs.
This narrows down the options to fully managed cloud database offerings.
2
Evaluate database feature requirements for scheduling.
Identify the requirement for native SQL Server Agent to run scheduled scripts.
Azure SQL Database (Single Database and Elastic Pool) does not support native SQL Server Agent, which requires either SQL Server on Azure VMs or Azure SQL Managed Instance.
3
Assess network isolation and configuration requirements.
Determine that Azure SQL Managed Instance supports direct deployment into a private subnet of a Virtual Network (VNet injection) and meets all the operational and feature requirements.
This confirms Azure SQL Managed Instance is the only service that satisfies all network, feature compatibility, and management constraints.

Key Concept

Selecting the appropriate Azure SQL deployment option based on SQL Server feature compatibility (SQL Server Agent), network isolation (VNet injection), and administrative overhead constraints.
Estimated Time:1m 30s
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic