exam questions

Exam AWS Certified Solutions Architect - Professional All Questions

View all questions & answers for the AWS Certified Solutions Architect - Professional exam

Exam AWS Certified Solutions Architect - Professional topic 1 question 676 discussion

An ecommerce website running on AWS uses an Amazon RDS for MySQL DB instance with General Purpose SSD storage. The developers chose an appropriate instance type based on demand, and configured 100 GB of storage with a sufficient amount of free space.
The website was running smoothly for a few weeks until a marketing campaign launched. On the second day of the campaign, users reported long wait times and time outs. Amazon CloudWatch metrics indicated that both reads and writes to the DB instance were experiencing long response times. The CloudWatch metrics show 40% to 50% CPU and memory utilization, and sufficient free storage space is still available. The application server logs show no evidence of database connectivity issues.
What could be the root cause of the issue with the marketing campaign?

  • A. It exhausted the I/O credit balance due to provisioning low disk storage during the setup phase.
  • B. It caused the data in the tables to change frequently, requiring indexes to be rebuilt to optimize queries.
  • C. It exhausted the maximum number of allowed connections to the database instance.
  • D. It exhausted the network bandwidth available to the RDS for MySQL DB instance.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
bbnbnuyh
Highly Voted 3 years, 7 months ago
A. 100G GP2 is going to give roughtly 300 IOPS which is too low
upvoted 27 times
Cantaloupe
3 years, 7 months ago
Yes. There is burst option but it can be exhausted "When using General Purpose SSD storage, your DB instance receives an initial I/O credit balance of 5.4 million I/O credits. This initial credit balance is enough to sustain a burst performance of 3,000 IOPS for 30 minutes."
upvoted 6 times
...
...
Ebi
Highly Voted 3 years, 7 months ago
Answer is A, Key is "on the second day", so all the credit have been used by then
upvoted 11 times
...
5kk
Most Recent 2 years, 9 months ago
Selected Answer: A
A looks good.
upvoted 1 times
...
pankajrawat
3 years ago
Selected Answer: A
A looks good
upvoted 1 times
...
AzureDP900
3 years, 5 months ago
A is right
upvoted 1 times
...
backfringe
3 years, 5 months ago
I'd go with A
upvoted 1 times
...
AzureDP900
3 years, 5 months ago
Before even reading answers my best bet was A. I am with you guys, I am not sure why they want to fool us with C. This is one of the reason knowing concepts is very important rather than depending on answers :)
upvoted 1 times
Cal88
2 years, 6 months ago
An easy way to eliminate C is to read the question carefully “The application server logs show no evidence of database connectivity issues.“ So there are no connectivity issues I really hope that I read the questions carefully in my exam and not jump to any conclusions quickly
upvoted 2 times
...
...
acloudguru
3 years, 5 months ago
Selected Answer: A
There is burst option but it can be exhausted "When using General Purpose SSD storage, your DB instance receives an initial I/O credit balance of 5.4 million I/O credits. This initial credit balance is enough to sustain a burst performance of 3,000 IOPS for 30 minutes."
upvoted 1 times
...
andylogan
3 years, 6 months ago
It's A - exhausted all its initial I/O credits on the second day
upvoted 1 times
...
tgv
3 years, 6 months ago
AAA ---
upvoted 1 times
...
blackgamer
3 years, 6 months ago
A is the answer.
upvoted 1 times
...
jobe42
3 years, 6 months ago
A Emerging similar happened Touch us.. So I've learned shout EBS burstable balance
upvoted 1 times
...
WhyIronMan
3 years, 6 months ago
I'll go with A
upvoted 1 times
...
mustpassla
3 years, 6 months ago
A, a typical SAP IOPS related question
upvoted 1 times
...
Waiweng
3 years, 7 months ago
it's A
upvoted 3 times
...
Kian1
3 years, 7 months ago
going with A
upvoted 3 times
...
Bulti
3 years, 7 months ago
A is the right answer. It must have exhausted all its I/O credits due to the marketing event and now operates with 300 IOPS which is pretty low for that event.
upvoted 2 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago