At-least-once vs exactly-once delivery — why do we talk about idempotency?

Answer

With at-least-once delivery, a message can be delivered more than once (retries), so consumers must be idempotent (processing duplicates safely). Exactly-once is hard/expensive in practice, so idempotency is a common solution.