SAA-C03 · Question #610
A company is creating a prototype of an ecommerce website on AWS. The website consists of an Application Load Balancer, an Auto Scaling group of Amazon EC2 instances for web servers, and an Amazon…
The correct answer is B. Implement an Amazon ElastiCache for Redis cluster to cache the product catalog. Use lazy. To improve website performance during product catalog searches that cause high CPU utilization on an infrequently updated Aurora MySQL DB instance, the solutions architect should implement an Amazon ElastiCache for Redis cluster to cache the product catalog.
Question
A company is creating a prototype of an ecommerce website on AWS. The website consists of an Application Load Balancer, an Auto Scaling group of Amazon EC2 instances for web servers, and an Amazon RDS for MySQL DB instance that runs with the Single-AZ configuration. The website is slow to respond during searches of the product catalog. The product catalog is a group of tables in the MySQL database that the company does not update frequently. A solutions architect has determined that the CPU utilization on the DB instance is high when product catalog searches occur. What should the solutions architect recommend to improve the performance of the website during searches of the product catalog?
Options
- AMigrate the product catalog to an Amazon Redshift database. Use the COPY command to load
- BImplement an Amazon ElastiCache for Redis cluster to cache the product catalog. Use lazy
- CAdd an additional scaling policy to the Auto Scaling group to launch additional EC2 instances
- DTurn on the Multi-AZ configuration for the DB instance. Configure the EC2 instances to throttle
How the community answered
(50 responses)- A2% (1)
- B82% (41)
- C6% (3)
- D10% (5)
Why each option
To improve website performance during product catalog searches that cause high CPU utilization on an infrequently updated Aurora MySQL DB instance, the solutions architect should implement an Amazon ElastiCache for Redis cluster to cache the product catalog.
Amazon Redshift is a data warehouse optimized for analytical queries, not a suitable solution for real-time transactional product catalog lookups from a web application, and would introduce unnecessary complexity and cost.
Implementing an Amazon ElastiCache for Redis cluster to cache the product catalog will offload read requests from the Aurora MySQL DB instance, significantly reducing its CPU utilization during searches and improving response times, especially since the catalog data is not updated frequently.
Adding more EC2 instances to the Auto Scaling group would only scale the web tier and would not address the root cause of high CPU utilization on the database instance.
Enabling Multi-AZ for an Aurora DB cluster provides high availability, not read scaling. While Aurora supports read replicas, an in-memory cache like ElastiCache is a more effective solution for frequently read, infrequently updated data to directly offload the database.
Concept tested: Database read scaling, caching strategies, ElastiCache
Source: https://aws.amazon.com/elasticache/what-is-redis/
Community Discussion
No community discussion yet for this question.