AWS Certified Solutions Architect – Associate (SAA-C03) — Question 67

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?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A because creating an AWS Lambda function that triggers on updates to the Amazon RDS database allows for real-time processing of the data and sending it to an Amazon SQS queue for target systems to consume. Option B is incorrect because using a FIFO queue is unnecessary for this scenario. Options C and D involve more complex architectures that are not required for simply notifying and processing updates, making them less efficient.