Which solution will meet these requirements?

By:
In: DBS-C01
Tagged:
With: 1 Comment
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?

Eliminate the Multi-AZ deployment. Run the DB instance in only one Availability Zone

Recreate the DB instance. Use the default storage type. Reload the data from an automatic snapshot

Switch the storage to Provisioned IOPS SSD on the DB instance that is running

Recreate the DB instance. Use Provisioned IOPS SSD storage. Reload the data from an automatic snapshot

Explanations:

Eliminating the Multi-AZ deployment reduces availability and fault tolerance, which doesn’t address the issue of high latency in database writes.

Using the default storage type (General Purpose SSD) does not provide the required performance boost, and recreating the DB instance is unnecessary.

Switching to Provisioned IOPS SSD storage increases I/O performance, which is needed for high OLTP workloads and reduces database write latency.

Recreating the DB instance and switching to Provisioned IOPS SSD storage is unnecessary if the current instance can be modified directly without recreating it.

2025-09-30

1 Comment

  1. Jonathan
    Author

    I rate that the answer is:
    Switch the storage to Provisioned IOPS SSD on the DB instance that is running

Leave a Reply

Your email address will not be published. Required fields are marked *

11 − one =