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