Q54 — AWS SAA-C03 Ch.1

Question 54 of 65 | ← Chapter 1

Q54. 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 ReadlOPS and CPUUtilization metrics are spiking when monthly reports run.What is the MOST cost-effective solution?

Correct Answer: B. Migrate the monthly reporting to an Aurora Replica.

Explanation

The most cost-effective solution to address the performance issue during monthly reports in the given scenario is option B: Migrate the monthly reporting to an Aurora Replica. Here's why this solution is the most suitable: 1. Aurora Replica: Aurora supports the creation of read replicas, which are copies of the primary database instance. Read replicas can offload read traffic from the primary instance, providing additional capacity to handle large reporting workloads without impacting the performance of the ecommerce application. By migrating the monthly reporting workload to an Aurora Replica, the company gains the following benefits: - Offloading read traffic: By directing the reporting queries to the read replica, the primary instance is relieved from the additional read workload. This prevents spikes in Read IOPS and CPU utilization on the primary instance, improving the overall performance of the ecommerce application. - Scalability: Aurora replicas can be scaled horizontally by adding multiple replicas. This allows the reporting workload to be distributed across multiple replicas, further enhancing scalability and read performance. - Cost-effectiveness: Compared to other options, such as migrating to Amazon Redshift or increasing the provisioned IOPS on the Aurora instance, using Aurora replicas is a more cost-effective solution. It leverages the existing Aurora infrastructure and does not require additional resources or services. Option A suggests migrating the monthly reporting to Amazon Redshift. While Redshift is optimized for analytical workloads and can handle large reporting queries efficiently, it introduces additional costs and complexity by requiring a separate data warehouse solution. Option C suggests migrating the Aurora database to a larger instance class. While increasing the instance class can provide more CPU and memory resources, it may not effectively address the performance issue during monthly reports. Furthermore, it may result in increased costs without providing the desired performance improvement.