A reporting application runs heavy analytical queries against an Amazon RDS for PostgreSQL database. These queries are causing performance degradation for the main transactional web application. Which TWO actions should the solutions architect take to improve performance? (Select TWO.)

Answer options:

Enable Multi-AZ on the RDS instance.

Create an RDS Read Replica.

Point the reporting application to the Read Replica.

Migrate the database to Amazon DynamoDB.

Increase the instance size of the RDS database.

How to approach this question

Identify the need to offload read queries from the primary database.

Full Answer

Create an RDS Read Replica., Point the reporting application to the Read Replica.

Amazon RDS Read Replicas allow you to elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads. You must create the replica and update your reporting app to use the new endpoint.

Common mistakes

Thinking Multi-AZ standby instances can serve read traffic.

Question 44 All questions Question 46

Practice the full AWS SAA-C03 Practice Exam 5

65 questions · hints · full answers · grading

More questions from this exam

Q01A company needs to grant an external auditor read-only access to specific AWS resources. The audi...Easy Q02An application running on EC2 instances needs to access objects in an S3 bucket. The security tea...Medium Q03A company is designing a VPC for a multi-tier web application. They need to block specific malici...Medium Q04A large enterprise uses AWS Organizations to manage multiple accounts. The security team wants to...Hard Q05A company hosts a web application on an Application Load Balancer (ALB). They are experiencing SQ...Medium

View all 65 questions →