AWS Certified Solutions Architect – Associate (SAA-C02) — Question 95

A public-facing web application queries a database hosted on an Amazon EC2 instance in a private subnet. A large number of queries involve multiple table joins, and the application performance has been degrading due to an increase in complex queries. The application team will be performing updates to improve performance.
What should a solutions architect recommend to the application team? (Choose two.)

Answer options

• A. Cache query data in Amazon SQS
• B. Create a read replica to offload queries
• C. Migrate the database to Amazon Athena
• D. Implement Amazon DynamoDB Accelerator to cache data.
• E. Migrate the database to Amazon RDS

Correct answer: B, E

Explanation

Creating a read replica (Option B) allows the application to offload some of the query load from the primary database, improving performance. Migrating to Amazon RDS (Option E) can provide better scalability and management for relational databases, which is essential for handling complex queries. Options A, C, and D do not directly address the performance issues related to complex SQL queries in a relational database context.