Exam AWS Certified Developer Associate topic 1 question 358 discussion

Exam question from Amazon's AWS Certified Developer Associate

Question #: 358
Topic #: 1

[All AWS Certified Developer Associate Questions]

A developer has created an AWS Lambda function that interacts with an Amazon Aurora MySQL database. The Lambda function makes queries to the database. After a performance test for the Lambda function, the database starts to show an error for too many connections.

Which solution will solve this problem with the LEAST operational effort?

A. Create a road replica for the database. Query the replica database instead of the primary database.
B. Migrate the data to an Amazon DynamoDB database.
C. Sot a limit to the Lambda function's concurrency.
D. Create a proxy in Amazon RDS Proxy. Query the proxy instead of the database.

Show Suggested Answer

Suggested Answer: D 🗳️

by DrCloud at Nov. 27, 2022, 6:14 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

Submit Cancel

DrCloud

Highly Voted 2 years, 6 months ago

Selected Answer: D

Error: too many connections Ask: LEAST operational effort? https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Performance.html If your applications frequently open and close connections, or keep a large number of long-lived connections open, we recommend that you use Amazon RDS Proxy. RDS Proxy is a fully managed, highly available database proxy that uses connection pooling to share database connections securely and efficiently.

upvoted 8 times

...

Millie024

Most Recent 1 year, 8 months ago

I think D https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-proxy-planning.html| "Any DB instance that encounters "too many connections" errors is a good candidate for associating with a proxy. This is often characterized by a high value of the ConnectionAttempts CloudWatch metric. The proxy enables applications to open many client connections, while the proxy manages a smaller number of long-lived connections to the DB instance ."

upvoted 1 times

...

mistral

2 years, 4 months ago

C. Set a limit to the Lambda function's concurrency. Setting a limit to the Lambda function's concurrency can prevent the function from overloading the database by limiting the number of simultaneous connections the function can make to the database. This solution requires the least operational effort compared to the other solutions, as it only involves adjusting the configuration of the Lambda function. However, this solution may also result in decreased performance for the Lambda function, as limiting concurrency can limit its ability to parallelize requests to the database.

upvoted 1 times

mistral

2 years, 4 months ago

Here are the configuration steps for both solutions: C. Set a limit to the Lambda function's concurrency: In the AWS Management Console, open the AWS Lambda function that interacts with the Amazon Aurora MySQL database. In the Configuration section, go to the Advanced settings. Under Concurrency, set a limit on the maximum number of invocations that can run concurrently. Save the changes to the Lambda function configuration.

upvoted 1 times

mistral

2 years, 4 months ago

D. Create a proxy in Amazon RDS Proxy: Create an Amazon RDS database instance for the Aurora database. Create an Amazon RDS Proxy for the database instance. Modify the connection string used by the Lambda function to connect to the database to use the Amazon RDS Proxy endpoint. Modify the IAM role used by the Lambda function to allow access to the Amazon RDS Proxy. Test the Lambda function to ensure that it can connect to the database using the Amazon RDS Proxy.

upvoted 1 times

mistral

2 years, 4 months ago

D. Create a proxy in Amazon RDS Proxy. Query the proxy instead of the database. Creating a proxy in Amazon RDS Proxy can help alleviate the error for too many connections by managing and optimizing the connections to the database. Amazon RDS Proxy can automatically manage the connection pool for the Lambda function, reducing the number of connections required and improving the performance of the database. This solution requires slightly more operational effort compared to setting a limit on the Lambda function's concurrency, but can result in better performance for the Lambda function as it allows it to make more efficient use of the database connections.

upvoted 1 times

...

ccna_imperathor

2 years, 4 months ago

Selected Answer: A

A: Read Replica "You can issue queries to them to scale the read operations for your application. You typically do so by connecting to the reader endpoint of the cluster. That way, Aurora can spread the load for read-only connections across as many Aurora Replicas as you have in the cluster." https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Replication.html

upvoted 3 times

...

michaldavid

2 years, 6 months ago

Selected Answer: D

Use proxy D

upvoted 2 times

...