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: D

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