Examkin

Soru

Zorluk: ZorDesign Relational Database HA and DR

A healthcare company is designing a disaster recovery and high availability solution for a multi-tenant SaaS application. The application's data tier consists of 5050 databases hosted in Azure SQL Database. The databases are grouped into an elastic pool in the East US region.

The solution must meet the following requirements:
- Deliver a Recovery Time Objective (RTO) of 11 hour.
- Deliver a Recovery Point Objective (RPO) of 1010 seconds.
- Automatically route read-write application traffic to the secondary region during a regional outage.
- Route read-only reporting traffic to the secondary region without requiring modifications to the application connection strings.
- Minimize the administrative effort required to configure database replication and connection management.

Which two actions should you include in the design?

  1. Configure an auto-failover group that includes the elastic pool, and route the application traffic using the read-write and read-only listener endpoints.Cevap
  2. Configure the auto-failover group's read-write grace period to control the automatic failover behavior during an outage.Cevap
  3. C
    Configure active geo-replication individually for each database in the elastic pool and update the application connection strings to point to the secondary database endpoints during a failover.
  4. D
    Configure the secondary databases to use locally redundant storage (LRS) for backups to optimize costs.

Cevap

Configure an auto-failover group that includes the elastic pool, routing application traffic via read-write and read-only listener endpoints, and configure the read-write grace period to control automatic failover.
The configuration utilizing an auto-failover group containing the elastic pool correctly enables the replication of all databases as a single administrative unit. It provides two distinct listener endpoints (read-write and read-only) that automatically route traffic to the appropriate primary or secondary databases without connection string changes. Setting the automatic failover policy with a grace period is correct because it controls the automated failover sequence to secondary resources within the required RTO boundary.

Adım Adım Çözüm

1
Analyze the high availability and connection requirements.
Identify that automatic failover, dedicated read-write and read-only routing, and low connection string administration are required for the 5050 databases.
This helps narrow down the database replication technology suitable for grouped databases and automatic endpoint management.
2
Evaluate replication technologies: active geo-replication versus auto-failover groups.
Select auto-failover groups because they support grouping an entire elastic pool, provide built-in listeners for automatic routing, and support automatic failover.
Active geo-replication requires manual failover and application-side connection updates, which violates the requirement of minimizing administrative effort and routing traffic automatically.
3
Configure the failover policy and parameters.
Define an automatic failover policy with an appropriate grace period matching the RTO constraints.
The grace period controls when the automatic failover of the listener endpoints is triggered, preventing premature failovers during transient outages while satisfying the RTO.

Anahtar Kavram

Azure SQL Database Auto-Failover Groups provide grouped database replication, automatic failover capabilities, and listener endpoints to automatically route read-write and read-only traffic during regional outages.
Tahmini Süre:2m 0s
Bu soruyu puanla

Konular

Design Relational Database HA and DR

Bu konudan daha fazla soru