What should a Database Specialist do in this situation to increase performance and return latency to sub- second levels?

An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its allocated IOPS over the course of several hours under constant load. The RDS instance exhibits multi-second read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less than half of its CPU and RAM resources.

What should a Database Specialist do in this situation to increase performance and return latency to sub- second levels?
A . Increase the size of the DB instance storage
B . Change the underlying EBS storage type to General Purpose SSD (gp2)
C . Disable EBS optimization on the DB instance
D . Change the DB instance to an instance class with a higher maximum bandwidth

View Answer

Answer: D

Explanation:

https://docs.amazonaws.cn/en_us/AmazonRDS/latest/UserGuide/CHAP_BestPractices.html