What should you include in the recommendation?

You need to recommend an availability strategy for an Azure SQL database.

The strategy must meet the following requirements:

✑ Support failovers that do not require client applications to change their connection strings.

✑ Replicate the database to a secondary Azure region.

✑ Support failover to the secondary region.

What should you include in the recommendation?
A . failover groups
B. transactional replication
C. Availability Zones
D. geo-replication

View Answer

Answer: A

Explanation:

Active geo-replication is an Azure SQL Database feature that allows you to create readable secondary databases of individual databases on a server in the same or different data center (region).

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview