Examkin

Soru

Zorluk: KolayDesign Relational Database HA and DR

You are designing a disaster recovery solution for a web application database in Azure. The database is currently deployed as an Azure SQL Database. The disaster recovery design must support automatic failover to a secondary region and allow the application to connect using a single read-write connection string that remains unchanged after a failover event. Which two actions should you include in the design? (Select two.)

  1. Create a failover group that includes the primary database and a secondary database in a paired region.Cevap
  2. Configure the application to connect to the database using the read-write listener endpoint of the failover group.Cevap
  3. C
    Configure active geo-replication without a failover group and update the application connection string to point directly to the secondary server name.
  4. D
    Deploy SQL Server on an Azure Virtual Machine and host the database transaction logs on Standard HDD storage to optimize replication throughput.
  5. E
    Deploy a single Azure SQL Database and configure cross-database queries to automate the failover process.

Cevap

Create a failover group that includes the primary database and a secondary database in a paired region, and configure the application to connect to the database using the read-write listener endpoint of the failover group.
To support automatic failover and maintain a single connection string, the architecture must utilize a failover group. The failover group replicates databases to a secondary region and exposes a read-write listener endpoint. The application connects to this listener, which automatically routes traffic to the active primary region without requiring client updates during a failover.

Adım Adım Çözüm

1
Analyze the business continuity requirements for the Azure SQL Database workload.
Identify that the solution must provide automatic cross-region failover and use an unchanging connection string.
This establishes that manual failover models like standalone active geo-replication will not satisfy the connection string constancy requirement.
2
Design the replication and failover architecture.
Select Azure SQL Database failover groups to group the primary and secondary databases across regions.
Failover groups automate the regional failover process and provide a single read-write listener endpoint.
3
Configure client connectivity to use the listener endpoint.
Point the application's connection string to the failover group's read-write listener.
This ensures client connections are transparently redirected to the new primary server during a failover event.

Anahtar Kavram

Azure SQL Database failover groups manage replication, automatic failover, and client connection routing across regions via listener endpoints.
Bu soruyu puanla

Konular

Design Relational Database HA and DR

Bu konudan daha fazla soru