AWS Certified Database – Specialty — Question 77

A database specialist manages a critical Amazon RDS for MySQL DB instance for a company. The data stored daily could vary from .01% to 10% of the current database size. The database specialist needs to ensure that the DB instance storage grows as needed.
What is the MOST operationally efficient and cost-effective solution?

Answer options

• A. Configure RDS Storage Auto Scaling.
• B. Configure RDS instance Auto Scaling.
• C. Modify the DB instance allocated storage to meet the forecasted requirements.
• D. Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.

Correct answer: A

Explanation

The correct answer is A, as configuring RDS Storage Auto Scaling allows the storage to automatically adjust based on usage, making it both efficient and cost-effective. Option B is incorrect because instance Auto Scaling pertains to the compute resources rather than storage. Options C and D require manual adjustments, which are less efficient and could lead to potential downtime or capacity issues.