CompTIA Data+ (DA0-002)Data Concepts and EnvironmentsMedium
A financial institution needs to store highly structured customer account information, including account numbers, balances, transaction history, and personal details. They require ACID properties to ensure data integrity during concurrent transactions. Which data environment is most appropriate for this requirement?
- ARelational Database
- BNoSQL Database
- CData Warehouse
- DData Lake
Show answer & explanationAnswer & explanation
Correct answer: A. Relational Database
Relational databases are designed for highly structured data, enforce ACID properties for transactional integrity, and are ideal for managing consistent, reliable customer account information.
Why the other options are wrong
- B. NoSQL databases are diverse, but many prioritize availability and partition tolerance over strong consistency (BASE properties) and are less suited for strict ACID requirements in financial transactions.
- C. Data warehouses are optimized for analytical queries on historical data, not for real-time transactional processing with strict ACID requirements.
- D. Data lakes store raw, unstructured data and do not inherently provide ACID properties or enforce strict schemas.
Relational Database
A type of database that stores and provides access to data points that are related to one another. Data is organized into tables (relations) with predefined schemas.
- Uses SQL for data manipulation and querying.
- Enforces ACID properties (Atomicity, Consistency, Isolation, Durability).
- Ideal for structured data and transactional applications.
Memory trick: Choosing the right data environment is like picking the right vault for your treasures: some are for raw goods, others for organized valuables, and some for high-security transactions.