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 stays online; no downtime occurs, but I/O performance can be temporarily degraded while storage optimization completes.
Only PostgreSQL and Oracle support online IOPS changes; MySQL requires a maintenance window that causes downtime.
The DB instance becomes unavailable until the storage change finishes and the instance is automatically rebooted.
Provisioned IOPS cannot be changed in place; the administrator must restore from a snapshot configured with the new IOPS value.
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 does IOPS stand for and why is it important?
Open an interactive chat with Bash
What are provisioned IOPS and how do they differ from standard IOPS?
Open an interactive chat with Bash
Can I change the IOPS settings for an RDS instance during high traffic periods?