exam questions

Exam AWS Certified SysOps Administrator - Associate All Questions

View all questions & answers for the AWS Certified SysOps Administrator - Associate exam

Exam AWS Certified SysOps Administrator - Associate topic 1 question 328 discussion

A company is running production workloads that use a Multi-AZ deployment of an Amazon RDS for MySQL db.m6g.xlarge (general purpose) standard DB instance. Users report that they are frequently encountering a “too many connections” error. A SysOps administrator observes that the number of connections on the database is high.

The SysOps administrator needs to resolve this issue while keeping code changes to a minimum.

Which solution will meet these requirements MOST cost-effectively?

  • A. Modify the RDS for MySQL DB instance to a larger instance size.
  • B. Modify the RDS for MySQL DB instance to Amazon DynamoDB.
  • C. Configure RDS Proxy. Modify the application configuration file to use the RDS Proxy endpoint.
  • D. Modify the RDS for MySQL DB instance to a memory optimized DB instance.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
[Removed]
9 months, 4 weeks ago
C is correct.
upvoted 3 times
...
jlmadvig
10 months ago
Selected Answer: C
The correct answer is C The "too many connections" error indicates that the Amazon RDS for MySQL DB instance is reaching its maximum allowed connections, causing users to encounter issues. RDS Proxy is a highly recommended solution to manage database connections and improve scalability and availability. By implementing RDS Proxy and updating the application's configuration to use the proxy endpoint, you can effectively manage connections and alleviate the "too many connections" issue without making significant code changes.
upvoted 3 times
...
Pete987
10 months, 1 week ago
Selected Answer: C
C: too many connections” error - Answer is always RDS proxy
upvoted 3 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