AWS Certified Database – Specialty — Question 182

A company is using a Single-AZ Amazon RDS for MySQL DB instance for development. The DB instance is experiencing slow performance when queries run.
Amazon CloudWatch metrics indicate that the instance requires more I/O capacity.
Which actions can a database specialist perform to resolve this issue? (Choose two.)

Answer options

• A. Restart the application tool used to run queries.
• B. Change to a database instance class with higher throughput.
• C. Convert from Single-AZ to Multi-AZ.
• D. Increase the I/O parameter in Amazon RDS Enhanced Monitoring.
• E. Convert from General Purpose to Provisioned IOPS (PIOPS).

Correct answer: B, E

Explanation

The correct answers are B and E because upgrading to a higher throughput instance class (B) directly increases the I/O capacity needed for better performance. Additionally, switching from General Purpose to Provisioned IOPS (PIOPS) (E) allows for more predictable and higher I/O performance. The other options do not effectively address the I/O capacity issue; restarting the application (A) does not enhance the database's capability, changing availability zones (C) doesn't inherently improve I/O, and adjusting monitoring parameters (D) does not increase actual I/O performance.