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

Exam AWS Certified SysOps Administrator - Associate All Questions

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

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

Exam question from Amazon's AWS Certified SysOps Administrator - Associate
Question #: 8
Topic #: 1
[All AWS Certified SysOps Administrator - Associate Questions]

A company is running a serverless application on AWS Lambda. The application stores data in an Amazon RDS for MySQL DB instance. Usage has steadily increased, and recently there have been numerous "too many connections" errors when the Lambda function attempts to connect to the database. The company already has configured the database to use the maximum max_connections value that is possible.
What should a SysOps administrator do to resolve these errors?

  • A. Create a read replica of the database. Use Amazon Route 53 to create a weighted DNS record that contains both databases.
  • B. Use Amazon RDS Proxy to create a proxy. Update the connection string in the Lambda function.
  • C. Increase the value in the max_connect_errors parameter in the parameter group that the database uses.
  • D. Update the Lambda function's reserved concurrency to a higher value.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Azaad78 at April 23, 2021, 9:46 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
binhdt2611
Highly Voted 3 years, 3 months ago
Answer is B Check "Database proxy for Amazon RDS" section in the link to see how RDS proxy help Lambda handle huge connections to RDS MySQL https://aws.amazon.com/blogs/compute/using-amazon-rds-proxy-with-aws-lambda/
upvoted 18 times
...
jkwek
Highly Voted 4 months, 1 week ago
Answer is B. https://aws.amazon.com/blogs/compute/using-amazon-rds-proxy-with-aws-lambda/ RDS Proxy acts as an intermediary between your application and an RDS database. RDS Proxy establishes and manages the necessary connection pools to your database so that your application creates fewer database connections. Your Lambda functions interact with RDS Proxy instead of your database instance. It handles the connection pooling necessary for scaling many simultaneous connections created by concurrent Lambda functions. This allows your Lambda applications to reuse existing connections, rather than creating new connections for every function invocation.
upvoted 15 times
...
Dinya_jui
Most Recent 1 month ago
Selected Answer: B
RDS proxy for connections management with AWS Lambda. https://aws.amazon.com/blogs/compute/using-amazon-rds-proxy-with-aws-lambda/
upvoted 1 times
...
james2033
11 months, 1 week ago
Selected Answer: B
RDS proxy for connections management with AWS Lambda.
upvoted 1 times
...
NAVADIYA
1 year, 3 months ago
B. Use Amazon RDS Proxy to create a proxy. Update the connection string in the Lambda function.
upvoted 1 times
...
CVDON
1 year, 12 months ago
B. Improve efficiency in connection management and reuse
upvoted 1 times
...
michaldavid
2 years, 2 months ago
Selected Answer: B
bbbbbbbbbbb
upvoted 1 times
...
Finger41
2 years, 9 months ago
Selected Answer: B
B - https://aws.amazon.com/blogs/compute/using-amazon-rds-proxy-with-aws-lambda/ Solution straight out of the docs.....
upvoted 3 times
...
pglag
2 years, 10 months ago
Selected Answer: B
its B for sure
upvoted 2 times
...
mmmmm12451
2 years, 10 months ago
Selected Answer: B
B for sure
upvoted 2 times
...
VTHOR
2 years, 11 months ago
B, for sure
upvoted 1 times
...
roka_ua
2 years, 11 months ago
Selected Answer: B
Should be B
upvoted 1 times
...
MrkJobs
3 years, 1 month ago
Selected Answer: B
B "You can use RDS Proxy for any application that makes SQL calls to your database. But in the context of serverless, we focus on how this improves the Lambda experience. The proxy handles all database traffic that normally flows from your Lambda functions directly to the database." https://aws.amazon.com/blogs/compute/using-amazon-rds-proxy-with-aws-lambda/
upvoted 3 times
...
doc_nta
3 years, 1 month ago
Answer is B
upvoted 1 times
...
nqthien041292
3 years, 2 months ago
Selected Answer: B
Vote B
upvoted 2 times
...
lei00
3 years, 3 months ago
I think the answer should be B. D -- the concurrency is more towards the services invoke Lambda, instead of the question here "too many connections to RDS" https://aws.amazon.com/tw/blogs/compute/managing-aws-lambda-function-concurrency/
upvoted 2 times
...
Azaad78
3 years, 4 months ago
D - I think. Cause Lamdas are writing to RDS. Read replica are only for reading. https://docs.aws.amazon.com/lambda/latest/dg/configuration-concurrency.html This doc shows that Lamda's concurrent behavior can be limited.
upvoted 1 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