Exam AWS Certified Solutions Architect - Associate SAA-C02 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C02 exam

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

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

Question #: 495
Topic #: 1

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

A company hosts an application on AWS Lambda functions that are invoked by an Amazon API Gateway API. The Lambda functions save customer data to an
Amazon Aurora MySQL database. Whenever the company upgrades the database, the Lambda functions fail to establish database connections until the upgrade is complete. The result is that customer data is not recorded for some of the event.
A solutions architect needs to design a solution that stores customer data that is created during database upgrades.
Which solution will meet these requirements?

A. Provision an Amazon RDS proxy to sit between the Lambda functions and the database. Configure the Lambda functions to connect to the RDS proxy.
B. Increase the run time of the Lambda functions to the maximum. Create a retry mechanism in the code that stores the customer data in the database.
C. Persist the customer data to Lambda local storage. Configure new Lambda functions to scan the local storage to save the customer data to the database.
D. Store the customer data in an Amazon Simple Queue Service (Amazon SQS) FIFO queue. Create a new Lambda function that polls the queue and stores the customer data in the database.

Show Suggested Answer

Suggested Answer: D 🗳️

by patriktre at Aug. 30, 2021, 5:06 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

GeniusMikeLiu

Highly Voted 3 years, 8 months ago

I agree with D. The point is not losing data. When database is upgrading, data still in the SQS.

upvoted 32 times

...

rb39

Highly Voted 3 years, 8 months ago

D - SQS maintains the data if the lambda function fails, RDS Proxy just reuses db connections for performance

upvoted 20 times

...

Moathov

Most Recent 2 years, 10 months ago

Selected Answer: D

Answer is D, holding the request is done by SQS

upvoted 1 times

...

naveenagurjara

2 years, 11 months ago

Selected Answer: D

RDA proxy needs a live DB such as a Standby DB during a failover of Primary DB.

upvoted 2 times

...

cutecolt

3 years, 1 month ago

Selected Answer: D

For database proxy, there is no storage available. only compute and memory capabilities are available. So, SQS will be right choice. https://aws.amazon.com/rds/proxy/

upvoted 2 times

...

mousedolly2002

3 years, 3 months ago

D, the description super confuses people.

upvoted 1 times

...

mikozy

3 years, 4 months ago

Absolutely D.

upvoted 1 times

...

Alexey79

3 years, 4 months ago

Ans: D NOT A: "You can't use RDS Proxy with Aurora Serverless clusters." https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/rds-proxy.html

upvoted 1 times

...

rlnd2000

3 years, 4 months ago

https://www.learnaws.org/2020/12/13/aws-rds-proxy-deep-dive/ RDS proxy can improve application availability in such a situation by waiting for the new database instance to be functional and maintaining any requests received from the application during this time. The end result is that the application is more resilient to issues with the underlying database. A From: AWS claims that RDS proxy improves failover times by 30-60%. These numbers seem to hold up based on tests like this.

upvoted 1 times

...

FF11

3 years, 5 months ago

Selected Answer: D

D is correct.

upvoted 2 times

...

wivoleb574

3 years, 5 months ago

Selected Answer: D

should be D

upvoted 2 times

...

Gomer

3 years, 6 months ago

The new lambda function needs to be smart enough to just poll the DB to see if it's up before it tries to more a message from the queue to the DB. This is what queues are built for. Only question I have is how to trigger lambda to poll the queue periodically. I don't know lambda, but I have supported MQ Series. This is how queues work.

upvoted 1 times

...

cannottellname

3 years, 6 months ago

The use of RDS Proxy is different, if database is not there (under an upgrade) then there is no use of RDS peoxy. Hence, A

upvoted 2 times

...

yottabyte

3 years, 7 months ago

B is correct; D can't be correct because Lambda will poll the user data from SQS but if it can't write the data to the database (because it is unavailable), then will the Lambda function return the data back to the SQL queue (like putting water back into the pipe??). The issue is to resolve if Lambda can't connect when the DB is getting upgraded, so a proxy RDS will address the issue.

upvoted 1 times

...

gary_gary

3 years, 7 months ago

I was confusing between C and D. Could someone explain why C is not correct?

upvoted 1 times

tinyshare

3 years, 6 months ago

Don't invent your own wheels while AWS already provides you the SQS.

upvoted 1 times

...

Raj1703

3 years, 7 months ago

D-- This will enable solution to hold data till the time DB comes back to normal. RDS proxy is to optimally utilize the connection between Lambda and DB. Lambda can open multiple connection concurrently which can be taxing on DB compute resources, hence RDS proxy was introduced to manage and leverage these connections efficiently.

upvoted 4 times

...

Jamati

3 years, 7 months ago

D - SQS

upvoted 3 times

...

Load full discussion...