Examkin

Question

Difficulty: EasyDesign Relational Database HA and DR

You are designing a disaster recovery solution for an application that uses an Azure SQL Database. The solution must support automatic failover to a secondary Azure region in the event of a primary region outage. The application must be able to reconnect to the database after failover without any changes to its connection string. Which solution should you recommend?

  1. A
    Azure SQL Database Active Geo-replication
  2. B
    Azure SQL Database configured with Locally Redundant Storage (LRS)
  3. Azure SQL Database Failover GroupsAnswer
  4. D
    SQL Server on Azure Virtual Machines using Standard HDD storage for transaction logs

Answer

Azure SQL Database Failover Groups
The correct option is Azure SQL Database Failover Groups because they enable automatic failover of a group of databases to a secondary region and provide a listener endpoint. This allows the application to connect using the same connection string regardless of which region is hosting the primary database.

Step-by-Step Solution

1
Analyze the automatic failover requirement.
The database must support automatic failover to a secondary region during a regional outage.
This rules out solutions requiring manual failover or those limited to a single region.
2
Analyze the connection string requirement.
The application must connect using a single, unchanging connection string.
This requires a listener endpoint that redirects traffic automatically, which is a feature of failover groups.

Key Concept

Azure SQL Database Failover Groups provide a read-write listener endpoint that remains constant, automatically routing application traffic to the active primary database in the event of a failover to the secondary region.
Estimated Time:1m 0s
Rate this question

Topics

Design Relational Database HA and DR

More questions from this topic