Hotspot Question You are working on two projects that will use Azure SQL databases. The projects have the disaster recovery requirements shown in the following table. You need to recommend a…

Question

Exhibits

Answer Area

• Project1Active geo-replication
  Active geo-replicationAlways On availability groupsFailover groupsLog shippingZone-redundant storage (ZRS)
• Project2Failover groups
  Active geo-replicationAlways On availability groupsFailover groupsLog shippingZone-redundant storage (ZRS)

Explanation

For Project1, the requirements are continuous data synchronization between primary and secondary replicas and support for read-only secondary replicas. Active geo-replication (Box 1 Explanation) explicitly supports both, replicating data continuously from a primary database to a readable secondary database for disaster recovery or read scale workloads.

For Project2, the requirements include continuous data synchronization, an unchanged connection string after a failover, and the ability for multiple databases to fail over simultaneously. Failover groups (Box 2 Explanation) are designed for this scenario, ensuring continuous sync, maintaining the connection string, and enabling the simultaneous failover of a group of Azure SQL databases.

No community discussion yet for this question.