Databricks Data Engineer Associate Question 235
Select 3You are working with a Delta Lake table in Databricks, and your team needs to ensure that all transactions on the table are ACID-compliant. Which of the following characteristics must the table support to fulfill the ACID properties?
- A
Transactions must be atomic, meaning either all operations succeed or none of them do.
- B
The table must support eventual consistency so that updates are visible after some delay.
- C
The table must maintain a consistent state after each transaction, following defined constraints and rules.
- D
The system must ensure that committed transactions are durable, even in the event of a system failure.
- E
The table must allow uncommitted data to be visible to other users to improve performance.
Show answer and explanation
Correct answers: A, C, D
Explanation
ACID compliance requires that a database or table ensures Atomicity, Consistency, Isolation, and Durability. Delta Lake in Databricks is ACID-compliant because it supports atomic transactions, enforces consistency through constraints, ensures isolation by not exposing uncommitted data, and provides durability by writing to storage in a fault-tolerant manner. Eventual consistency and visibility of uncommitted data are not part of ACID-compliance.
- A. Correct.
Atomicity ensures that a transaction is all-or-nothing, which is critical for ACID compliance.
- B. Incorrect.
Eventual consistency is not part of ACID compliance. ACID requires immediate consistency after a transaction.
- C. Correct.
Consistency ensures that the database remains in a valid state after a transaction, which is a core ACID property.
- D. Correct.
Durability guarantees that once a transaction is committed, the changes are permanent, even in case of a failure, which is an essential ACID property.
- E. Incorrect.
Allowing uncommitted data to be visible violates isolation, which is a key ACID property.