AWS Certified SysOps Administrator – Associate — Question 315

A company is running Amazon RDS for PostgreSQL Multi-AZ DB clusters. The company uses an AWS CloudFormation template to create the databases individually with a default size of 100 GB. The company creates the databases every Monday and deletes the databases every Friday.

Occasionally, the databases run low on disk space and initiate an Amazon CloudWatch alarm. A SysOps administrator must prevent the databases from running low on disk space in the future.

Which solution will meet these requirements with the FEWEST changes to the application?

Answer options

• A. Modify the CloudFormation template to use Amazon Aurora PostgreSQL as the DB engine.
• B. Modify the CloudFormation template to use Amazon DynamoDB as the database. Activate storage auto scaling during creation of the tables.
• C. Modify the Cloud Formation template to activate storage auto scaling on the existing DB instances.
• D. Create a CloudWatch alarm to monitor DB instance storage space. Configure the alarm to invoke the VACUUM command.

Correct answer: C

Explanation

Enabling storage auto scaling in the CloudFormation template is the most efficient solution because it allows Amazon RDS to dynamically scale storage up without requiring any changes to the application code. Migrating to Aurora PostgreSQL or DynamoDB would involve significant code and architectural changes to the application. Using CloudWatch to trigger a VACUUM command does not scale the physical disk capacity and is not a reliable way to handle growing storage demands.