AWS Certified Solutions Architect – Associate (SAA-C03) — Question 11

A company maintains a searchable repository of items on its website. The data is stored in an Amazon RDS for MySQL database table that contains more than 10 million rows. The database has 2 TB of General Purpose SSD storage. There are millions of updates against this data every day through the company's website.
The company has noticed that some insert operations are taking 10 seconds or longer. The company has determined that the database storage performance is the problem.
Which solution addresses this performance issue?

Answer options

• A. Change the storage type to Provisioned IOPS SSD.
• B. Change the DB instance to a memory optimized instance class.
• C. Change the DB instance to a burstable performance instance class.
• D. Enable Multi-AZ RDS read replicas with MySQL native asynchronous replication.

Correct answer: A

Explanation

The correct answer is A because Provisioned IOPS SSD provides higher and more consistent input/output operations per second (IOPS) than General Purpose SSD, which is crucial for handling the high volume of insert operations. The other options do not directly address the storage performance issue; changing the instance class might improve overall performance but won’t resolve the specific bottleneck caused by the storage type.