AWS Certified Database – Specialty — Question 200

A company is using an Amazon RDS Multi-AZ DB instance in its development environment. The DB instance uses General Purpose SSD storage. The DB instance provides data to an application that has I/O constraints and high online transaction processing (OLTP) workloads. The users report that the application is slow.

A database specialist finds a high degree of latency in the database writes. The database specialist must decrease the database latency by designing a solution that minimizes operational overhead.

Which solution will meet these requirements?

Answer options

• A. Eliminate the Multi-AZ deployment. Run the DB instance in only one Availability Zone
• B. Recreate the DB instance. Use the default storage type. Reload the data from an automatic snapshot
• C. Switch the storage to Provisioned IOPS SSD on the DB instance that is running
• D. Recreate the DB instance. Use Provisioned IOPS SSD storage. Reload the data from an automatic snapshot

Correct answer: C

Explanation

The correct answer is C because switching to Provisioned IOPS SSD storage significantly enhances I/O performance, which is essential for OLTP workloads experiencing latency issues. Options A and B do not address the underlying storage performance problem, while option D, although effective, involves more operational overhead due to the need to recreate the instance and reload data.