What is the MOST operationally efficient and cost-effective solution?
Configure RDS Storage Auto Scaling.
Configure RDS instance Auto Scaling.
Modify the DB instance allocated storage to meet the forecasted requirements.
Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.
Explanations:
RDS Storage Auto Scaling automatically adjusts storage capacity when free space is running low, providing an operationally efficient and cost-effective solution. This feature eliminates the need for manual monitoring or intervention.
RDS instance Auto Scaling is related to CPU, memory, and I/O resources, not storage. It does not automatically adjust storage capacity.
Manually modifying the DB instance storage to meet forecasted requirements requires periodic adjustments and monitoring, which is less efficient and scalable than automatic scaling.
Manually monitoring FreeStorageSpace and adding storage as needed is not operationally efficient. It introduces a risk of human error and delays in scaling storage before running out of space.