A popular news website uses an Amazon RDS for PostgreSQL database. During major news events, the database CPU utilization hits 100% due to a massive spike in read queries from users viewing articles. Write operations (publishing new articles) remain low.<br/><br/>Which TWO actions should a solutions architect take to improve database performance? (Select TWO.)

Answer options:

Enable RDS Multi-AZ.

Create an RDS Read Replica.

Update the application to route read queries to the Read Replica.

Migrate the database to Amazon DynamoDB.

Increase the size of the RDS instance to the largest available type.

How to approach this question

Identify the RDS feature designed to scale read-heavy workloads.

Full Answer

Create an RDS Read Replica.<br/>Update the application to route read queries to the Read Replica.

Amazon RDS Read Replicas provide enhanced performance and durability for RDS database instances. They make it easy to elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads. The application must be updated to use the replica's endpoint for read queries.

Common mistakes

Thinking Multi-AZ improves read performance (the standby is passive).

Question 44 All questions Question 46

Practice the full AWS SAA-C03 Practice Exam 6

65 questions · hints · full answers · grading

More questions from this exam

Q01A company has multiple AWS accounts in an AWS Organizations organization. The security team wants...Medium Q02A company has two AWS accounts: Account A for development and Account B for production. Developer...Medium Q03A mobile application needs to authenticate users using their social media accounts (Facebook, Goo...Easy Q04A company is running an application on Amazon EC2 instances. The application needs to connect to ...Medium Q05A company has 50 AWS accounts managed by AWS Organizations. The IT team wants to implement a cent...Easy

View all 65 questions →