Examkin

Question

Difficulty: HardRelational Data Storage Solutions

A retail corporation plans to migrate an on-premises inventory management system to Microsoft Azure. The database tier has the following requirements:
- The system must run a specialized database monitoring agent directly on the database server's operating system, which requires local administrator privileges.
- The environment must support SQL Server Agent to run scheduled maintenance and data synchronization jobs.
- The administration team must minimize the operational overhead of manually managing operating system updates and SQL Server patches.
- The database storage must support high-performance transactions, with the ability to dynamically scale disk performance up to 80,00080,000 IOPS.

Which Azure SQL deployment option should you recommend?

  1. A
    Azure SQL Database (Single Database)
  2. B
    Azure SQL Database Elastic Pool
  3. SQL Server on Azure Virtual MachinesAnswer
  4. D
    Azure SQL Managed Instance

Answer

SQL Server on Azure Virtual Machines
SQL Server on Azure Virtual Machines is correct because it provides full access to the underlying operating system, allowing the installation of custom monitoring agents with local administrator privileges. Automated patching overhead is minimized through the SQL Server IaaS Agent Extension.

Step-by-Step Solution

1
Identify the core operating system and application requirements.
The requirement for a local OS-level monitoring agent with administrative access rules out fully managed platform services.
Managed services like Azure SQL Database and Azure SQL Managed Instance abstract the underlying operating system and do not allow administrative logins or local agent installations.
2
Verify how the administrative patching overhead requirement can be met.
SQL Server on Azure Virtual Machines supports Automated Patching when registered with the SQL Server IaaS Agent Extension.
This minimizes the operational overhead of manual patching while still providing full OS-level control.
3
Evaluate storage performance capabilities for the chosen solution.
SQL Server on Azure VMs can be configured with Premium SSD v2 or Ultra Disk to support scaling up to 80,00080,000 IOPS.
This satisfies the high-performance transaction scaling requirements.

Key Concept

Selecting SQL Server on Azure VMs when local OS access or third-party agent installation is required, combined with IaaS extension for automated management.
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic