Examkin

Question

Difficulty: MediumRelational Data Storage Solutions

A healthcare provider is designing the database infrastructure for a new reporting application. The database has the following requirements:
- Must run scheduled data aggregation tasks using SQL Server Agent.
- Requires SQL Server Common Language Runtime (CLR) integration.
- The database administration team must not be responsible for operating system patching, updates, or virtual machine management.

Which database service 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 PaaS database engine that provides near 100% compatibility with the latest SQL Server Enterprise Edition. It supports instance-scoped features such as SQL Server Agent and CLR integration, while completely abstracting the underlying operating system and virtual machines. Microsoft automatically handles OS patching, updates, and software backups, satisfying all of the client's design constraints.

Step-by-Step Solution

1
Evaluate the database feature requirements.
SQL Server Agent and SQL Server CLR integration are instance-level features, which narrows the choices down to SQL Server on Azure Virtual Machines and Azure SQL Managed Instance.
Azure SQL Database (both single database and elastic pools) does not support native SQL Server Agent or CLR integration.
2
Evaluate the operational management requirements.
The requirement states that the administration team must not be responsible for OS patching, updates, or VM management. This eliminates SQL Server on Azure Virtual Machines.
SQL Server on Azure Virtual Machines is an Infrastructure-as-a-Service (IaaS) offering where the customer is responsible for maintaining the OS, applying patches, and configuring backups.
3
Select the service that meets all criteria.
Azure SQL Managed Instance is a fully managed Platform-as-a-Service (PaaS) that supports instance-level features like SQL Server Agent and CLR while Microsoft manages the underlying OS, patching, and backups.
This fully satisfies both the feature compatibility and managed service operational constraints.

Key Concept

Selecting the appropriate Azure SQL relational database service tier based on legacy feature compatibility and operational overhead requirements.
Estimated Time:1m 30s
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic