A company is experiencing performance issues with an application running on Amazon EC2 instances. The application connects to an Amazon RDS for PostgreSQL database. During peak hours, the database CPU utilization hits 100%, and the application times out. The database is heavily read-intensive. Which combination of steps will improve performance? (Select TWO)

Answer options:

Implement Amazon ElastiCache for Redis to cache frequently accessed data.

Migrate the database to Amazon DynamoDB.

Create an RDS Read Replica and update the application to direct read queries to it.

Enable Multi-AZ on the RDS instance.

Increase the size of the EC2 instances.

Use AWS Global Accelerator to route traffic.

How to approach this question

Identify solutions for scaling read-heavy relational databases.

Full Answer

Implement Amazon ElastiCache for Redis to cache frequently accessed data., Create an RDS Read Replica and update the application to direct read queries to it.

For a read-intensive RDS database hitting CPU limits, the best solutions are to implement a caching layer (ElastiCache) or scale out reads using RDS Read Replicas.

Common mistakes

Thinking Multi-AZ improves performance (it only provides HA).

Question 47 All questions Question 49

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

75 questions · hints · full answers · grading

More questions from this exam

Q01A global enterprise is designing a multi-region network architecture connecting 50 AWS accounts a...Hard Q02A company is migrating its hybrid network to AWS. They have two 10 Gbps AWS Direct Connect connec...Hard Q03An enterprise has 100 AWS accounts in AWS Organizations. The security team mandates that all Amaz...Medium Q04A financial company requires that all EBS volumes, S3 buckets, and RDS databases be encrypted usi...Easy Q05An enterprise is designing a disaster recovery strategy for a critical application running on Ama...Hard

View all 75 questions →