Examkin

Soru

Zorluk: OrtaRelational 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 InstanceCevap
  2. B
    Azure SQL Database single database
  3. C
    SQL Server on Azure Virtual Machines
  4. D
    Azure SQL Database elastic pool

Cevap

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.

Adım Adım Çözüm

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.

Anahtar Kavram

Selecting the appropriate Azure SQL relational database service tier based on legacy feature compatibility and operational overhead requirements.
Tahmini Süre:1m 30s
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru