Answer – D
Option A is INCORRECT since scheduling automatic back-ups in non-working hours will help reduce the high latency that the user is experiencing. The question is asking for a NOT option. Therefore this option is incorrect.
Option B is INCORRECT because using a larger or a higher instance size will reduce the latency due to the multi-AZ feature.
Option C is INCORRECT because using the provisioned IOPS, the users would get high throughput from the DB instance. The question is asking for a NOT option. Therefore this option is incorrect.
Option D is CORRECT because taking a snapshot from a standby replica would not help to reduce the latency.
###########################
Amazon RDS Basic Operational Guidelines
The following are basic operational guidelines that everyone should follow when working with Amazon RDS. Note that the Amazon RDS Service Level Agreement requires that you follow these guidelines.
Monitor your memory, CPU, and storage usage. Amazon CloudWatch can be set up to notify you when usage patterns change or when you approach your deployment capacity so that you can maintain system performance and availability.
Scale up your DB instance when you are approaching storage capacity limits. You should have some buffer in storage and memory to accommodate unforeseen increases in demand from your applications.
Enable automatic backups and set the backup window to occur during the daily low in write IOPS.
If your database workload requires more I/O than you have provisioned, recovery after a failover or database failure will be slow. To increase the I/O capacity of a DB instance, do any or all of the following:
Migrate to a DB instance class with High I/O capacity.
Convert from standard storage to either General Purpose or Provisioned IOPS storage, depending on how much of an increase you need. For information on available storage types, see Amazon RDS Storage Types.
If you convert to Provisioned IOPS storage, make sure you also use a DB instance class that is optimized for Provisioned IOPS. For information on Provisioned IOPS, see Provisioned IOPS SSD Storage.
If you are already using Provisioned IOPS storage, provision additional throughput capacity.
###########################
For more information on Multi-AZ RDS, please visit the link:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_BestPractices.html