CompTIA DataSys+ (DS0-001)Database DeploymentEasy
A company is deploying a new database system to support a high-transaction e-commerce platform. The database must maintain atomicity, consistency, isolation, and durability (ACID) properties. Which of the following database models is typically chosen for such requirements?
- ARelational Database
- BKey-Value Store
- CGraph Database
- DDocument Database
Show answer & explanationAnswer & explanation
Correct answer: A. Relational Database
Relational databases are specifically designed to enforce ACID properties, which are crucial for transactional integrity in systems like e-commerce. Their structured nature and transaction management capabilities ensure data reliability.
Why the other options are wrong
- B. Key-value stores are schema-less and often prioritize availability and partition tolerance over strict ACID compliance.
- C. Graph databases excel at relationships between data points but are not primarily designed for strict ACID transactional integrity across the entire dataset.
- D. Document databases are flexible and schema-less, suitable for unstructured data, but typically offer weaker ACID guarantees than relational databases.
ACID Properties
ACID is an acronym defining a set of properties that guarantee valid transactions in a database: Atomicity, Consistency, Isolation, Durability.
- Atomicity: All operations in a transaction either succeed or fail as a whole.
- Consistency: A transaction brings the database from one valid state to another.
- Isolation: Concurrent transactions execute without interfering with each other.
- Durability: Once a transaction is committed, its changes are permanent, even in case of system failure.
Memory trick: ACID is best friends with the 'R' in Relational.