A read-heavy news website uses Amazon Aurora MySQL. During breaking news events, the database CPU spikes to 100% due to millions of identical read queries, causing the site to crash. How can the architect improve performance with minimal code changes?

Answer options:

Migrate the database to DynamoDB.

Implement Amazon ElastiCache for Redis in front of the database to cache query results.

Enable Aurora Serverless v2.

Use Amazon SQS to queue the read requests.

How to approach this question

Identify the best solution for identical, read-heavy database queries.

Full Answer

B.Implement Amazon ElastiCache for Redis in front of the database to cache query results.✓ Correct

Implement Amazon ElastiCache for Redis in front of the database to cache query results.

Amazon ElastiCache provides an in-memory caching layer. By caching the results of common queries, you drastically reduce the load on the Aurora database during traffic spikes.

Common mistakes

Choosing Aurora Serverless, which might not scale fast enough for sudden 'breaking news' spikes compared to a cache.

Question 40 All questions Question 42

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 6

75 questions · hints · full answers · grading

More questions from this exam

Q01A global enterprise requires highly available hybrid connectivity between its on-premises data ce...Hard Q02An organization has 50 VPCs across two AWS Regions connected via Transit Gateways (TGW). The TGWs...Hard Q03A company uses AWS Organizations. The network team wants to share a central Transit Gateway (TGW)...Medium Q04An enterprise has on-premises data centers in the US and Europe. They want to use the AWS global ...Hard Q05A company requires that all API calls to Amazon S3 from their VPC must not traverse the public in...Medium

View all 75 questions →