DP-900 Describe an analytics workload on Azure Practice Question
A data engineering team is designing a modern data warehouse using Azure Synapse Analytics. They want to follow a lakehouse architecture where raw data is stored in its native format and then processed and curated for reporting. Which component in Azure Synapse Analytics is primarily used to store raw data in its original format without requiring a schema?
⚠ Common exam trap
Many exam-takers confuse the role of a Serverless SQL pool (which can query raw data) with the actual storage layer, leading them to incorrectly select Option B instead of recognizing that ADLS Gen2 is the persistent, schema-less storage component.
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
✓
Data Lake Storage Gen2
Azure Data Lake Storage Gen2 (ADLS Gen2) is the correct component because it provides a scalable, hierarchical file system that can store raw data in any native format (e.g., CSV, JSON, Parquet) without requiring a predefined schema. This aligns with the lakehouse architecture's requirement to ingest and persist raw data as-is before any transformation or curation.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Dedicated SQL pool
Why it's wrong here
A Dedicated SQL pool, formerly SQL Data Warehouse, is a massively parallel processing (MPP) relational database that stores data in structured tables with predefined schemas, distributions, and indexes. It is optimized for high-performance T-SQL queries over aggregated or modeled data, not for preserving raw files in their original state. Because it imposes schema-on-write and stores rows in relational tables, it cannot act as the raw ingestion layer where data lands in diverse, evolving formats.
When this WOULD be correct
A question asking which component is used for high-performance, scalable relational data warehousing with T-SQL queries and predictable performance would have Dedicated SQL pool as the correct answer.
- ✗
Serverless SQL pool
Why it's wrong here
A serverless SQL pool is a serverless query engine that executes T-SQL directly over files in a data lake, creating metadata schemas (external tables) to interpret data on the fly. It does not store the raw or transformed data itself; the files remain in ADLS Gen2, and the pool only caches metadata or performs transient reads. This makes it a compute layer for ad-hoc analytics and on-demand querying, not a candidate for the raw data storage component in a modern data warehouse.
When this WOULD be correct
A question asking which Azure Synapse component allows querying Parquet/CSV files directly from a data lake without loading them into a database, using T-SQL and paying only for data processed.
- ✗
Synapse Pipeline
Why it's wrong here
Synapse Pipeline, built on Azure Data Factory technology, is an orchestration service rather than a storage system; it moves and transforms data by coordinating activities such as copy tasks, data flows, and notebook runs. The service manages execution schedules, dependencies, and error handling, but it persists only metadata and job logs, not the actual data payloads. Therefore, it cannot provide the underlying storage where raw data is retained in its native format for a modern data warehouse.
When this WOULD be correct
A question asks: 'Which Azure Synapse Analytics component is used to orchestrate data ingestion and transformation workflows?' In that context, Synapse Pipeline is the correct answer.
- ✓
Data Lake Storage Gen2
Why this is correct
Azure Data Lake Storage Gen2 (ADLS Gen2) is the right choice because it serves as the storage backbone of a modern data warehouse, offering scalable object storage with a hierarchical namespace for efficient data organization. It holds raw data in any native format—Parquet, JSON, CSV, images—while enabling lakehouse features like ACID transactions through Delta Lake. This storage layer is independent of compute, allowing various engines like Spark, serverless SQL, and dedicated pools to read the same data directly.
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.
✓Data Lake Storage Gen2Correct answer▾
Why this is correct
Azure Data Lake Storage Gen2 (ADLS Gen2) is the right choice because it serves as the storage backbone of a modern data warehouse, offering scalable object storage with a hierarchical namespace for efficient data organization. It holds raw data in any native format—Parquet, JSON, CSV, images—while enabling lakehouse features like ACID transactions through Delta Lake. This storage layer is independent of compute, allowing various engines like Spark, serverless SQL, and dedicated pools to read the same data directly.
✗Dedicated SQL poolWrong answer — click to see why▾
Why this is wrong here
Dedicated SQL pool requires a defined schema and stores data in relational tables, not raw native format without schema enforcement.
★ When this WOULD be the correct answer
A question asking which component is used for high-performance, scalable relational data warehousing with T-SQL queries and predictable performance would have Dedicated SQL pool as the correct answer.
Why candidates choose this
Candidates may think Dedicated SQL pool is the core of Synapse for all data storage, overlooking its schema-on-write requirement and that raw data storage is handled by Data Lake Storage.
✗Serverless SQL poolWrong answer — click to see why▾
Why this is wrong here
Serverless SQL pool is used for querying data in external storage (like Data Lake) using T-SQL, not for storing raw data. It does not store data itself; it provides on-demand querying over files.
★ When this WOULD be the correct answer
A question asking which Azure Synapse component allows querying Parquet/CSV files directly from a data lake without loading them into a database, using T-SQL and paying only for data processed.
Why candidates choose this
Candidates may confuse 'serverless' with 'schema-less' storage, or think that because it can query raw formats, it also stores them, missing the distinction between compute and storage.
✗Synapse PipelineWrong answer — click to see why▾
Why this is wrong here
Synapse Pipeline is an orchestration and data movement service, not a storage component. It cannot store raw data; it moves or transforms data between sources and sinks.
★ When this WOULD be the correct answer
A question asks: 'Which Azure Synapse Analytics component is used to orchestrate data ingestion and transformation workflows?' In that context, Synapse Pipeline is the correct answer.
Why candidates choose this
Candidates may confuse the pipeline's role in data ingestion with actual data storage, thinking it stores raw data as part of the lakehouse architecture.
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
Data warehouse
A data warehouse is a central repository that stores large amounts of structured data from multiple sources, optimized for querying and analysis rather than day-to-day transactions.
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
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.