AWS Certified SysOps Administrator – Associate — Question 382

A company is using an Amazon CloudWatch alarm to monitor the FreeLocalStorage metric for an Amazon Aurora PostgreSQL production database. The alarm goes into ALARM state and indicates that the database is running low on temporary storage. A SysOps administrator discovers that a weekly report is using most of the temporary storage that is currently allocated.

What should the SysOps administrator do to solve this problem?

Answer options

• A. Turn on Aurora PostgreSQL query plan management.
• B. Modify the configuration of the DB cluster to turn on storage auto scaling.
• C. Add an Aurora read replica to the DB cluster. Modify the report to use the new read replica.
• D. Modify the DB instance class for each DB instance in the DB cluster to increase the instance size.

Correct answer: B

Explanation

Enabling storage auto scaling on the Amazon Aurora DB cluster allows the storage volume to dynamically expand to meet the demands of resource-intensive operations like weekly reporting. This automatically resolves the low temporary storage issue without requiring manual intervention. Other solutions, such as adding a read replica or enabling query plan management, do not directly scale the storage capacity of the database cluster.