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?
Deploy Amazon DynamoDB with global tables across multiple regions.
Leverage Amazon Aurora with cross-region replication for database high availability.
Implement Amazon Redshift with Concurrency Scaling features for database needs.
Utilize Amazon RDS with Multi-AZ deployments for high availability and automatic failover.