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

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 the 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 performance bottleneck is directly attributed to storage I/O limitations caused by a high volume of daily write operations. Switching the storage type to Provisioned IOPS SSD delivers the consistent, high-throughput I/O performance required for such intensive write workloads. Modifying the instance class or setting up read replicas does not resolve the underlying storage-level write bottleneck.