Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 790 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C02

Question #: 790
Topic #: 1

[All AWS Certified Solutions Architect - Associate SAA-C02 Questions]

A company has an event-driven application that invokes AWS Lambda functions up to 800 times each minute with varying runtimes. The Lambda functions access data that is stored in an Amazon Aurora MySQL DB cluster. The company is noticing connection timeouts as user activity increases. The database shows no signs of being overloaded. CPU, memory, and disk access metrics are all low.
Which solution will resolve this issue with the LEAST operational overhead?

A. Adjust the size of the Aurora MySQL nodes to handle more connections. Configure retry logic in the Lambda functions for attempts to connect to the database.
B. Set up Amazon ElastiCache for Redis to cache commonly read items from the database. Configure the Lambda functions to connect to ElastiCache for reads.
C. Add an Aurora Replica as a reader node. Configure the Lambda functions to connect to the reader endpoint of the DB cluster rather than to the writer endpoint.
D. Use Amazon RDS Proxy to create a proxy. Set the DB cluster as the target database. Configure the Lambda functions to connect to the proxy rather than to the DB cluster.

Show Suggested Answer

Suggested Answer: D 🗳️

by sivasumanth at Oct. 8, 2022, 1:07 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

sivasumanth

Highly Voted 2 years, 10 months ago

Selected Answer: D

To reduce the no of connections Use RDS proxy D is the correct answer.

upvoted 7 times

...

mahesh_raju

Most Recent 1 year, 8 months ago

Selected Answer: C

This option allows read traffic to be redirected to a separate Aurora Replica, offloading the primary database and potentially resolving the connection timeouts without introducing much operational complexity.

upvoted 1 times

...

BECAUSE

2 years, 2 months ago

Selected Answer: D

D is the answer

upvoted 1 times

...

ironbat

2 years, 4 months ago

Selected Answer: D

Agree with D, problem only with connection, no sign of DB overloaded

upvoted 1 times

...

Ruby_Song

2 years, 8 months ago

D is right. 1. database shows no signs of being overloaded. CPU, memory, and disk access metrics are all low==>A and C out. We cannot only add nodes instance or add read replica, because database workload is totally fine, very low. 2. "least operational overhead"==>B out, because b need to configure lambda. 3. ROS proxy: Shares infrequently used connections; High availability with failover; Drives increased efficiency==>proxy can leverage failover to redirect traffic from timeout rds instance to healthy rds instance. So D is right.

upvoted 1 times

...