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

A company is migrating a three-tier application to AWS. The application requires a MySQL database. In the past, the application users reported poor application performance when creating new entries. These performance issues were caused by users generating different real-time reports from the application during working hours.
Which solution will improve the performance of the application when it is moved to AWS?

Answer options

• A. Import the data into an Amazon DynamoDB table with provisioned capacity. Refactor the application to use DynamoDB for reports.
• B. Create the database on a compute optimized Amazon EC2 instance. Ensure compute resources exceed the on-premises database.
• C. Create an Amazon Aurora MySQL Multi-AZ DB cluster with multiple read replicas. Configure the application to use the reader endpoint for reports.
• D. Create an Amazon Aurora MySQL Multi-AZ DB cluster. Configure the application to use the backup instance of the cluster as an endpoint for the reports.

Correct answer: C

Explanation

The correct answer is C because creating an Amazon Aurora MySQL Multi-AZ DB cluster with read replicas allows for load distribution, enabling the application to handle reporting queries efficiently without affecting the performance of data entry. Options A and B do not address the specific needs for MySQL or the benefits of read replicas, while option D uses a backup instance, which is not optimal for handling concurrent reporting loads.