A reporting application runs complex SQL queries against an Amazon RDS for MySQL database. During the end-of-month reporting period, the heavy read traffic causes the database to become unresponsive for the main transactional web application. How can a solutions architect improve performance for both workloads?

Answer options:

Enable Multi-AZ on the RDS instance and point the reporting application to the standby instance.

Create an RDS Read Replica and point the reporting application to it.

Migrate the database to Amazon DynamoDB.

Implement Amazon ElastiCache.

How to approach this question

Identify the need to separate read-heavy reporting from transactional workloads. RDS Read Replicas are designed for this.

Full Answer

B.Create an RDS Read Replica and point the reporting application to it.✓ Correct

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.

Common mistakes

Trying to use the Multi-AZ standby instance for reads (it is strictly passive).

Question 45 All questions Question 47

Practice the full AWS SAA-C03 Practice Exam 7

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 needs...Medium Q02An application runs on Amazon EC2 instances and needs to access an Amazon S3 bucket. What is the ...Easy Q03A company wants to implement federated access to the AWS Management Console for its employees usi...Medium Q04A company is building a mobile application that requires users to sign in using their social medi...Easy Q05A security team wants to enforce MFA for all IAM users before they can terminate EC2 instances. H...Medium

View all 65 questions →