thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Foundational

ACID

The four properties of reliable transactions: Atomicity, Consistency, Isolation and Durability.

Definition

Atomicity means all or nothing, consistency means rules and constraints hold, isolation means concurrent transactions don't interfere, and durability means committed data survives failure. Relational databases provide ACID, and table formats such as Delta Lake and Iceberg bring ACID transactions to data lakes.

Exam tip

Delta Lake's key benefit over plain Parquet on a lake is ACID transactions; expect this on Databricks exams.

Related terms