DA0-002 Data Concepts and Environments Practice Question
A company ingests customer clickstream data from its website. The data arrives continuously in JSON format and must be stored for real-time analytics. Which type of data source is being described?
⚠ Common exam trap
CompTIA Data+ often tests the distinction between 'streaming data' and 'data warehouse' by describing continuous ingestion, leading candidates to mistakenly choose 'data warehouse' because they associate analytics with warehousing, ignoring the real-time requirement.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Streaming data
The description matches a streaming data source because clickstream data arrives continuously in JSON format and must be stored for real-time analytics. Streaming data sources, such as Apache Kafka or Amazon Kinesis, ingest unbounded data in real time, enabling immediate processing and analytics without batch delays.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Transactional database
Why it's wrong here
A transactional database records discrete business operations such as orders or payments, not continuous clickstream events. It is tempting because it is a live, queryable source, but it is designed for ACID transaction processing rather than high-volume streaming JSON ingestion.
- ✗
Flat file
Why it's wrong here
A flat file is static and batch-oriented, so it cannot represent a continuously arriving clickstream. It is tempting because JSON payloads are often stored as files, and flat files suit periodic bulk loads into analytics platforms, but streaming ingestion requires a source such as an API or message queue.
- ✗
Data warehouse
Why it's wrong here
A data warehouse is a storage and analytics destination, not an ingestion source, so it cannot describe the arriving clickstream itself. It is tempting because real-time analytics results often land in a warehouse, but the question asks about the origin of continuous JSON events.
- ✓
Streaming data
Why this is correct
Streaming data matches because the clickstream arrives continuously as discrete JSON events requiring real-time analytics, rather than being collected in scheduled batches. This satisfies the stem's ingestion constraint: an unbounded, ongoing flow of records processed as they arrive, distinguishing it from batch or static file sources.
About these practice questions
One of 1,004 original DA0-002 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DA0-002 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DA0-002 exam.