nerdexam
Microsoft

70-473 · Question #55

You need to implement a disaster recovery solution that meets the technical requirements. The solution must NOT require customers to modify their connection strings. Which disaster recovery solution…

The correct answer is A. Transactional Replication to Azure. To implement a disaster recovery solution that keeps connection strings unchanged, Azure SQL Database's failover groups, utilizing a listener endpoint, are an effective choice.

Implement business continuity

Question

You need to implement a disaster recovery solution that meets the technical requirements. The solution must NOT require customers to modify their connection strings. Which disaster recovery solution should you implement?

Options

  • ATransactional Replication to Azure
  • BAlwaysOn Availability groups
  • CTransaction Log Shipping
  • Dfailover cluster instances

How the community answered

(40 responses)
  • A
    80% (32)
  • B
    3% (1)
  • C
    13% (5)
  • D
    5% (2)

Why each option

To implement a disaster recovery solution that keeps connection strings unchanged, Azure SQL Database's failover groups, utilizing a listener endpoint, are an effective choice.

ATransactional Replication to AzureCorrect

Azure SQL Database's active geo-replication and failover groups utilize a read-write listener endpoint that automatically redirects client connections to the new primary database after a failover, ensuring no changes are needed in customer connection strings.

BAlwaysOn Availability groups

AlwaysOn Availability Groups, while providing a listener for connection string abstraction, are an on-premises or IaaS SQL Server feature, whereas the choice specifies "to Azure" and implies an Azure-native DR approach.

CTransaction Log Shipping

Transaction Log Shipping typically requires manual failover and an update to connection strings to point to the new primary server, as it lacks a transparent listener mechanism.

Dfailover cluster instances

Failover Cluster Instances are an on-premises or IaaS SQL Server solution that provides high availability and connection string abstraction via a virtual network name, but this option does not directly involve replication "to Azure" for disaster recovery.

Concept tested: Azure SQL Database Disaster Recovery, connection transparency

Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview

Topics

#disaster recovery#connection strings#Transactional Replication#SQL Server DR

Community Discussion

No community discussion yet for this question.

Full 70-473 Practice