Examkin

Soru

Zorluk: OrtaRelational Data Storage Solutions

A logistics company is designing the migration of an on-premises tracking application to Azure. The application database requires Common Language Runtime (CLR) integration, SQL Server Agent for scheduling internal tasks, and cross-database queries using three-part naming conventions. Additionally, the solution must survive the outage of a primary datacenter and minimize the administrative overhead of managing operating system updates and database backups. Which Azure SQL deployment option should you recommend?

  1. Azure SQL Managed InstanceCevap
  2. B
    Azure SQL Database single database
  3. C
    SQL Server on Azure Virtual Machines using Standard HDD storage for database transaction logs
  4. D
    Azure SQL Database elastic pool configured with Locally Redundant Storage (LRS)

Cevap

Azure SQL Managed Instance
Azure SQL Managed Instance is the correct choice because it is a fully managed service that minimizes administrative overhead (such as patching and backups) while providing near-100% compatibility with on-premises SQL Server instance features. It supports instance-level features like CLR integration, SQL Server Agent, and native cross-database queries using three-part names, and it can be configured with geo-redundant storage to survive a primary datacenter outage.

Adım Adım Çözüm

1
Analyze the application capability requirements.
The application requires Common Language Runtime (CLR), SQL Server Agent, and cross-database queries using three-part naming.
These are instance-scoped features typical of on-premises SQL Server instances and require either Azure SQL Managed Instance or SQL Server on Azure VMs.
2
Evaluate the administrative overhead constraint.
The requirement to minimize the management of operating system updates and database backups rules out SQL Server on Azure Virtual Machines, as VMs require manual OS/DBMS patching and backup configuration.
Azure SQL Managed Instance is a fully managed Platform-as-a-Service (PaaS) that handles OS patching and automated backups.
3
Evaluate the resiliency and storage requirements.
The solution must survive a primary datacenter outage, requiring geo-redundant storage (GRS) or zone-redundant storage (ZRS) depending on regional availability, ruling out Locally Redundant Storage (LRS). Also, transaction logs require high-performance disks (Premium SSD or Ultra Disk), ruling out Standard HDD configurations.
Locally Redundant Storage only replicates data within a single physical facility, making it vulnerable to a datacenter outage.

Anahtar Kavram

Selecting the appropriate Azure SQL deployment option based on compatibility, administrative overhead, and resiliency requirements.
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru