ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS-SysOps All Questions

View all questions & answers for the AWS-SysOps exam
Go to Exam

Exam AWS-SysOps topic 1 question 748 discussion

Exam question from Amazon's AWS-SysOps
Question #: 748
Topic #: 1
[All AWS-SysOps Questions]

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
albert_kuo
9 months, 3 weeks 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, 6 months ago
Correct Answer: D
upvoted 1 times
...
RicardoD
2 years, 6 months ago
D is the answer
upvoted 1 times
...
abhishek_m_86
2 years, 6 months ago
D. Modify the RDS MySQL instance so it is a larger instance type.
upvoted 1 times
...
jackdryan
2 years, 6 months ago
I'll go with D
upvoted 1 times
...
rewiga
2 years, 7 months ago
While B also scales, we are dealing with query latency which is read and not write.
upvoted 1 times
shammous
2 years, 7 months ago
Query latency can be caused by read and write Queries
upvoted 1 times
...
jpt2353
2 years, 7 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, 7 months ago
Scaling horizontally involve ASG not LB.
upvoted 3 times
MegatonN
2 years, 6 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, 6 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, 7 months ago
D - Key words being CPU Utilization
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago