Examkin

Question

Difficulty: MediumDesign Relational Database HA and DR

An online gaming company runs its matchmaking database on a single database in Azure SQL Database. You are designing a disaster recovery and high availability solution that replicates database updates to a secondary Azure region. The solution must support automatic failover to the secondary region if the primary region experiences a prolonged outage, without requiring connection string updates in the gaming clients. Additionally, the secondary replica must handle read-heavy analytics queries to offload the primary database. Which database configuration should you recommend?

  1. A
    Configure active geo-replication for the matchmaking database, and configure the analytics clients to connect directly to the secondary server endpoint.
  2. B
    Deploy the matchmaking database in a zone-redundant Elastic Pool, and configure active geo-replication to replicate to the secondary region.
  3. Configure a failover group containing the matchmaking database, and configure the analytics clients to connect using the read-only listener endpoint.Answer
  4. D
    Configure active geo-replication and set up an Azure Traffic Manager profile to route database connection traffic to the primary or secondary database endpoints.

Answer

Configure a failover group containing the matchmaking database, and configure the analytics clients to connect using the read-only listener endpoint.
Configuring a failover group meets all requirements. Failover groups provide automatic failover capabilities with predefined grace periods and expose two DNS listener endpoints: a read-write listener and a read-only listener. The read-only listener automatically routes traffic (such as analytics queries) to the secondary database replica, and client connection strings do not need to be updated during or after a failover.

Step-by-Step Solution

1
Analyze the requirements for automatic cross-region failover and the need to preserve client connection strings.
Identify that a feature offering transparent endpoint redirection during failover is required.
This rules out basic active geo-replication, which requires manual failover and changes to client connection strings or custom DNS management.
2
Evaluate how to route the read-heavy analytics queries to the secondary region.
Identify that the solution must provide a read-only endpoint that points to the secondary replica.
Failover groups provide a read-only listener endpoint specifically designed to route read-only workloads to the secondary database replica.
3
Select the Azure SQL Database configuration that satisfies both automatic failover and read-only listener requirements.
Choose a failover group configured with an automatic failover policy.
Failover groups combine automatic failover capabilities with read-write and read-only listener endpoints to meet all constraints.

Key Concept

Azure SQL Database failover groups provide automatic cross-region failover and read-only listener endpoints that simplify client connection management.
Estimated Time:1m 30s
Rate this question

Topics

Design Relational Database HA and DR

More questions from this topic