What is a common mistake with Amazon SQS and SNS in AWS?

Assuming messages are processed exactly once, ignoring visibility timeout and DLQs, or choosing SNS when durable queueing is required can create message loss or duplication problems.