AWS Certified Solutions Architect – Associate (SAA-C02) — Question 346

An application uses an Amazon RDS MySQL DB instance. The RDS database is becoming low on disk space. A solutions architect wants to increase the disk space without downtime. Which solution meets these requirements with the LEAST amount of effort?

Answer options

• A. Enable storage auto scaling in RDS.
• B. Increase the RDS database instance size.
• C. Change the RDS database instance storage type to Provisioned IOPS.
• D. Back up the RDS database, increase the storage capacity, restore the database and stop the previous instance.

Correct answer: A

Explanation

Enabling RDS storage auto-scaling allows Amazon RDS to automatically expand storage capacity as the database grows, which requires no downtime and the least amount of management effort. Scaling up the instance size (Option B) or changing the storage type to Provisioned IOPS (Option C) does not resolve the storage capacity issue itself. Manual backup and restore (Option D) requires significant effort and introduces database downtime.