The take home test uses SQLite which has table level locking on reads and writes so no further locking is needed. But for a production-ready database like PostgreSQL or MSSQL, you'll utilize an exclusive lock on the database rows you are interacting with, especially in regards to financial data.