Your question is Distributed Systems and Concurrent DB Updates. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Tell me about your experience with distributed systems, especially what happens when multiple database updates happen at the same time.
Discuss how you reason about concurrent writes, consistency guarantees, transactions, isolation levels, conflicts, retries, and partial failures. Explain a practical approach you have used or would use, including how you would detect and recover from lost updates, deadlocks, duplicate operations, and stale reads.
