DP-900 Describe an analytics workload on Azure Practice Question
A company ingests raw clickstream data as JSON files into Azure Data Lake Storage Gen2. Data scientists need to explore the data interactively using Python notebooks, and the BI team needs to create reports from aggregated datasets derived from this data. The solution must be serverless, scale automatically, and minimize administration. Which Azure service should they choose?
⚠ Common exam trap
Candidates often confuse serverless SQL pools (Synapse) as suitable for interactive Python exploration, but they are designed for SQL-based querying, not notebook-based data science workflows.
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
✓
B. Azure Databricks
Azure Databricks is correct because it provides a serverless, interactive Apache Spark environment that data scientists can use with Python notebooks for exploratory analysis, and it can produce aggregated datasets for BI reporting. It scales automatically and minimizes administration by managing the cluster lifecycle, making it ideal for ad-hoc data exploration on raw JSON files in Azure Data Lake Storage Gen2.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
A. Azure Synapse Analytics (serverless SQL pool)
Why it's wrong here
Azure Synapse Analytics' serverless SQL pool is designed for ad-hoc T-SQL queries over files in a data lake, not for Python notebook development. Although Synapse offers notebook experiences through its Spark pools, the serverless SQL pool specifically has no Python runtime, so it cannot meet the data scientists' need for interactive Python exploration. It remains fundamentally SQL-only, making it a mismatch for this workload.
When this WOULD be correct
A question requiring serverless T-SQL querying over data lake files (e.g., CSV, Parquet) without managing infrastructure, and where the primary users are analysts writing SQL rather than data scientists using Python notebooks.
- ✓
B. Azure Databricks
Why this is correct
Azure Databricks is the right fit because it provides a fully managed, collaborative notebook environment with native Python, Scala, and SQL kernels. Its serverless mode dynamically acquires and releases compute pools based on workload, eliminating manual cluster sizing and scaling. This supports interactive exploration by data scientists as well as production transformation, minimizing administration while covering the full data science lifecycle.
- ✗
C. Azure HDInsight with Spark
Why it's wrong here
Azure HDInsight with Spark gives you Spark clusters, but these are long-lived, provisioned resources that you must manually size, configure, scale, and patch. Even with auto-scale, you remain responsible for cluster lifecycle management, which introduces significant administration overhead. Since the requirement explicitly calls for minimal administration and serverless-style operation, HDInsight's operational burden makes it a less appropriate choice.
- ✗
D. Azure Data Lake Analytics
Why it's wrong here
Azure Data Lake Analytics is a batch analytics service that uses U-SQL, a SQL-like language extended with C# expressions, rather than Python notebooks. It does not deliver an interactive collaborative notebook environment where data scientists can explore raw clickstream data cell-by-cell. The service processes queued analytics jobs, whereas the scenario demands notebook-based interactive discovery and transformation.
When this WOULD be correct
A question requiring batch processing of large-scale data using U-SQL or .NET code, where the solution must run on Azure without managing clusters, and interactive exploration is not needed.
Option-by-option analysis
Why each answer is right or wrong
Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The DP-900 exam frequently reuses these exact scenarios with slightly different constraints.
✓B. Azure DatabricksCorrect answer▾
Why this is correct
Azure Databricks is the right fit because it provides a fully managed, collaborative notebook environment with native Python, Scala, and SQL kernels. Its serverless mode dynamically acquires and releases compute pools based on workload, eliminating manual cluster sizing and scaling. This supports interactive exploration by data scientists as well as production transformation, minimizing administration while covering the full data science lifecycle.
✗A. Azure Synapse Analytics (serverless SQL pool)Wrong answer — click to see why▾
Why this is wrong here
Serverless SQL pool in Azure Synapse Analytics is optimized for T-SQL queries over relational data, not for interactive Python notebook exploration of raw JSON files. It lacks native Python notebook support and is less suited for data science workflows.
★ When this WOULD be the correct answer
A question requiring serverless T-SQL querying over data lake files (e.g., CSV, Parquet) without managing infrastructure, and where the primary users are analysts writing SQL rather than data scientists using Python notebooks.
Why candidates choose this
Candidates may confuse 'serverless' with the requirement for minimal administration, and Synapse Analytics offers a serverless SQL pool, but they overlook the need for interactive Python notebook exploration, which is a core feature of Databricks.
✗D. Azure Data Lake AnalyticsWrong answer — click to see why▾
Why this is wrong here
Azure Data Lake Analytics is deprecated and not serverless in the same sense; it requires job submission and does not support interactive Python notebooks for data exploration.
★ When this WOULD be the correct answer
A question requiring batch processing of large-scale data using U-SQL or .NET code, where the solution must run on Azure without managing clusters, and interactive exploration is not needed.
Why candidates choose this
Candidates may confuse Data Lake Analytics with a serverless analytics option because of its name, and overlook its lack of Python notebook support and deprecation status.
Analysis generated from the official DP-900blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”
Quick reference
Cloud Service Model Comparison
| Model | You Manage | Provider Manages | Examples |
|---|---|---|---|
| IaaS | OS, runtime, apps, data | Hardware, hypervisor, networking | EC2, Azure VMs, GCP Compute Engine |
| PaaS | Apps and data | OS, runtime, middleware, hardware | Elastic Beanstalk, Azure App Service |
| SaaS | Data and settings only | Everything else | Microsoft 365, Salesforce, Workday |
| FaaS / Serverless | Function code only | Infra, scaling, runtime | Lambda, Azure Functions, Cloud Run |
| CaaS | Containers and apps | Kubernetes, OS, hardware | EKS, AKS, GKE |
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
This DP-900 question is part of Courseiva's 820-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.