AWS Certified Solutions Architect – Professional (SAP-C02) — Question 123

A company is running a critical application that uses an Amazon RDS for MySQL database to store data. The RDS DB instance is deployed in Multi-AZ mode.

A recent RDS database failover test caused a 40-second outage to the application. A solutions architect needs to design a solution to reduce the outage time to less than 20 seconds.

Which combination of steps should the solutions architect take to meet these requirements? (Choose three.)

Answer options

• A. Use Amazon ElastiCache for Memcached in front of the database
• B. Use Amazon ElastiCache for Redis in front of the database
• C. Use RDS Proxy in front of the database.
• D. Migrate the database to Amazon Aurora MySQL.
• E. Create an Amazon Aurora Replica.
• F. Create an RDS for MySQL read replica

Correct answer: C, D, E

Explanation

Using RDS Proxy allows for connection pooling and helps manage failover more efficiently, thereby reducing downtime. Migrating to Amazon Aurora MySQL can enhance performance and availability features, while creating an Aurora Replica provides additional read scalability and availability options. The other options do not specifically address reducing failover time effectively.