CompTIA Data+ (DA0-002)Data Concepts and EnvironmentsHard
A data engineering team is migrating a legacy system's configuration files. These files contain highly structured data, organized into tables with predefined columns and rows, and enforce strict relationships between different configuration entities using foreign keys. The team needs a modern solution that maintains data integrity, supports complex queries, and ensures ACID properties. Which database type is BEST suited for this migration?
- AKey-Value Store
- BGraph Database
- CDocument Database
- DRelational Database
Show answer & explanationAnswer & explanation
Correct answer: D. Relational Database
The description 'highly structured data', 'tables with predefined columns and rows', 'strict relationships using foreign keys', and the need for 'data integrity' and 'ACID properties' are all hallmarks of a relational database. It is explicitly designed for such structured data models and ensures transactional consistency.
Why the other options are wrong
- A. Key-value stores are too simple for highly structured data with complex relationships and integrity constraints.
- B. Graph databases are for complex relationships but don't typically enforce rigid table structures or ACID properties as strongly as relational databases.
- C. Document databases are for flexible, semi-structured data, not for strict table structures and foreign keys.
Relational Database
A database that stores and provides access to data points that are related to one another. It's based on the relational model, organizing data into tables with predefined schemas and enforcing relationships via foreign keys.
- Data organized into tables (relations) with rows and columns.
- Enforces strict schemas and data integrity (e.g., foreign keys).
- Supports ACID properties (Atomicity, Consistency, Isolation, Durability).
- Uses SQL for querying and manipulation.
Memory trick: Relational is rigid, document is flexible, key-value is simple, graph is connected.