DP-900 Azure Synapse Analytics Serverless SQL pool Practice Question
A retail company has an Azure SQL Database that handles OLTP transactions for its e-commerce platform. The analytics team needs to run complex reporting queries that join multiple tables (e.g., orders, products, customers) and aggregate millions of rows. These queries are long-running and would negatively impact the performance of the OLTP database if run directly. The company wants to use a separate analytics service that supports T-SQL queries, can scale compute independently, and provides a serverless option to avoid provisioning fixed resources. Which Azure service should they choose?
⚠ Common exam trap
The trap is that candidates may focus on the dedicated SQL pool option and miss that Azure Synapse Analytics also provides a serverless SQL pool, which exactly matches the requirement for a serverless, T-SQL-based analytics service that can scale independently.
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 Synapse Analytics (serverless SQL pool)
Azure Synapse Analytics includes a serverless SQL pool that supports T-SQL queries, scales compute independently, and does not require provisioning fixed resources, matching the requirement. The dedicated SQL pool is provisioned and does not provide a serverless option, so the correct choice is the serverless SQL pool.
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 Synapse Analytics (serverless SQL pool)
Why this is correct
Correct: Azure Synapse Analytics includes a serverless SQL pool that meets all requirements: T-SQL support, independent scaling, and serverless billing.
- ✗
Azure Analysis Services
Why it's wrong here
Incorrect: Azure Analysis Services provides a semantic layer but does not support direct T-SQL queries on raw data and is not serverless.
When this WOULD be correct
A company needs to create a semantic data model for business users to perform interactive analysis and reporting using tools like Power BI, with in-memory caching for fast performance, and does not require direct T-SQL access to raw data.
- ✗
Azure Databricks
Why it's wrong here
Incorrect: Azure Databricks uses Spark SQL, not T-SQL, and while it can be serverless, it does not natively support T-SQL syntax.
When this WOULD be correct
A company needs to run complex data transformations and machine learning on large datasets from multiple sources (e.g., streaming data, IoT) using Apache Spark, and requires a collaborative notebook environment for data scientists and engineers.
- ✗
Azure SQL Database (creating a secondary replica)
Why it's wrong here
Incorrect: Creating a secondary replica of Azure SQL Database does not provide serverless compute and shares the underlying provisioning; it also does not independently scale compute.
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.
✓Azure Synapse Analytics (serverless SQL pool)Correct answer▾
Why this is correct
Correct: Azure Synapse Analytics includes a serverless SQL pool that meets all requirements: T-SQL support, independent scaling, and serverless billing.
✗Azure Analysis ServicesWrong answer — click to see why▾
Why this is wrong here
Azure Analysis Services is a semantic modeling and BI tool, not a T-SQL query engine for large-scale data warehousing. It does not support direct T-SQL queries on raw data and cannot scale compute independently for complex aggregations.
★ When this WOULD be the correct answer
A company needs to create a semantic data model for business users to perform interactive analysis and reporting using tools like Power BI, with in-memory caching for fast performance, and does not require direct T-SQL access to raw data.
Why candidates choose this
Candidates may confuse Azure Analysis Services with a data warehouse because it supports analytics and can handle large datasets, but they overlook that it is a modeling layer, not a T-SQL query engine.
✗Azure DatabricksWrong answer — click to see why▾
Why this is wrong here
Azure Databricks is optimized for big data analytics and machine learning using Apache Spark, not for T-SQL queries. It does not natively support T-SQL and requires Spark SQL or Python, making it unsuitable for the specified requirement of T-SQL support.
★ When this WOULD be the correct answer
A company needs to run complex data transformations and machine learning on large datasets from multiple sources (e.g., streaming data, IoT) using Apache Spark, and requires a collaborative notebook environment for data scientists and engineers.
Why candidates choose this
Candidates may associate Azure Databricks with analytics and scalability, overlooking the specific requirement for T-SQL support and assuming any analytics service can handle SQL-like queries.
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
OLAP vs OLTP Workloads
Key term
Dedicated SQL pool
A Dedicated SQL pool is a cloud-based analytics service in Azure Synapse Analytics that provides a managed, scalable environment for running large-scale data warehousing queries using Transact-SQL.
Key term
Serverless SQL pool
Serverless SQL pool is an on-demand, pay-per-query analytics service in Azure that lets you query data stored in data lakes without provisioning or managing any dedicated infrastructure.
About these practice questions
One of 851 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.