I know delta tables are supporting the ACID properties and my understanding is Merge, Insert, delete, etc. are inside a transaction by default and if any error occurred during these operations, that transaction will be roll backed. I hope this understanding is correct, please confirm.

Another question is, as like in SQL Server, where we can specify explicit transaction blocks and inside that we can mention multiple transformation statements, as like

Begin Tran

Insert into Table 1

Update Table2

Delete Table3

Mreg table 4

End Tran

Is it possible to mention these kinds of explicit transaction blocks in the case of data bricks and delta tables?