CompTIA Data+ (DA0-002)Data Concepts and EnvironmentsMedium
A data engineering team is designing a system to store configuration settings for a distributed microservices architecture. Each microservice requires flexible, schema-less storage for its unique settings, which often include nested structures and varying data types. Which database type is best suited for this requirement?
- ATime-Series Database
- BDocument Database
- CRelational Database
- DGraph Database
Show answer & explanationAnswer & explanation
Correct answer: B. Document Database
Document databases are ideal for storing semi-structured data like configuration settings, as they offer schema flexibility, support nested structures, and can accommodate varying data types within documents, aligning perfectly with the needs of a microservices architecture.
Why the other options are wrong
- A. Time-series databases are optimized for timestamped data, not general configuration settings.
- C. Relational databases enforce rigid schemas, which is unsuitable for flexible, schema-less configuration settings.
- D. Graph databases are designed for interconnected data, not typically for storing individual service configurations.
Document Database
A type of NoSQL database that stores data in flexible, semi-structured document formats (like JSON, BSON, or XML), rather than in tables with rigid schemas.
- Schema-less or flexible schema.
- Ideal for hierarchical, nested data.
- Scales horizontally.
- Examples: MongoDB, Couchbase, DocumentDB.
- Good for content management, catalogs, user profiles.
Memory trick: NoSQL: Key-Value, Document, Column, Graph – Flexible storage for different needs.