Q30 — AWS SAA-C03 Ch.3

Question 30 of 65 | ← Chapter 3

Q160. 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?

• A. Migrate the product catalog to an Amazon Redshift database. Use the COPY command to load the product catalog tables.
• B. Implement an Amazon ElastiCache for Redis cluster to cache the product catalog. Use lazy loading to populate the cache. ✓
• C. Add an additional scaling policy to the Auto Scaling group to launch additionalEC2 instances when database response is slow.
• D. Turn on the Multi-AZ configuration for the DB instance. Configure the EC2 instances to throttle the product catalog queries that are sent to the database.

Correct Answer: B. Implement an Amazon ElastiCache for Redis cluster to cache the product catalog. Use lazy loading to populate the cache.

Explanation

To improve the performance of the ecommerce website during searches of the product catalog, a solutions architect should recommend implementing an Amazon ElastiCache for Redis cluster to cache the product catalog. Therefore, option B is the correct answer.Option A suggests migrating the product catalog to an Amazon Redshift database. While this may provide benefits in terms of improved query performance, it is not necessary and could increase operational overhead.Option C suggests adding an additional scaling policy to the Auto Scaling group, but this will not necessarily address the underlying issue of high CPU utilization on the RDS instance.Option D suggests turning on Multi-AZ configuration for the DB instance and configuring EC2 instances to throttle product catalog queries. While Multi-AZ deployment can provide high availability and automatic failover, it will not directly address the issue of high CPU utilization.By implementing an Amazon ElastiCache for Redis cluster, the frequently accessed data from the MySQL database can be stored in-memory, allowing for faster access times. Lazy loading can also be used to populate the cache with data as needed, reducing the impact on the database. This approach will improve the performance of the website during searches of the product catalog without requiring changes to the underlying data model or application code.