DP-600 Fabric Certification Exam Questions with Correct Answers Latest Update 2025/2026
What is Microsoft Fabric - Answers Fabric is a unified software-as-a-service (SaaS) offering,
with all your data stored in a single open format in OneLake.
What is OneLake? - Answers Its like OneDrive but for data.
OneLake is Fabric's lake-centric architecture that provides a single, integrated environment for
data professionals and the business to collaborate on data projects.
Fabric's OneLake architecture facilitates collaboration between data team members and saves
time by eliminating the need to move and copy data between different systems and teams.
OneLake combines storage locations across different regions and clouds into a single logical
lake, without moving or duplicating data
What is OneCopy? - Answers OneCopy is a key component of OneLake that allows you to read
data from a single copy, without moving or duplicating data.
What is OneLake built on top of? - Answers Azure Data Lake Storage (ADLS)
OneLake Data format? - Answers Data can be stored in any format, including Delta, Parquet,
CSV, JSON, and more.
How is Tabular data stored in Fabric? - Answers Fabric will write data in delta-parquet format
and all engines interact with the format seamlessly.
Shortcuts in OneLake - Answers are embedded references within OneLake that point to other
files or storage locations.
Shortcuts allow you to quickly source your existing cloud data without having to copy it, and
enables Fabric experiences to derive data from the same source to always be in sync.
Shortcuts enable you to integrate data into your lakehouse while keeping it stored in external
storage.
Microsoft Fabric admin - Answers the management of the organization-wide settings that
control how Microsoft Fabric works. Users that are assigned to admin roles configure, monitor,
,and provision organizational resources.
Benefits of Using Microsoft Fabric - Answers Fabric removes data silos and the need for access
to multiple systems, enhancing collaboration between data professionals.
data professionals work together in the same SaaS product to better understand and identify
needs of each other and the business. Further, data analysts now have greater context and
ability to transform data further upstream with data factory.
allows you to quickly and easily provision and run any type of workload or job without needing
pre-approval or planning
means that you can scale resources up or down as needed, and be more agile and responsive to
changing business needs
Fabric is bringing the low-to-no-code concept, functionality, and approach that has successfully
empowered many users on the Power Platform to its own SaaS offering.
What makes Fabric unique is that it brings these capabilities together in a single, SaaS
integrated experience without the need for access to Azure resources.
Permissions required to enable Fabric - Answers either:
Fabric admin
Power Platform admin
Microsoft 365 admin
can be enabled at the tenant level or capacity level, meaning that it can be enabled for the entire
organization or for specific groups of users.
Microsoft Fabric Lakehouse - Answers A Lakehouse presents as a database and is built on top
of a data lake using Delta format tables.
,Lakehouses combine the SQL-based analytical capabilities of a relational data warehouse and
the flexibility and scalability of a data lake.
Lakehouses store all data formats and can be used with various analytics tools and
programming languages.
As cloud-based solutions, lakehouses can scale automatically and provide high availability and
disaster recovery.
Benefits of a Lakehouse - Answers support ACID (Atomicity, Consistency, Isolation, Durability)
transactions through Delta Lake formatted tables for data consistency and integrity.
use Spark and SQL engines to process large-scale data and support machine learning or
predictive modeling analytics.
data is organized in a schema-on-read format, which means you define the schema as needed
rather than having a predefined schema.
are a single location for data engineers, data scientists, and data analysts to access and use
data.
What 3 items does each lakehouse produce? - Answers Lakehouse
Semantic Model
SQL analytics Endpoint
SQL analytics endpoint - Answers You can analyze data in Delta tables using T-SQL language,
save functions, generate views, and apply SQL security. To access SQL analytics endpoint, you
select a corresponding item in the workspace view or switch to SQL analytics endpoint mode in
Lakehouse explorer.
Ways to load data into a Fabric lakehouse - Answers Upload: Upload local files or folders to the
lakehouse. You can then explore and process the file data, and load the results into tables.
Dataflows (Gen2): Import and transform data from a range of sources using Power Query Online,
, and load it directly into a table in the lakehouse.
Notebooks: Use notebooks in Fabric to ingest and transform data, and load it into tables or files
in the lakehouse.
Data Factory pipelines: Copy data and orchestrate data processing activities, loading the results
into tables or files in the lakehouse.
Where can shortcuts be created? - Answers can be created in both Lakehouses and KQL
databases, and appear as a folder in the lake. This allows Spark, SQL, Real-Time intelligence and
Analysis Services to all utilize shortcuts when querying data.
Tools and techniques to explore and transform data in Fabric - Answers Apache Spark
SQL Analytics Endpoint
Dataflows
Data Pipelines
What is Apache Spark? - Answers is a distributed data processing framework that enables large-
scale data analytics by coordinating work across multiple processing nodes in a cluster.
Put more simply, Spark uses a "divide and conquer" approach to processing large volumes of
data quickly by distributing the work across multiple computers.
Apache Spark Process - Answers The process of distributing tasks and collating results is
handled for you by Spark. You submit a data processing job in the form of some code that
initiates a driver program, which uses a cluster management object called the SparkContext to
manage the distribution of processing in the Spark cluster.
In most cases, these details are abstracted - you just need to write the code required to perform
the data operations you need.
Spark settings - Answers each workspace is assigned a Spark cluster
Specific configuration settings include:
What is Microsoft Fabric - Answers Fabric is a unified software-as-a-service (SaaS) offering,
with all your data stored in a single open format in OneLake.
What is OneLake? - Answers Its like OneDrive but for data.
OneLake is Fabric's lake-centric architecture that provides a single, integrated environment for
data professionals and the business to collaborate on data projects.
Fabric's OneLake architecture facilitates collaboration between data team members and saves
time by eliminating the need to move and copy data between different systems and teams.
OneLake combines storage locations across different regions and clouds into a single logical
lake, without moving or duplicating data
What is OneCopy? - Answers OneCopy is a key component of OneLake that allows you to read
data from a single copy, without moving or duplicating data.
What is OneLake built on top of? - Answers Azure Data Lake Storage (ADLS)
OneLake Data format? - Answers Data can be stored in any format, including Delta, Parquet,
CSV, JSON, and more.
How is Tabular data stored in Fabric? - Answers Fabric will write data in delta-parquet format
and all engines interact with the format seamlessly.
Shortcuts in OneLake - Answers are embedded references within OneLake that point to other
files or storage locations.
Shortcuts allow you to quickly source your existing cloud data without having to copy it, and
enables Fabric experiences to derive data from the same source to always be in sync.
Shortcuts enable you to integrate data into your lakehouse while keeping it stored in external
storage.
Microsoft Fabric admin - Answers the management of the organization-wide settings that
control how Microsoft Fabric works. Users that are assigned to admin roles configure, monitor,
,and provision organizational resources.
Benefits of Using Microsoft Fabric - Answers Fabric removes data silos and the need for access
to multiple systems, enhancing collaboration between data professionals.
data professionals work together in the same SaaS product to better understand and identify
needs of each other and the business. Further, data analysts now have greater context and
ability to transform data further upstream with data factory.
allows you to quickly and easily provision and run any type of workload or job without needing
pre-approval or planning
means that you can scale resources up or down as needed, and be more agile and responsive to
changing business needs
Fabric is bringing the low-to-no-code concept, functionality, and approach that has successfully
empowered many users on the Power Platform to its own SaaS offering.
What makes Fabric unique is that it brings these capabilities together in a single, SaaS
integrated experience without the need for access to Azure resources.
Permissions required to enable Fabric - Answers either:
Fabric admin
Power Platform admin
Microsoft 365 admin
can be enabled at the tenant level or capacity level, meaning that it can be enabled for the entire
organization or for specific groups of users.
Microsoft Fabric Lakehouse - Answers A Lakehouse presents as a database and is built on top
of a data lake using Delta format tables.
,Lakehouses combine the SQL-based analytical capabilities of a relational data warehouse and
the flexibility and scalability of a data lake.
Lakehouses store all data formats and can be used with various analytics tools and
programming languages.
As cloud-based solutions, lakehouses can scale automatically and provide high availability and
disaster recovery.
Benefits of a Lakehouse - Answers support ACID (Atomicity, Consistency, Isolation, Durability)
transactions through Delta Lake formatted tables for data consistency and integrity.
use Spark and SQL engines to process large-scale data and support machine learning or
predictive modeling analytics.
data is organized in a schema-on-read format, which means you define the schema as needed
rather than having a predefined schema.
are a single location for data engineers, data scientists, and data analysts to access and use
data.
What 3 items does each lakehouse produce? - Answers Lakehouse
Semantic Model
SQL analytics Endpoint
SQL analytics endpoint - Answers You can analyze data in Delta tables using T-SQL language,
save functions, generate views, and apply SQL security. To access SQL analytics endpoint, you
select a corresponding item in the workspace view or switch to SQL analytics endpoint mode in
Lakehouse explorer.
Ways to load data into a Fabric lakehouse - Answers Upload: Upload local files or folders to the
lakehouse. You can then explore and process the file data, and load the results into tables.
Dataflows (Gen2): Import and transform data from a range of sources using Power Query Online,
, and load it directly into a table in the lakehouse.
Notebooks: Use notebooks in Fabric to ingest and transform data, and load it into tables or files
in the lakehouse.
Data Factory pipelines: Copy data and orchestrate data processing activities, loading the results
into tables or files in the lakehouse.
Where can shortcuts be created? - Answers can be created in both Lakehouses and KQL
databases, and appear as a folder in the lake. This allows Spark, SQL, Real-Time intelligence and
Analysis Services to all utilize shortcuts when querying data.
Tools and techniques to explore and transform data in Fabric - Answers Apache Spark
SQL Analytics Endpoint
Dataflows
Data Pipelines
What is Apache Spark? - Answers is a distributed data processing framework that enables large-
scale data analytics by coordinating work across multiple processing nodes in a cluster.
Put more simply, Spark uses a "divide and conquer" approach to processing large volumes of
data quickly by distributing the work across multiple computers.
Apache Spark Process - Answers The process of distributing tasks and collating results is
handled for you by Spark. You submit a data processing job in the form of some code that
initiates a driver program, which uses a cluster management object called the SparkContext to
manage the distribution of processing in the Spark cluster.
In most cases, these details are abstracted - you just need to write the code required to perform
the data operations you need.
Spark settings - Answers each workspace is assigned a Spark cluster
Specific configuration settings include:
