Exam AWS Certified SysOps Administrator - Associate topic 1 question 472 discussion

Answer B storage autoscaling

This is directly from AWS quoted, FreeLocalStorage = The amount of local storage available. Unlike for other DB engines, for Aurora DB instances this metric reports the amount of storage available to each DB instance. This value depends on the DB instance class. You can increase the amount of free storage space for an instance by choosing a larger DB instance class for your instance. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.AuroraMonitoring.Metrics.html

This directly addresses the issue. The FreeLocalStorage metric is tied to the instance size - larger instance classes come with more temporary storage. Upgrading the instance class would provide more temporary storage for operations like the weekly report.

B cause addresses storage issue. not C because a read replica does not have more local storage and results in the same issue.

This option directly addresses the low temporary storage issue by allowing the database to scale its storage automatically as required, ensuring that the database can handle the demands of the weekly report without running out of temporary storage.

predicted, only "read" for report - C

Amazon Aurora supports storage auto-scaling. By enabling this feature, the SysOps administrator can ensure that the Aurora PostgreSQL production database automatically scales its storage, reducing the risk of running out of free local storage. This is particularly useful in cases where it's difficult to predict storage requirements in advance, such as fluctuating workloads.Adding an Aurora read replica would offload read traffic from the primary database and could potentially alleviate performance issues. However, since the question indicates that temporary storage space is the problem, and not necessarily the performance of read operations, this might not resolve the issue of running out of storage. Moreover, if the report generation involves a significant amount of data writing, a read replica will not help because write operations cannot be offloaded to read replicas.

I would say B.

C makes most sense compared to all others..

For A sec id like to think adding a read replica, would solve this.