ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Solutions Architect - Associate SAA-C03 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C03 exam
Go to Exam

Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 999 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C03
Question #: 999
Topic #: 1
[All AWS Certified Solutions Architect - Associate SAA-C03 Questions]

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 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.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by viejito at Sept. 30, 2024, 9:47 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
aragon_saa
Highly Voted 7 months ago
Selected Answer: B
Answer is B
upvoted 7 times
...
LeonSauveterre
Most Recent 3 months, 3 weeks ago
Selected Answer: B
A - For transactional or low-latency queries like product catalog searches in an ecommerce website, Redshift is not suitable because it's a data warehouse solution optimized for analytical queries. B - ElastiCache for Redis is a highly performant, in-memory caching service that can significantly reduce database load by caching frequent queries. C - Adding more web servers can't help alleviate the load on the database. The database remains the bottleneck for product catalog queries. D - If you turn on throttle queries, customers may gradually ask for a refund :) Let's get rid of the bad things in database instead of user experience. BTW, what Lazy Loading means: Data is added to the cache only when requested. If not found in the cache, it is fetched from the database and added to the cache for subsequent requests.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago