Explanation:
In Amazon Aurora, the amount of local storage (used for temporary tables, sorting operations, etc.) is directly tied to the DB instance class size. The FreeLocalStorage metric monitors the amount of storage available for temporary tables and logs on the DB instance. To increase the local storage and resolve the issue of running out of temporary storage during heavy report operations, you must scale up the DB instance by modifying the instance class to a larger size.
Ultimate access to all questions.
Question 22
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?
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.
No comments yet.