DP-900 Describe an analytics workload on Azure Practice Question
Which THREE components are part of a typical modern data warehouse architecture on Azure?
⚠ Common exam trap
Candidates often confuse Azure Cosmos DB (a transactional NoSQL database) with an analytical store, or mistakenly think Azure Analysis Services is a required part of the data warehouse architecture when it is actually an optional semantic layer.
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 Data Factory
Azure Data Factory (A) is correct because it is the orchestration and data-integration service in a modern Azure data warehouse architecture, used to build pipelines that copy and transform data from source systems into the warehouse. Azure Synapse Analytics (D) is correct because it is the core analytics/warehouse engine, providing dedicated SQL pools (formerly SQL DW), serverless SQL pools, and Spark pools for large-scale analytical workloads. Azure Data Lake Storage Gen2 (E) is correct because it serves as the scalable, hierarchical-namespace storage layer (built on Blob Storage with HNS enabled) that holds raw and curated data in formats like Parquet and Delta before and after loading into the warehouse. Azure Cosmos DB (B) is not part of a typical data warehouse architecture; it is a globally distributed operational NoSQL database for transactional (OLTP) workloads, not analytical warehousing. Azure Analysis Services (C) is a semantic/tabular modeling layer for BI, and while it can complement analytics solutions, it is not one of the core components of a modern Azure data warehouse architecture as represented by ingestion, storage, and warehouse compute.
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 Data Factory
Why this is correct
Azure Data Factory is the cloud-based ETL/ELT orchestration service that connects to over 90 built-in connectors, allowing you to ingest data from on-premises and cloud sources, then transform it via mapping data flows or external compute (e.g., Azure Databricks, HDInsight) before loading it into a destination such as Azure Synapse Analytics or Azure Data Lake Storage Gen2. In a modern data warehouse, Data Factory is the integration backbone that automates and schedules data movement, making it a core component alongside storage and compute. Without it, raw data would remain siloed and untransformed, preventing a unified analytics pipeline.
- ✗
Azure Cosmos DB
Why it's wrong here
Azure Cosmos DB is a globally distributed, multi-model NoSQL database service designed for low-latency transactional workloads (e.g., IoT telemetry, user profiles, shopping carts) with SLA-backed throughput and consistency. It is not a data warehousing component because it lacks the relational schema, columnar storage, and Massively Parallel Processing (MPP) engine required for complex analytical queries across large datasets. While Cosmos DB can serve as a data source for a warehouse (via Change Feed or Azure Data Factory), it is not part of the warehouse architecture itself; it is an operational datastore, not an analytics store.
- ✗
Azure Analysis Services
Why it's wrong here
Azure Analysis Services is an optional semantic modeling layer that can sit on top of a data warehouse to provide tabular models, measures, KPIs, and role-based security for tools like Power BI. It is not considered a core component of the modern data warehouse because it supplements rather than performs the essential functions of storage, ingestion, or query processing. In a modern architecture, Power BI Premium datasets or Synapse SQL pool can serve a similar semantic role, making Analysis Services an addition for specific performance or governance needs, not a required pillar.
- ✓
Azure Synapse Analytics
Why this is correct
Azure Synapse Analytics is the unified analytics platform that combines a dedicated SQL pool (the actual data warehouse for relational, columnar storage and high-performance T-SQL queries) with serverless SQL on demand, Apache Spark pools, and data integration pipelines. As the primary compute and query engine, Synapse Analytics stores curated, transformed data in tables and executes the analytical workloads that produce business reports and dashboards. This makes it the central component that delivers the 'warehouse' functionality in a modern data warehouse architecture, distinguishing it from storage and orchestration services.
- ✓
Azure Data Lake Storage Gen2
Why this is correct
Azure Data Lake Storage Gen2 (ADLS Gen2) is a scalable, secure, and cost-effective data lake built on Azure Blob Storage with a hierarchical namespace, enabling fine-grained access control and file/directory-level operations. In a modern data warehouse, it acts as the landing zone for raw, unprocessed data from diverse sources, and also stores curated, conformed data that Synapse Analytics or other engines can query via external tables or load into dedicated SQL pools. It is a core component because it provides the foundation for the 'lake' half of a lakehouse/warehouse architecture, supporting both batch and streaming ingestion without requiring upfront schema definition.
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
Azure Cosmos DB
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.
Key term
Azure Cosmos DB
Azure Cosmos DB is a fully managed, globally distributed NoSQL database service that offers fast reads and writes anywhere in the world with automatic scaling and multiple consistency models.
About these practice questions
Courseiva writes every DP-900 question from scratch — 851 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.