Examkin

Question

Difficulty: EasyDesign Relational Database HA and DR

A retail company is planning the high availability and disaster recovery strategy for its new customer feedback system. The system's relational database will be hosted on Azure SQL Database. The operations team has specified that if the primary region experiences an outage, database failover to the secondary region must happen automatically. Additionally, the application must connect using a read-write listener that automatically routes traffic to the active primary region without updating connection strings. Which feature should be implemented to satisfy these requirements?

  1. Auto-failover groupsAnswer
  2. B
    Active geo-replication
  3. C
    Azure SQL Database single database with SQL Server Agent replication
  4. D
    SQL Server on Azure Virtual Machines with Standard HDD storage for transaction logs

Answer

Auto-failover groups
The correct option is Auto-failover groups. This feature provides a group of databases managed collectively that can failover automatically to another Azure region. It also provides read-write and read-only listener endpoints that remain unchanged during failover, allowing the application to connect seamlessly.

Step-by-Step Solution

1
Analyze the requirements for high availability and disaster recovery.
The solution requires automatic database failover to a secondary region and a single connection endpoint that remains constant during failover.
This eliminates options that require manual intervention or manual redirection of the application connection string.
2
Evaluate the capabilities of Azure SQL Database features.
Auto-failover groups offer both automatic failover capabilities and read-write/read-only listener endpoints that route traffic to the active database server.
Active geo-replication is designed for manual failover and does not support listener endpoints directly.

Key Concept

Azure SQL Database Auto-failover groups provide automated cross-region database recovery and listener endpoints.
Rate this question

Topics

Design Relational Database HA and DR

More questions from this topic