What should the database specialist do to improve the performance of the application immediately?
Increase the Provisioned IOPS rate on the storage.
Increase the available storage space.
Use General Purpose SSD (gp2) storage with burst credits.
Create a read replica to offload Read IOPS from the DB instance.
Explanations:
Increasing the Provisioned IOPS rate will directly address the high disk I/O response time and high disk queue depth by providing more IOPS capacity, which helps to handle the additional workload.
Increasing storage space does not directly address the disk I/O performance issues. The issue is related to IOPS, not the amount of storage available.
General Purpose SSD (gp2) is not suitable for high-performance applications requiring consistent, high IOPS. Provisioned IOPS (io1) offers better performance for such workloads.
Creating a read replica helps offload read queries, but it does not address the underlying disk I/O performance problem on the primary DB instance, which is causing the high response time.