A company plans to migrate their SAP HANA database to AWS. They require the highest availability with automatic failover in case of an AZ failure. Which architecture should they use?
Provides automatic failover across AZs.
Why this answer
It meets the requirement for highest availability with automatic failover in case of an AZ failure. HANA System Replication (HSR) in synchronous mode ensures zero data loss (RPO=0) by committing transactions only after they are replicated to the standby, and when combined with Multi-AZ deployment, it provides automatic failover across Availability Zones. This architecture is the AWS-recommended pattern for SAP HANA high availability, leveraging the AWS Multi-AZ concept with HSR's built-in automatic takeover capability.
Exam trap
The trap here is that candidates often confuse 'high availability' with 'disaster recovery' and select a backup-only option (C) or a Single AZ option (B), failing to recognize that automatic failover across AZs requires both Multi-AZ deployment and synchronous replication with automated takeover.
How to eliminate wrong answers
Option B is wrong because Single AZ deployment cannot protect against an AZ failure; if the entire AZ goes down, both primary and standby are lost. Option C is wrong because daily backups to Amazon S3 provide disaster recovery (point-in-time recovery) but do not offer automatic failover or high availability; recovery time can be hours, not seconds. Option D is wrong because HSR in async mode may result in data loss (RPO > 0) during a failover, and manual failover does not meet the 'automatic failover' requirement stated in the question.