DP-900 Describe an analytics workload on Azure Practice Question
Your company wants to use Microsoft Fabric to create a unified analytics platform. Which component in Microsoft Fabric provides a lake-centric, collaborative, and governed data foundation?
⚠ Common exam trap
Watch out — candidates often confuse the tool that provides the data foundation (OneLake) with the workloads that operate on top of it (like Synapse Data Engineering or Data Factory), or mistake Power BI's role as a visualization layer for the underlying storage and governance 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
✓
OneLake
OneLake is the correct answer because it is the single, unified, lake-centric data foundation in Microsoft Fabric. It provides a multi-cloud, SaaS-based data lake that is automatically provisioned for every Fabric tenant, enabling collaborative and governed access to data without data duplication, while supporting open formats like Delta Parquet.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Power BI
Why it's wrong here
Power BI is a business intelligence and visualization service, so its role is to analyze and present data rather than to store it. In a Microsoft Fabric architecture, Power BI connects to OneLake to build reports, but it does not provide the underlying unified data foundation. Choosing Power BI as the foundation confuses the consumption layer with the storage layer, so it is incorrect for this question.
- ✗
Data Factory
Why it's wrong here
Data Factory is Microsoft's data integration and orchestration service used to create ETL/ELT pipelines. While it can copy and transform data into or out of OneLake, it is a processing service rather than a persistent, unified storage environment. The question asks for the foundational component, and Data Factory operates on top of that foundation, making it an incorrect answer.
- ✓
OneLake
Why this is correct
OneLake is the central, lake-centric data storage foundation in Microsoft Fabric, providing a single, unified logical data lake that all Fabric workloads share. It automatically organizes data into tables and files, supports open formats like Delta and Parquet, and eliminates data duplication by allowing multiple engines to work on the same data. This makes OneLake the correct answer, as it is the foundational component that unifies data management across the platform.
- ✗
Synapse Data Engineering
Why it's wrong here
Synapse Data Engineering is a workload within Fabric that provides Spark-based data transformation and preparation. It relies on OneLake for storage, meaning it is a consumer and processor of data, not the storage substrate itself. Since the question is about the unifying foundation, Synapse Data Engineering is a service built on top of OneLake and therefore is incorrect.
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
Data lake
A data lake is a centralized storage repository that holds vast amounts of raw data in its native format until it is needed for analysis.
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.