An application expects each customer order and payment record to update atomically within the chosen database's supported transaction model. Which approach best fits?

1. Use a database transaction covering the required consistency boundary.
2. Use a cache with explicit invalidation or expiration rules.
3. Redesign row keys to distribute writes while preserving required access patterns.
4. Evaluate an appropriate index using the query plan and write-cost tradeoff.