Examkin

Soru

Zorluk: Çok zorRelational Data Storage Solutions

An enterprise is planning to migrate a mission-critical on-premises SQL Server database to Azure. The database has the following requirements:

* Must support legacy features including SQL Server Agent jobs, cross-database queries, and Common Language Runtime (CLR) integration.
* Must support read scale-out to offload reporting workloads to a read-only replica in the primary region.
* Must support automated cross-region failover to a secondary Azure region.
* Must minimize administrative effort for operating system and database engine updates.

Which two components should you include in the recommendation?

  1. Azure SQL Managed Instance in the Business Critical service tierCevap
  2. An auto-failover groupCevap
  3. C
    Azure SQL Database single database in the Hyperscale service tier
  4. D
    SQL Server on Azure Virtual Machines configured in an Always On availability group
  5. E
    Locally Redundant Storage (LRS) for database backups

Cevap

Azure SQL Managed Instance in the Business Critical service tier and an auto-failover group
To support legacy features like SQL Server Agent, CLR, and cross-database queries while minimizing administrative overhead, Azure SQL Managed Instance is the correct deployment choice. Specifically, the Business Critical service tier is required to support read scale-out for offloading reporting workloads. To achieve automated cross-region failover, an auto-failover group must be configured.

Adım Adım Çözüm

1
Identify the relational database features required by the legacy workload: SQL Server Agent jobs, cross-database queries, and CLR integration.
Azure SQL Database (single database/elastic pool) is ruled out because it does not natively support SQL Server Agent, cross-database queries, or CLR. Only Azure SQL Managed Instance and SQL Server on Azure VMs support these features.
Managed Instance provides near 100% compatibility with the on-premises SQL Server database engine.
2
Analyze the administrative effort constraint: minimize operating system and database engine updates.
SQL Server on Azure VMs is ruled out because it requires manual or semi-automated management of the underlying OS and SQL Server patching.
Azure SQL Managed Instance is a fully managed Platform as a Service (PaaS) that handles OS and database patching automatically.
3
Evaluate the read scale-out and regional disaster recovery requirements: read scale-out in the primary region, and automated cross-region failover.
Select Azure SQL Managed Instance in the Business Critical tier (which includes a free, built-in read-only replica for read scale-out) and configure an auto-failover group to enable automated replication and failover to a secondary region.
General Purpose tier does not support read scale-out, whereas Business Critical does. Auto-failover groups provide the required regional failover capabilities.

Anahtar Kavram

Selecting the appropriate Azure SQL relational database deployment option based on legacy feature compatibility, administrative overhead, and high availability/disaster recovery requirements.
Tahmini Süre:3m 0s
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru