ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 698 - SAA-C03 discussion

Report
Export

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 ate 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.
Answers
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.
Answers
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.
Answers
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.
Answers
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.
Suggested answer: B

Explanation:

Requirement Analysis: The product catalog search is causing high CPU utilization on the MySQL DB instance, slowing down the website.

ElastiCache Overview: Amazon ElastiCache for Redis can be used to cache frequently accessed data, reducing load on the database.

Lazy Loading: This caching strategy loads data into the cache only when it is requested, improving response times for repeated queries.

Implementation:

Set up an ElastiCache for Redis cluster.

Modify the application to check the cache before querying the database.

Use lazy loading to populate the cache on cache misses.

Conclusion: This approach reduces database load and improves website performance during product catalog searches.

Reference

Amazon ElastiCache: ElastiCache Documentation

Caching Strategies: ElastiCache Caching Strategies

asked 16/09/2024
Bonnie Lau
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first