Choose the concurrency primitives and justify vs alternatives:

- optimistic concurrency (version column) vs SELECT ... FOR UPDATE vs advisory locks vs distributed lock (Redis Redlock caveats). - outbox pattern for atomic DB+publish; inbox pattern for idempotent consume. 3. Define idempotency key, dedup window/table, and exactly-once-effect semantics.