Q34 — AWS SAA-C03 Ch.1

Question 34 of 65 | ← Chapter 1

Q34. 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 over 10 million rows. The database has 2 TB of General Purpose SSD (gp2) storage. There are millions of updates against this data every day through the company's website. The company has noticed some operations are taking 10 seconds or longer, and has determined that the database storage performance is bottleneck.Which solution addresses the performance issues?

Correct Answer: A. Change the storage type to Provissioned IOPS SSD (io1).

Explanation

Provisioned IOPS SSD (io1) is a storage type in Amazon RDS that provides predictable performance for database workloads. By changing the storage type to io1, you can allocate a specific number of IOPS (Input/Output Operations Per Second) to meet the performance requirements of your workload.In this scenario, with millions of daily updates and a large amount of data, the General Purpose SSD (gp2) storage may not be able to handle the workload efficiently. By switching to io1 storage and provisioning an appropriate amount of IOPS based on the workload demands, you can ensure consistent and high-performance storage access.Other options like changing the instance class to a memory-optimized instance or using a burstable performance DB instance class may improve certain aspects of performance but may not directly address the storage performance bottleneck.Enabling Multi-AZ RDS read replicas with MySQL native asynchronous replication (option D) can help with scaling the reads and improving availability but may not directly address the storage performance issue.预置IOPS SSD (io1)是Amazon RDS