Examkin

Question

Difficulty: EasyDesign Relational Database HA and DR

An organization deploys a critical application that uses a single database on Azure SQL Database. The disaster recovery requirements specify that:

- In the event of a regional outage, the database must fail over to a secondary Azure region automatically.
- The application must reconnect automatically without needing any modifications to its connection strings.

Which Azure SQL Database feature should you recommend to meet these requirements?

  1. Auto-failover groupsAnswer
  2. B
    Active geo-replication
  3. C
    Zone-redundancy
  4. D
    Read-Access Geo-Redundant Storage (RA-GRS)

Answer

Auto-failover groups
The correct answer is Auto-failover groups because they support automatic failover policies for groups of databases to a secondary region and expose a single read-write listener endpoint. This listener automatically routes application traffic to the active primary database, avoiding the need to change connection strings during a failover.

Step-by-Step Solution

1
Analyze the disaster recovery requirements for the Azure SQL Database.
Identify that both cross-region automatic failover and seamless connection redirection are required.
This determines which database high availability and disaster recovery feature is necessary.
2
Evaluate the database features against the connection string requirement.
Auto-failover groups provide a read-write listener endpoint that redirects connections automatically, whereas Active geo-replication requires manual updates to connection strings.
This distinguishes between the two primary cross-region database replication features.
3
Evaluate the database features against the automatic failover requirement.
Auto-failover groups support automatic failover policies managed by Azure, whereas Active geo-replication only supports manual failover.
This confirms that Auto-failover groups meet all constraints.

Key Concept

Azure SQL Database Auto-Failover Groups provide automatic cross-region failover and read-write listeners that prevent the need to update application connection strings during a failover.
Rate this question

Topics

Design Relational Database HA and DR

More questions from this topic