AWS SAA-C03 #108

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.

---

Option D is the best choice.

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.

This design allows for high throughput, reliable delivery to multiple systems, and the ability to process messages in parallel. The use of Amazon SNS allows for the fanout scenario to multiple Amazon SQS queues, and AWS Lambda can be used to process the messages from the SQS queues to update the target systems. This ensures that all target systems are updated when an automobile is sold and the listing is removed from the website.

Please note that while AWS Lambda can be triggered by an Amazon RDS update, it’s not a recommended practice because it can lead to potential issues such as function throttling and longer execution times. Therefore, options A and B are not ideal. Option C is not feasible because Amazon SQS cannot fan out to multiple Amazon SNS topics.

Remember, it’s always important to choose a solution that ensures reliable delivery and suits your specific use case.