DP-900 Describe an analytics workload on Azure Practice Question
A business analyst needs to explore and create interactive visualizations of sales data stored in Azure Data Lake Storage Gen2 without writing SQL code. Which Azure service is best suited for this drag-and-drop data exploration?
⚠ Common exam trap
Candidates often confuse Azure Data Factory's visual pipeline designer with a drag-and-drop exploration tool, but Data Factory is for data movement and orchestration, not interactive visualization.
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
✓
Microsoft Power BI
Microsoft Power BI is the correct choice because it provides a drag-and-drop interface for creating interactive visualizations and exploring data without requiring SQL code. It can directly connect to Azure Data Lake Storage Gen2 using Power Query or the ADLS connector, enabling business analysts to build reports and dashboards through intuitive visual interactions.
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 runs continuous SQL-like queries over streaming data from sources like Event Hubs or IoT Hub. It is designed to detect patterns, aggregations, and alerts in motion — not to explore static datasets interactively. Its outputs are typically written to sinks such as Azure Blob Storage or Power BI, but it provides no user-facing canvas for drag-and-drop visual building.
- ✗
Azure Data Factory
Why it's wrong here
Azure Data Factory is an orchestration and data-integration service for building ETL/ELT pipelines that move and transform data at scale. It supports data flows and scheduled activities, but its primary purpose is automating data movement between connectors, not supporting ad-hoc visual exploration. Business analysts cannot use Data Factory to create interactive dashboards; it lacks any report-authoring or drag-and-drop visualization surface.
- ✗
Azure Databricks
Why it's wrong here
Azure Databricks is a Unified Analytics Platform built on Apache Spark, offering collaborative notebooks for coding in Python, Scala, SQL, or R. While it can generate dashboards from notebook results, that workflow requires writing and maintaining code, for which a business analyst typically lacks the skill or mandate. It is a data engineering/data science tool for large-scale processing and ML, not a no-code interactive visualization tool like the correct answer.
- ✓
Microsoft Power BI
Why this is correct
Microsoft Power BI is the correct choice because it is a dedicated self-service BI and visualization platform. It connects to a wide range of sources including Azure Data Lake Storage and Azure SQL Database, and lets users transform data through Power Query, create calculated columns and measures with DAX, and build interactive reports and dashboards via a drag-and-drop interface. It supports natural-language Q&A, shared workspaces, and embedded analytics — exactly what a business analyst needs for exploration and interactivity without writing custom code.
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
Data Lake Storage Gen2
Data Lake Storage Gen2 is a cloud-based storage service that combines a scalable data lake with enterprise-grade file system capabilities for big data analytics.
About these practice questions
One of 820 original DP-900 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 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.