Your question is Database Locking Optimization. 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).
Given a scenario where a database acquires a write lock every 15 minutes and is read-heavy, acquiring a read lock every 30 seconds, how would you optimize the locking mechanism?
Asked in the managerial round stage. Explain how you would reduce contention while preserving correctness, including the information you would measure before changing the design.