A reporting application runs complex analytical queries against an Amazon Aurora MySQL database. These queries are slowing down the primary database used by the transactional web application. How can a solutions architect improve performance for both applications?

Answer options:

Enable Multi-AZ on the Aurora cluster.

Create an Aurora Replica and direct the reporting application to the reader endpoint.

Migrate the database to Amazon DynamoDB.

Increase the instance size of the primary database.

How to approach this question

Identify the need to separate read-heavy analytical queries from transactional writes. Read Replicas solve this.

Full Answer

B.Create an Aurora Replica and direct the reporting application to the reader endpoint.✓ Correct

Create an Aurora Replica and direct the reporting application to the reader endpoint.

Amazon Aurora Replicas share the same underlying storage as the primary instance. By creating a replica and directing the reporting application to the Aurora Reader Endpoint, you offload the heavy read queries, improving performance for the transactional application.

Common mistakes

Confusing Multi-AZ (standby, no reads) with Read Replicas (active, for reads).

Question 43 All questions Question 45

Practice the full AWS SAA-C03 Practice Exam 3

65 questions · hints · full answers · grading

More questions from this exam

Q01A company stores sensitive documents in an Amazon S3 bucket. The security team requires that only...Easy Q02A large enterprise uses AWS Organizations to manage multiple accounts. The security team wants to...Medium Q03A company hosts a web application on Amazon EC2 instances behind an Application Load Balancer (AL...Easy Q04A company wants to continuously monitor its AWS accounts for malicious activity and unauthorized ...Medium Q05A company needs to encrypt data at rest in Amazon RDS and manage database credentials securely. T...Medium

View all 65 questions →