What are ACID Transactions?
An ACID transaction secures that either all changes are successfully committed or rollbacked. It makes sure you never end in an inconsistent state. There is different concurrency control that, for example, guarantees consistency between reads and writes. Each Data Lake Table Format has other implementations and features here.