A retail company wants to deploy a mission-critical web application that must remain operational even in the event of an Availability Zone outage. The application requires an RDBMS for transaction processing and should handle failover automatically without any manual intervention. Which AWS service should the company use to meet these requirements?
Utilize Amazon RDS with Multi-AZ deployments for high availability and automatic failover.
Implement Amazon Redshift with Concurrency Scaling features for database needs.
Deploy Amazon DynamoDB with global tables across multiple regions.
Leverage Amazon Aurora with cross-region replication for database high availability.