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

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?

Answer options

• 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 additional EC2 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

Explanation

Implementing Amazon ElastiCache for Redis allows the application to cache the infrequently updated product catalog data, which offloads read traffic from the RDS database and resolves the high CPU bottleneck. Adding more EC2 instances does not resolve the database bottleneck, and enabling Multi-AZ is a high availability feature that does not scale read performance. Amazon Redshift is an analytical data warehouse and is not suited for low-latency web application searches.