Examkin

Soru

Zorluk: KolayDesign 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 GroupsCevap
  4. D
    SQL Server on Azure Virtual Machines using Standard HDD storage for transaction logs

Cevap

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.

Adım Adım Çözüm

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.

Anahtar Kavram

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.
Tahmini Süre:1m 0s
Bu soruyu puanla

Konular

Design Relational Database HA and DR

Bu konudan daha fazla soru