You run a web application with the following components Elastic Load Balancer (EL8), 3 Web/Application
servers, 1 MySQL RDS database with read replicas, and Amazon Simple Storage Service (Amazon S3) for static
content. Average response time for users is increasing slowly.
What three CloudWatch RDS metrics will allow you to identify if the database is the bottleneck? Choose 3
answers
A.
The number of outstanding IOs waiting to access the disk.
B.
The amount of write latency.
C.
The amount of disk space occupied by binary logs on the master.
D.
The amount of time a Read Replica DB Instance lags behind the source DB Instance
E.
The average number of disk I/O operations per second.
http://docs.aws.amazon.com/AmazonCloudWatch/latest/DeveloperGuide/rds-metricscollected.html
A,B,D
E is not a metric
C is not a metric
0
0
Chef, E is a metric. It states may be about the Read IOPS or Write IOPS. Here, the key term is average response time the A, B, D suit much for this scenario.
0
0
abd
0
0
https://www.datadoghq.com/blog/monitoring-rds-mysql-performance-metrics/
0
0
C is a disk space used metric, not a performance metric:
BinLogDiskUsage
The amount of disk space occupied by binary logs on the master. Applies to MySQL read replicas.
Units: Byte
E can be either ReadIOPS or WriteIOPS, too vague for the question, thus incorrect
A is DiskQueueDepth, it goes on the list of correct answers:
DiskQueueDepth
The number of outstanding IOs (read/write requests) waiting to access the disk.
Units: Count
B is WriteLatency, it goes not the list of correct answers:
WriteLatency
The average amount of time taken per disk I/O operation.
Units: Second
D is ReplicaLag, it goes on the list
ABD
0
0