ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 547 - SAP-C01 discussion

Report
Export

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.
Answers
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.
Answers
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.
Answers
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.
Answers
D.
It exhausted the network bandwidth available to the RDS for MySQL DB instance.
Suggested answer: C
asked 16/09/2024
Nicklas Magnusson
40 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first