Examkin

Soru

Zorluk: KolayDesign Relational Database HA and DR

An organization is designing a high availability and disaster recovery solution for a web application that uses Azure SQL Database. The solution must support automatic failover to a secondary Azure region, provide a single connection endpoint for the application, and allow read-scale operations in the secondary region. Which two features or capabilities should you recommend to meet these requirements? (Select two.)

  1. Auto-failover groupsCevap
  2. The read-only listener endpoint of the auto-failover groupCevap
  3. C
    Active geo-replication configured for manual failover
  4. D
    Migrating the database to Azure SQL Managed Instance

Cevap

To meet the requirements, you should recommend using auto-failover groups and the read-only listener endpoint of the auto-failover group.
Auto-failover groups allow you to manage the replication and failover of a group of databases on a logical server to another Azure region. They provide automatic failover capabilities and include a single read-write listener endpoint as well as a read-only listener endpoint. Using the read-only listener endpoint allows the application to route read-only workloads to the secondary database without changing connection strings during a failover.

Adım Adım Çözüm

1
Analyze the high availability and disaster recovery requirements of the application.
The requirements specify automatic failover to a secondary region, a single connection endpoint, and read-scale operations.
Understanding the requirements helps filter out options that do not support automatic failover or listener endpoints.
2
Evaluate Azure SQL Database features that support multi-region disaster recovery and automatic failover.
Auto-failover groups support automatic failover and provide write and read-only listener endpoints. Active geo-replication only supports manual failover and does not provide listener endpoints.
This distinguishes between the capabilities of auto-failover groups and active geo-replication to satisfy the single endpoint and automatic failover requirements.
3
Identify the specific features needed to connect the application and leverage the secondary database for read-only workloads.
Use the read-only listener endpoint of the auto-failover group to route read-only traffic to the secondary region.
The read-only listener endpoint satisfies the read-scale requirement while maintaining a single endpoint.

Anahtar Kavram

Designing relational database high availability and disaster recovery in Azure SQL Database using auto-failover groups.
Bu soruyu puanla

Konular

Design Relational Database HA and DR

Bu konudan daha fazla soru