A relational database running on Amazon RDS for PostgreSQL is experiencing performance bottlenecks. CloudWatch metrics show high CPU utilization and high Read IOPS, while Write IOPS are low. Which TWO strategies should the architect implement to improve performance? (Select TWO)

Answer options:

Migrate to Amazon DynamoDB.

Create RDS Read Replicas and offload read queries to them.

Enable Multi-AZ deployments.

Increase the size of the EBS volumes to get more baseline IOPS.

Implement Amazon ElastiCache to cache frequently accessed data.

Use AWS Database Migration Service to migrate to Oracle.

How to approach this question

Identify solutions for a read-heavy relational database.

Full Answer

For a read-heavy workload causing CPU and IOPS bottlenecks, creating Read Replicas allows you to offload read traffic. Implementing a caching layer like ElastiCache prevents many read queries from ever hitting the database.

Common mistakes

Choosing Multi-AZ, which is a standby node and cannot serve read traffic.

Question 53 All questions Question 55

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 →