CompTIA Data+ DA0-002 (V2) Practice Question

A non-relational (NoSQL) document database is designed to ingest and query JSON-like documents that may differ in structure, so it handles the rapidly evolving clickstream schema without costly ALTER TABLE operations. Document stores also include built-in sharding and replication, letting the system scale horizontally across commodity nodes to keep pace with unpredictable surges in event volume. Relational databases impose a fixed schema and usually scale vertically, making them harder to adapt and distribute for this workload. In-memory OLAP cubes are optimized for aggregated analytical queries on pre-processed data, not for high-velocity operational writes. Spreadsheets (even when saved as CSV files) lack transactional guarantees, concurrency controls and distributed scalability, so they cannot serve as a reliable clickstream data store.