CompTIA DataSys+ (DS0-001) — Question 19

A database administrator is concerned about transactions in case the system fails. Which of the following properties addresses this concern?

Answer options

• A. Durability
• B. Isolation
• C. Atomicity
• D. Consistency

Correct answer: A

Explanation

The correct answer is A, Durability, as it ensures that once a transaction has been committed, it will remain so even in the event of a system failure. The other options focus on different aspects of transaction management: B (Isolation) deals with concurrent transactions, C (Atomicity) ensures transactions are all-or-nothing, and D (Consistency) guarantees that a transaction brings the database from one valid state to another.