exam questions

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 251 discussion

A company has an automobile sales website that stores its listings in a database on Amazon RDS. When an automobile is sold, the listing needs to be removed from the website and the data must be sent to multiple target systems.
Which design should a solutions architect recommend?

  • A. Create an AWS Lambda function triggered when the database on Amazon RDS is updated to send the information to an Amazon Simple Queue Service (Amazon SQS) queue for the targets to consume.
  • B. Create an AWS Lambda function triggered when the database on Amazon RDS is updated to send the information to an Amazon Simple Queue Service (Amazon SQS) FIFO queue for the targets to consume.
  • C. Subscribe to an RDS event notification and send an Amazon Simple Queue Service (Amazon SQS) queue fanned out to multiple Amazon Simple Notification Service (Amazon SNS) topics. Use AWS Lambda functions to update the targets.
  • D. Subscribe to an RDS event notification and send an Amazon Simple Notification Service (Amazon SNS) topic fanned out to multiple Amazon Simple Queue Service (Amazon SQS) queues. Use AWS Lambda functions to update the targets.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
beedle
Highly Voted 3 years, 7 months ago
D makes complete sense. Think about it, you can have sale of diffrent types of cars happening simultaneously. For ex, toyota might have its own queue. Since RDS sends notification to SNS. IT HAS TO BE D. :) https://docs.aws.amazon.com/lambda/latest/dg/services-rds.html https://docs.aws.amazon.com/lambda/latest/dg/with-sns.html
upvoted 61 times
DS01
3 years, 5 months ago
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Integrating.Lambda.html#AuroraMySQL.Integrating.NativeLambda Does this link point to Answer A, let me know?
upvoted 1 times
...
lehoang15tuoi
3 years, 6 months ago
None of you actually bothered to look what kind of events that RDS can send... It won't send out notifications on data changes (CRUD). Only events related to the instance itself (like stopped instance or backup turned on etc) are available
upvoted 27 times
Tyler1LOL
3 years, 5 months ago
Think this person is right. Don't see any kind of Event Notification from RDS that would make D an option. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.Messages.html
upvoted 6 times
...
cloudwhizkid
2 years, 8 months ago
you are right, most of the folks upvoting here are not even bothering to check the facts by themselves.
upvoted 1 times
...
...
crazyaboutazure
3 years, 6 months ago
Must be D as Amazon RDS sends notifications to an Amazon Simple Notification Service (Amazon SNS) topic, which you can configure to invoke a Lambda function. https://docs.aws.amazon.com/lambda/latest/dg/services-rds.html
upvoted 2 times
...
awsnoobster
3 years ago
Agree with D, keyword is sent to multiple target so a typical fanout scenario.
upvoted 2 times
...
...
sctmp
Highly Voted 3 years, 7 months ago
A. You can't use Lambda directly with RDS, RDS sends the notification to SNS which then can trigger a lambda. Take a look https://docs.aws.amazon.com/lambda/latest/dg/services-rds.html B. Same as A. C. The RDS event notifications sends the notification using SNS not SQS. D. Sounds about right. You Subscribe to an RDS event notification which sends to SNS topic, which is fanned out to multiple Amazon SQS queues. Here is the problem, why would we need multiple queues? I'd take B, let's say that the lambda function is triggered by the SNS sent by the RDS event notification. And why FIFO? Since, we need it to happen only once, "when an automobile is sold". What do you guys think?
upvoted 14 times
DarthYoda
3 years, 7 months ago
It is D. we need multiple queues bc we need to send data to multiple target systems :)
upvoted 37 times
aguy9
3 years, 7 months ago
Yes agreed fan out requires that SNS push notifications to multiple SQS queues and then a consumer updates each target. In this case Lambda becomes the consumer which polls the SQS queues to update their relevant target
upvoted 7 times
...
wivoleb574
3 years, 4 months ago
There is no notification for database updates so CAN'T be D. See RDS notifications: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.Messages.html I'll go with B as FIFO is important if you sell something to prevent duplicate / oversell :-)
upvoted 5 times
...
...
...
fro13
Most Recent 1 year, 9 months ago
Selected Answer: D
D is correct
upvoted 1 times
...
BECAUSE
1 year, 10 months ago
Selected Answer: D
D is the answer
upvoted 1 times
...
Sachin032
2 years, 1 month ago
Selected Answer: D
First Two option AWS Lamdba is not required to monitor DB update.
upvoted 1 times
...
iNewbee
2 years, 3 months ago
I dont think the question is asking us to update the targets? Hence Ans: D is an over kill. Write a Lambda code to update the targets? Simple solution should be A or B. Since a car is sold only once and DB is updated only once, it will trigger a lambda only once (No need for FIFO). Hence I prefer Ans: A over B.
upvoted 2 times
...
alexsanteeno
2 years, 3 months ago
Selected Answer: D
Answer is D
upvoted 1 times
...
cloudwhizkid
2 years, 8 months ago
I think D is right as per below link RDS event notifications are sent out to SNS. https://docs.aws.amazon.com/lambda/latest/dg/services-rds.html
upvoted 1 times
...
cloud_collector
2 years, 8 months ago
Selected Answer: D
https://aws.amazon.com/blogs/aws/queues-and-notifications-now-best-friends/
upvoted 1 times
...
ravisar
2 years, 10 months ago
A is the Answer. RDS Event notification won't send notification in case of a data delete. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.Messages.html You can always use lambda to configure multiple SQS for multiple target systems
upvoted 1 times
...
reve666
2 years, 11 months ago
Selected Answer: D
Agree with D
upvoted 2 times
...
IamPapulalji
2 years, 11 months ago
ANS A: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL-Lambda.html Invoking an AWS Lambda function from an RDS for PostgreSQL DB instance
upvoted 1 times
...
IamPapulalji
2 years, 11 months ago
Ans A: As of March 15th 2022, you can invoke an AWS Lambda function only from PostgreSQL engine in RDS but not from MySQL engine. The documentation is provided below: Invoking an AWS Lambda function from an RDS for PostgreSQL DB instance You can also invoke an AWS Lambda function from either MySQL or PostgreSQL engines in Aurora (NOTE: Aurora is different AWS service from RDS). The documentation for both is provided below: Invoking an AWS Lambda function from an Aurora PostgreSQL DB cluster Invoking a Lambda function from an Amazon Aurora MySQL DB cluster
upvoted 1 times
...
spoty
2 years, 11 months ago
Selected Answer: A
RDS events are not for CURD operations. Follow below link. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.overview.html You can subscribe to an event category for the following resources: DB instance DB snapshot DB parameter group DB security group RDS Proxy Custom engine version
upvoted 3 times
...
mgari
3 years ago
Selected Answer: B
event notification is NOT for update
upvoted 1 times
...
FF11
3 years, 3 months ago
Selected Answer: D
D is correct. Please disregard my previous vote for A. – There is no way to directly trigger Lambda functions from Amazon RDS. – You can associate an SNS topic with Amazon RDS instance for notifications and then add that SNS topic as an event source to Lambda function https://docs.aws.amazon.com/lambda/latest/dg/services-rds.html – If you’re using AWS Aurora MySQL DB, you can invoke an AWS Lambda function from by calling the mysql.lambda_async procedure. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Integrating.Lambda.html that is why I’m jumping from answer A to answer D ! 7 Reply Leave a Reply Your email address will not be published. Comment Name Please enter an answer in digits: one × 4 = This site uses Akismet to reduce spam. Learn how your comment data is processed. VCEplus 10% OFF: 10HAPPY2022 (Code expires on Dec-24-2021) VCE to PDF Converter PDF file icons logo
upvoted 3 times
...
FF11
3 years, 3 months ago
Selected Answer: A
A is correct.
upvoted 2 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