AWS Certified Solutions Architect – Associate (SAA-C03) — Question 148

A company recently started using Amazon Aurora as the data store for its global ecommerce application. When large reports are run, developers report that the ecommerce application is performing poorly. After reviewing metrics in Amazon CloudWatch, a solutions architect finds that the ReadIOPS and CPUUtilizalion metrics are spiking when monthly reports run.
What is the MOST cost-effective solution?

Answer options

• A. Migrate the monthly reporting to Amazon Redshift.
• B. Migrate the monthly reporting to an Aurora Replica.
• C. Migrate the Aurora database to a larger instance class.
• D. Increase the Provisioned IOPS on the Aurora instance.

Correct answer: B

Explanation

The best solution is to migrate the monthly reporting to an Aurora Replica, as this allows for offloading read traffic from the primary instance without incurring high costs. The other options, such as migrating to Amazon Redshift or increasing instance size, can be more expensive and may not effectively address the immediate performance concerns during reporting.