AWS Certified Solutions Architect – Associate (SAA-C02) — Question 220

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: D

Explanation

The correct answer is D because using an SNS topic allows for fan-out messaging to multiple SQS queues, which helps distribute the data efficiently to various targets. Options A and B are incorrect as they do not utilize the benefits of SNS for multiple target systems. Option C, while it involves SNS, incorrectly suggests that data is sent to SQS queues instead of using SNS for distribution.