AWS Certified Solutions Architect Associate SAA-C03 Practice Question
An e-commerce company runs a production Amazon RDS for MySQL instance that uses Provisioned IOPS (io2) storage. To handle an upcoming flash-sale event, the database administrator plans to increase the Provisioned IOPS from 40,000 to 60,000 and chooses Apply immediately in the console. Which statement accurately describes what will happen after the modification is submitted?
The DB instance becomes unavailable until the storage change finishes and the instance is automatically rebooted.
The DB instance stays online; no downtime occurs, but I/O performance can be temporarily degraded while storage optimization completes.
Provisioned IOPS cannot be changed in place; the administrator must restore from a snapshot configured with the new IOPS value.
Only PostgreSQL and Oracle support online IOPS changes; MySQL requires a maintenance window that causes downtime.
Modifying the IOPS value is an online operation, so the DB instance remains available and no reboot occurs. Amazon RDS places the instance in the storage-optimization state while it redistributes data across the new volume layout. During this period, I/O latency can increase temporarily, but the change completes without downtime. The other answers incorrectly state that downtime, a snapshot restore, or engine-specific limitations are required.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Provisioned IOPS in Amazon RDS?
Open an interactive chat with Bash
What is storage optimization in Amazon RDS?
Open an interactive chat with Bash
Why does increasing IOPS in RDS cause temporary I/O latency?