Welcome to Westonci.ca, the Q&A platform where your questions are met with detailed answers from experienced experts. Discover comprehensive solutions to your questions from a wide network of experts on our user-friendly platform. Explore comprehensive solutions to your questions from a wide range of professionals on our user-friendly platform.

An application is inserting records in a DynamoDB (eventually consistent) and also pushing the corresponding messages to SQS. What is the most optimum solution to handle the following scenario?
1. Application creates the record in DynamoDB
2. The application pushes the message to SQS
3. The SQS consumer pulls the message
4. SQS consumer fails to find the message in DynamoDB