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?
Turn on Aurora PostgreSQL query plan management.
Modify the configuration of the DB cluster to turn on storage auto scaling.
Add an Aurora read replica to the DB cluster. Modify the report to use the new read replica.
Modify the DB instance class for each DB instance in the DB cluster to increase the instance size.
I calculate that the answer is:
Add an Aurora read replica to the DB cluster. Modify the report to use the new read replica.
Based on what I know, the answer is:
Add an Aurora read replica to the DB cluster. Modify the report to use the new read replica.