A company has a multi-tier application. The database tier runs on Amazon RDS for MySQL. The application experiences heavy read traffic, causing the primary database instance to become a bottleneck. <br/><br/>How can the solutions architect improve performance MOST cost-effectively?

Answer options:

Change the RDS instance to a Multi-AZ deployment.

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

Migrate the database to Amazon DynamoDB.

Increase the size of the primary RDS instance.

How to approach this question

Identify the standard pattern for scaling read-heavy relational databases.

Full Answer

B.Create an RDS Read Replica and update the application to direct read queries 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

Confusing Multi-AZ (for HA) with Read Replicas (for performance).

Question 49 All questions Question 51

Practice the full AWS SAA-C03 Practice Exam 4

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 Q02An application running on Amazon EC2 instances needs to access an Amazon DynamoDB table. Both res...Easy Q03A company is designing a web application that will be hosted on AWS. The application will use an ...Medium Q04A company is building a mobile app that requires users to authenticate using their social media a...Hard Q05A solutions architect is designing a VPC for a three-tier web application. The database tier must...Medium

View all 65 questions →