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

Incorrect Answers:

C: Availability Zones are unique physical locations within a region. Each zone is made up of one or more datacenters equipped with independent power, cooling, and networking.

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