AWS Certified Solutions Architect Associate SAA-C03 Practice Question
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?
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.
Deploy Amazon DynamoDB with global tables across multiple regions.
Amazon RDS with Multi-AZ deployments meets the requirements by automatically maintaining a synchronous physical standby copy of the database in a different Availability Zone. In the event of planned database maintenance, DB instance failure, or an AZ disruption, Amazon RDS performs failover to the up-to-date secondary DB instance so that database operations can resume quickly without administrative intervention. Amazon Aurora is only available in certain regions and does not guarantee synchronous replication across multiple regions. Amazon Redshift is optimized for analytical workloads, not transaction processing. Amazon DynamoDB provides excellent performance for key-value and document databases but does not support traditional relational database transactions in the same way as Amazon RDS.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Multi-AZ deployment in Amazon RDS?
Open an interactive chat with Bash
How does failover work in Amazon RDS Multi-AZ deployments?
Open an interactive chat with Bash
Why is Amazon Aurora with cross-region replication not suitable for this scenario?