You need to recommend a disaster recovery solution for the back-end tier of the payment processing system.
What should you include in the recommendation?
A . Always On Failover Cluster Instances
B . Azure Site Recovery
C . an auto-failover group
D . geo-redundant database backups
Answer: C
Explanation:
Scenario:
– The back-end data store is implemented as a Microsoft SQL Server 2014 database.
– If a data center fails, ensure that the payment processing system remains available without any administrative intervention.
Note: Auto-failover groups is a SQL Database feature that allows you to manage replication and failover of a group of databases on a SQL Database server or all databases in a managed instance to another region. It is a declarative abstraction on top of the existing active geo-replication feature, designed to simplify deployment and management of geo-replicated databases at scale.
Reference: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auto-failover-group