nerdexam
Microsoft

70-473 · Question #91

You need to deploy a new Microsoft Azure SQL database that must meet the following requirements: Will be available it a single Azure region becomes unavailable Will be able to fail over to another…

The correct answer is A. Add the database to a failover group. D. Add the database to an AlwaysOn availability group that uses synchronous replication. To enable cross-region automatic failover for an Azure SQL database, you must configure a failover group, and the database should be provisioned to leverage high availability mechanisms for data durability.

Implement business continuity

Question

You need to deploy a new Microsoft Azure SQL database that must meet the following requirements: * Will be available it a single Azure region becomes unavailable * Will be able to fail over to another Azure region automatically Which two configuration tasks should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options

  • AAdd the database to a failover group.
  • BAdd the database to a database pool.
  • CConfigure the database connection string to point to the endpoint of the read-write listener.
  • DAdd the database to an AlwaysOn availability group that uses synchronous replication.
  • EConfigure the database connection string to point to the endpoint of the primary replica.

How the community answered

(25 responses)
  • A
    80% (20)
  • B
    12% (3)
  • C
    4% (1)
  • E
    4% (1)

Why each option

To enable cross-region automatic failover for an Azure SQL database, you must configure a failover group, and the database should be provisioned to leverage high availability mechanisms for data durability.

AAdd the database to a failover group.Correct

Adding the database to a failover group configures cross-region geo-replication and enables automatic failover to a secondary region if the primary region becomes unavailable.

BAdd the database to a database pool.

Database pools (elastic pools) are used to manage resource allocation for multiple databases, not for cross-region high availability or disaster recovery.

CConfigure the database connection string to point to the endpoint of the read-write listener.

Configuring the connection string to a read-write listener endpoint is a connection method used *after* a failover group is established, not a configuration task to enable the failover group itself.

DAdd the database to an AlwaysOn availability group that uses synchronous replication.Correct

While cross-region replication in failover groups is asynchronous, selecting a service tier like Business Critical for Azure SQL Database internally leverages Always On Availability Groups with synchronous replication for high availability and near-zero data loss within the primary region, contributing to overall regional availability.

EConfigure the database connection string to point to the endpoint of the primary replica.

Configuring the connection string to the primary replica endpoint is the default connection method and does not enable cross-region automatic failover.

Concept tested: Azure SQL Database geo-replication and failover groups

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

Topics

#Azure SQL DB failover groups#active geo-replication#automatic failover#disaster recovery

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-473 Practice