DP-900 Describe core data concepts Practice Question
A retail company captures real-time clickstream data from its website. They need to store this data for immediate analysis using KQL. Which Azure service should they use?
⚠ Common exam trap
A common mix-up: candidates confuse Azure Stream Analytics (a processing service) with Azure Data Explorer (a storage and query service), but the question specifically requires storing data for immediate KQL analysis, which Stream Analytics cannot do natively.
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
✓
Azure Data Explorer
Azure Data Explorer (ADX) is optimized for interactive analytics on large volumes of streaming and high-velocity data, supporting Kusto Query Language (KQL) for real-time queries. It ingests clickstream data with low latency and provides immediate analysis capabilities, making it the correct choice for this scenario.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Azure Stream Analytics
Why it's wrong here
Azure Stream Analytics is a real-time event-processing engine that consumes streams and writes results to output sinks like Event Hubs, Power BI, or Azure Data Explorer. It performs continuous transformations and aggregations, but it does not natively store data for interactive KQL queries—its query model is SQL-like, not Kusto Query Language, so it is the wrong service for directly analyzing clickstream data with KQL.
- ✗
Azure Cosmos DB
Why it's wrong here
Azure Cosmos DB is a globally distributed, multi-model NoSQL database designed for schema-agnostic transactional workloads, offering low-latency point reads and writes via APIs such as SQL, MongoDB, and Cassandra. While it can persist clickstream JSON documents, it does not support Kusto Query Language, and its storage engine is optimized for operational data rather than high-velocity time-series analytics, making it unsuitable for real-time clickstream KQL queries.
- ✓
Azure Data Explorer
Why this is correct
Azure Data Explorer (ADX) is a fast, fully managed analytics database built specifically for real-time exploration of streaming telemetry and clickstream data. It natively supports Kusto Query Language (KQL), which provides rich time-series operators, pattern matching, and anomaly detection, and its append-only columnar storage handles high ingestion volumes while remaining instantly queryable—exactly what the retail scenario requires.
- ✗
Azure SQL Database
Why it's wrong here
Azure SQL Database is a relational database management system with ACID guarantees, designed for OLTP workloads like transactional applications and reporting. It uses T-SQL as its query language, not KQL, and its row-based storage, index maintenance, and lock management are poorly suited to ingesting and retaining a continuous firehose of clickstream events without degrading performance or requiring substantial manual partitioning.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Data
Data is raw, unprocessed information, like numbers, words, or measurements, that can be stored, processed, and analyzed by computers.
Key term
Service
A service is a software component or system that performs a specific function and is available to be used by other programs or users over a network.
About these practice questions
Courseiva writes every DP-900 question from scratch — 820 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-900 practice question is part of Courseiva's free Microsoft 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 DP-900 exam.