DP-900 Describe an analytics workload on Azure Practice Question
A company is migrating their on-premises data warehouse, which is built on a Netezza appliance, to Azure. The data warehouse contains over 10 terabytes of data and supports complex BI queries with multiple joins and aggregations. The company requires a cloud-based solution that provides massively parallel processing (MPP) to handle large-scale queries efficiently. They also need to integrate with existing ETL tools like Azure Data Factory and provide native connectivity to Power BI. Which Azure service should they choose?
⚠ Common exam trap
Candidates often confuse Azure Databricks (a Spark-based analytics platform) with a data warehouse, overlooking that Synapse dedicated SQL pool is the only option that provides native MPP, T-SQL support, and direct Power BI connectivity for large-scale BI workloads.
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 dedicated SQL pool
Azure Synapse Analytics dedicated SQL pool is the correct choice because it provides massively parallel processing (MPP) architecture designed for petabyte-scale data warehousing, exactly matching the 10+ TB requirement. It natively integrates with Azure Data Factory for ETL and offers built-in Power BI connectivity via the T-SQL endpoint, supporting complex BI queries with multiple joins and aggregations.
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 SQL Database
Why it's wrong here
Azure SQL Database is a fully managed relational database service optimized for online transaction processing (OLTP), using a single-node architecture that limits query parallelism compared to a cloud data warehouse. While it supports columnstore indexes for analytics, it is not designed for petabytes of data or the massive concurrency and complex join patterns typical of a data warehouse migration. Its primary workload profile is low-latency, row-level transactions, not the high-throughput analytic queries that a dedicated SQL pool is built for.
When this WOULD be correct
A company needs a fully managed relational database for an online transaction processing (OLTP) application with moderate data volume (e.g., under 1 TB) and requires high availability, built-in intelligence, and minimal administrative overhead. The workload is primarily transactional, not analytical.
- ✗
Azure Databricks
Why it's wrong here
Azure Databricks is a unified analytics platform that can perform data engineering and ML, but it is not a dedicated MPP data warehouse. It would require more custom development to match a data warehouse experience.
When this WOULD be correct
A company needs to perform advanced analytics on large datasets using Python, R, or Scala, and requires collaborative notebooks for data science teams. They also need to integrate with machine learning frameworks and handle streaming data, making Azure Databricks the ideal choice.
- ✓
Azure Synapse Analytics dedicated SQL pool
Why this is correct
Azure Synapse Analytics dedicated SQL pool uses a massively parallel processing (MPP) architecture that distributes data and query execution across multiple compute nodes, delivering the scale and performance required for large-scale data warehousing workloads. It provides T-SQL compatibility, built-in columnstore indexing, and native integration with Azure Data Factory and Power BI, making it the natural cloud replacement for an on-premises data warehouse. Its separation of compute and storage allows independent scaling and on-demand compute pauses, aligning with enterprise analytics needs.
- ✗
Azure HDInsight
Why it's wrong here
Azure HDInsight is a managed Hadoop/Spark cluster that can be used for big data processing, but it is more IaaS-like and requires more management. It is not a dedicated SQL data warehouse with native BI integrations.
When this WOULD be correct
A company needs to run big data processing (e.g., batch ETL, machine learning) on unstructured or semi-structured data using open-source frameworks like Hadoop, Spark, or Hive, and requires custom cluster configurations. They do not need a dedicated SQL-based data warehouse with native Power BI integration.
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 dedicated SQL poolCorrect answer▾
Why this is correct
Azure Synapse Analytics dedicated SQL pool uses a massively parallel processing (MPP) architecture that distributes data and query execution across multiple compute nodes, delivering the scale and performance required for large-scale data warehousing workloads. It provides T-SQL compatibility, built-in columnstore indexing, and native integration with Azure Data Factory and Power BI, making it the natural cloud replacement for an on-premises data warehouse. Its separation of compute and storage allows independent scaling and on-demand compute pauses, aligning with enterprise analytics needs.
✗Azure SQL DatabaseWrong answer — click to see why▾
Why this is wrong here
Azure SQL Database is a single-node relational database, not a massively parallel processing (MPP) system. It cannot efficiently handle complex BI queries with multiple joins and aggregations over 10+ terabytes of data, as it lacks the distributed architecture required for such large-scale workloads.
★ When this WOULD be the correct answer
A company needs a fully managed relational database for an online transaction processing (OLTP) application with moderate data volume (e.g., under 1 TB) and requires high availability, built-in intelligence, and minimal administrative overhead. The workload is primarily transactional, not analytical.
Why candidates choose this
Candidates may confuse Azure SQL Database with a data warehouse solution because it is a SQL-based service, and they might underestimate the scale and complexity of the workload, assuming a single database can handle large analytical queries.
✗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, but it does not provide the same level of MPP for complex BI queries with multiple joins and aggregations as a dedicated SQL pool. It also lacks native Power BI connectivity and is not a direct replacement for a Netezza data warehouse.
★ When this WOULD be the correct answer
A company needs to perform advanced analytics on large datasets using Python, R, or Scala, and requires collaborative notebooks for data science teams. They also need to integrate with machine learning frameworks and handle streaming data, making Azure Databricks the ideal choice.
Why candidates choose this
Candidates may associate Azure Databricks with large-scale data processing and mistakenly think it can replace a data warehouse for BI workloads, overlooking its primary focus on big data analytics and machine learning rather than MPP SQL querying.
✗Azure HDInsightWrong answer — click to see why▾
Why this is wrong here
Azure HDInsight is a managed Hadoop/Spark service, not optimized for MPP data warehousing with complex BI queries and native Power BI connectivity. It lacks the dedicated SQL pool's MPP engine and integrated query optimization for large-scale relational data warehouse workloads.
★ When this WOULD be the correct answer
A company needs to run big data processing (e.g., batch ETL, machine learning) on unstructured or semi-structured data using open-source frameworks like Hadoop, Spark, or Hive, and requires custom cluster configurations. They do not need a dedicated SQL-based data warehouse with native Power BI integration.
Why candidates choose this
Candidates may associate HDInsight with large-scale data processing and mistakenly think it can replace a dedicated MPP data warehouse, overlooking that it is not a SQL-based warehouse solution and lacks built-in BI tool connectivity.
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?”
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Power BI
Power BI is a Microsoft business analytics tool that transforms raw data into interactive visual reports and dashboards for informed decision-making.
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.
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.