Microsoft Azure Data FundamentalsDescribe core data conceptsEasy
A financial institution needs to store customer transaction records securely. Each record includes a transaction ID, customer ID, amount, and date. The data must be stored in a way that ensures data integrity and allows for complex queries involving joins between customer and transaction tables. Which data model is most appropriate?
- ARelational Data Model
- BGraph Data Model
- CKey-Value Data Model
- DDocument Data Model
Show answer & explanationAnswer & explanation
Correct answer: A. Relational Data Model
The relational data model is best suited for structured data with clear relationships between entities, ensuring data integrity through schemas and supporting complex queries with joins.
Why the other options are wrong
- B. Graph models focus on relationships between entities, but for structured transaction data with integrity needs, relational is more appropriate.
- C. Key-value models are simple and fast for direct lookups but lack support for complex queries and joins.
- D. Document models are flexible for semi-structured data but less ideal for strict integrity and relational queries.
Relational Data Model
A data model that organizes data into tables (relations) with rows and columns, enforcing relationships through primary and foreign keys.
- Uses tables, rows, columns
- Enforces data integrity with schemas
- Supports complex queries and joins
Memory trick: Relationships are key in the relational model, like family relations.