You need to deploy a new

Microsoft Azure SQL database that must meet the following requirements:

Will be available if 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 c

orrect answer presents part of the solution.

NOTE:

Each correct selection is worth one point.

A. Add the database to a failover group.

B. Add the database to a database pool.

C. Configure the database connection string to point to the endpoint of the rea

d-write listener.

D. Add the database to an AlwaysOn availability group that uses synchronous replication.

E. Configure the database connection string to point to the endpoint of the primary replica.

Explanation:

C: An availability group

requires a load balancer when the SQL Server instances are on Azure virtual machines. The load balancer stores the IP address for the availability group listener. If an availability group spans multiple regions, each region needs a load balancer.

D: To te

st listener connectivity to the remote region, you can fail over the replica to the remote region. While the replica is asynchronous, failover is vulnerable to potential data loss. To fail over without data loss, change the availability mode to synchronous

and set the failover mode to automatic.

Reference: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-availability-group-dr