Microsoft Azure Data FundamentalsDescribe core data conceptsMedium
A financial institution needs to store customer transaction records securely. Each record includes a transaction ID, customer ID, date, amount, and transaction type. The institution requires strict data consistency, atomicity, isolation, and durability (ACID properties) for all transactions. Which data model is MOST appropriate for this requirement?
- ARelational Data Model
- BKey-Value Data Model
- CGraph Data Model
- DDocument Data Model
Show answer & explanationAnswer & explanation
Correct answer: A. Relational Data Model
The Relational Data Model inherently supports strict ACID properties and is designed for structured data with clear relationships, which is essential for financial transactions.
Why the other options are wrong
- B. Key-value models are too simple and lack the complex query and ACID properties needed for financial transactions.
- C. Graph models focus on relationships, not the primary need for structured financial transactions with ACID.
- D. Document models offer flexibility but often sacrifice strict ACID compliance for scalability.
Relational Data Model
Organizes data into one or more tables (relations) of rows and columns, with predefined schemas and strong consistency.
- Enforces data integrity through schemas, primary keys, and foreign keys.
- Provides ACID (Atomicity, Consistency, Isolation, Durability) properties.
- Uses SQL for querying and data manipulation.
Memory trick: Relational Ensures Reliability for Records