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 s

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