CompTIA DataSys+ (DS0-001)Database DeploymentEasy
A database administrator is performing pre-deployment validation for a new critical financial application. The application requires that all database transactions are processed reliably, maintaining data consistency even in the event of system failures. Which set of properties must the underlying database system adhere to to meet this requirement?
- ABASE properties (Basically Available, Soft state, Eventual consistency)
- BACID properties (Atomicity, Consistency, Isolation, Durability)
- CCAP theorem (Consistency, Availability, Partition tolerance)
- DRDBMS principles (Relational, Data integrity, Backup, Security)
Show answer & explanationAnswer & explanation
Correct answer: B. ACID properties (Atomicity, Consistency, Isolation, Durability)
ACID properties (Atomicity, Consistency, Isolation, Durability) are fundamental guarantees that ensure reliable processing of database transactions, maintaining data integrity and consistency even through failures, which is critical for financial applications.
Why the other options are wrong
- A. BASE properties are associated with NoSQL databases, prioritizing availability and partition tolerance over strict consistency, which is unsuitable for financial transactions requiring strong consistency.
- C. CAP theorem describes trade-offs in distributed systems, but ACID is the specific set of properties for individual transaction reliability, not the high-level system design trade-offs.
- D. RDBMS principles are broad database design concepts; ACID properties are the specific guarantees for transaction reliability within an RDBMS.
ACID Properties
A set of properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable processing of database transactions.
- Atomicity: All or nothing for a transaction.
- Consistency: Transaction takes database from one valid state to another.
- Isolation: Concurrent transactions execute independently.
- Durability: Committed transactions persist even after system failures.
Memory trick: ACID: All transactions must be Strong.