What is the MOST cost-effective solution?

By:
In: SAA-C03
Tagged:
With: 2 Comments
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?

Migrate the monthly reporting to Amazon Redshift.

Migrate the monthly reporting to an Aurora Replica.

Migrate the Aurora database to a larger instance class.

Increase the Provisioned IOPS on the Aurora instance.

Explanations:

Migrating to Amazon Redshift may improve performance for large reports, but it involves additional costs and complexity. It is not the most cost-effective immediate solution.

Using an Aurora Replica for reporting offloads the read workload from the primary instance, reducing spikes in ReadIOPS and CPU utilization while being a cost-effective option.

Migrating to a larger instance class improves performance but incurs higher costs without addressing the root cause of the spikes.

Increasing Provisioned IOPS may improve performance but is a more expensive option that doesn’t effectively separate reporting workloads from transaction workloads.

2026-04-01

2 Comments

  1. Alexis
    Author

    I appraise that the answer is:
    Migrate the monthly reporting to an Aurora Replica.

  2. Albert
    Author

    As I see it, the answer is:
    Migrate the monthly reporting to an Aurora Replica.

Leave a Reply

Your email address will not be published. Required fields are marked *

17 − 6 =