Exam AWS-SysOps All Questions

View all questions & answers for the AWS-SysOps exam

Exam AWS-SysOps topic 1 question 748 discussion

Exam question from Amazon's AWS-SysOps

Question #: 748
Topic #: 1

A company runs an application that uses Amazon RDS for MySQL. During load testing of equivalent production volumes, the Development team noticed a significant increase in query latency. A SysOps Administrator concludes from investigating Amazon CloudWatch Logs that the CPU utilization on the RDS MySQL instance was at 100%.
Which action will resolve this issue?

A. Configure AWS Database Migration Service (AWS DMS) to allow Amazon RDS for MySQL to scale and accept more requests.
B. Configure RDS for MySQL to scale horizontally by adding additional nodes to offload write requests.
C. Enable the Multi-AZ feature for the RDS instance.
D. Modify the RDS MySQL instance so it is a larger instance type.

Show Suggested Answer

Suggested Answer: D 🗳️

by AWS_Noob at April 17, 2020, 7:30 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

albert_kuo

1 year, 1 month ago

Selected Answer: D

High CPU utilization is often an indication that the existing resources allocated to the RDS instance are not sufficient to handle the workload. By modifying the RDS MySQL instance to a larger instance type, you provide it with more CPU resources, which can help alleviate the CPU bottleneck and reduce query latency.

upvoted 1 times

...

TroyMcLure

2 years, 10 months ago

Correct Answer: D

upvoted 1 times

...

RicardoD

2 years, 10 months ago

D is the answer

upvoted 1 times

...

abhishek_m_86

2 years, 10 months ago

D. Modify the RDS MySQL instance so it is a larger instance type.

upvoted 1 times

...

jackdryan

2 years, 10 months ago

I'll go with D

upvoted 1 times

...

rewiga

2 years, 11 months ago

While B also scales, we are dealing with query latency which is read and not write.

upvoted 1 times

shammous

2 years, 10 months ago

Query latency can be caused by read and write Queries

upvoted 1 times

...

jpt2353

2 years, 11 months ago

You can't scale RDS horizontally. Scaling horizontally meaning it would have a load balancer which isn't possible with RDS. Read Replicas should be a choice here but it's not, so the answer is D.

upvoted 4 times

shammous

2 years, 10 months ago

Scaling horizontally involve ASG not LB.

upvoted 3 times

MegatonN

2 years, 10 months ago

for a DB it's involve Read replicas and you modify your app to be able to use the RR for some "read only" queries

upvoted 1 times

HeliosABC

2 years, 10 months ago

Scale horizontal is mean read replica. But it must be offload read workload. So I select D. https://aws.amazon.com/blogs/database/scaling-your-amazon-rds-instance-vertically-and-horizontally/

upvoted 1 times

...

AWS_Noob

2 years, 11 months ago

D - Key words being CPU Utilization

upvoted 4 times

...