A retail company runs an e-commerce site across multiple AWS Regions and requires the website to remain operational at all times for online purchases. The site uses an Amazon RDS for MySQL DB instance for data storage. Which option provides the highest availability for the database?
Choose an answer
Tap an option to check your answer.
Correct answer: Create cross-Region read replicas on Amazon RDS and, in a disruption, promote a cross-Region read replica to a standalone DB instance, direct traffic to it, and create a replacement read replica from the promoted instance..
Why this is the answer
Creating cross-Region read replicas provides the highest availability because it allows for a quick recovery point objective (RPO) and recovery time objective (RTO) in a disaster scenario. If the primary Region becomes unavailable, a read replica in another Region can be promoted to a standalone DB instance, minimizing downtime. A new read replica can then be created from the promoted instance to maintain redundancy. Relying on automated backups is less ideal because restoring from a backup takes significantly longer, leading to extended downtime. Enabling Amazon RDS global tables and read replicas with Lambda to copy read replicas is incorrect because RDS for MySQL does not support global tables; this feature is for DynamoDB. Similarly, enabling global tables for RDS is incorrect for the same reason.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed