CompTIA DataSys+ (DS0-001)Database DeploymentMedium
A data engineering team is deploying a new data lake solution that requires a database capable of storing vast amounts of unstructured and semi-structured data, with flexible schema capabilities. The primary access pattern will be retrieving entire documents or collections of documents based on various attributes. Which NoSQL database type is most suitable for this scenario?
- AKey-Value Store
- BColumn-Family Database
- CDocument Database
- DGraph Database
Show answer & explanationAnswer & explanation
Correct answer: C. Document Database
Document databases are designed to store semi-structured data (like JSON or BSON documents) with flexible schemas, making them ideal for data lakes with varied and evolving data types. They excel at retrieving entire documents based on attribute queries.
Why the other options are wrong
- A. Key-value stores are simple, offering fast lookups by key, but lack the flexible schema and rich querying capabilities needed for documents.
- B. Column-family databases are optimized for wide columns and aggregate queries over specific columns, not for retrieving entire flexible documents.
- D. Graph databases focus on relationships between entities, not on storing and querying large, flexible documents.
Document Database
A document database is a NoSQL database that stores data in flexible, semi-structured formats (e.g., JSON, BSON), allowing for dynamic schemas and efficient retrieval of entire documents or collections of documents based on their content.
- Stores data as documents (e.g., JSON).
- Flexible schema, ideal for evolving data.
- Efficient for retrieving entire documents.
- Suitable for content management, catalogs, user profiles.
Memory trick: If your data looks like a 'document' (JSON), use a Document Database.