DP-600 Fabric Certification UPDATED
ACTUAL Exam Questions and CORRECT
Answers
What is Microsoft Fabric - CORRECT ANSWER - 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? - CORRECT ANSWER - 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? - CORRECT ANSWER - 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? - CORRECT ANSWER - Azure Data Lake Storage
(ADLS)
OneLake Data format? - CORRECT ANSWER - Data can be stored in any format,
including Delta, Parquet, CSV, JSON, and more.
How is Tabular data stored in Fabric? - CORRECT ANSWER - Fabric will write data in
delta-parquet format and all engines interact with the format seamlessly.
,Shortcuts in OneLake - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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? - CORRECT ANSWER - Lakehouse
Semantic Model
SQL analytics Endpoint
SQL analytics endpoint - CORRECT ANSWER - 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 - CORRECT ANSWER - 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? - CORRECT ANSWER - 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 - CORRECT ANSWER -
Apache Spark
SQL Analytics Endpoint
Dataflows
Data Pipelines
ACTUAL Exam Questions and CORRECT
Answers
What is Microsoft Fabric - CORRECT ANSWER - 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? - CORRECT ANSWER - 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? - CORRECT ANSWER - 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? - CORRECT ANSWER - Azure Data Lake Storage
(ADLS)
OneLake Data format? - CORRECT ANSWER - Data can be stored in any format,
including Delta, Parquet, CSV, JSON, and more.
How is Tabular data stored in Fabric? - CORRECT ANSWER - Fabric will write data in
delta-parquet format and all engines interact with the format seamlessly.
,Shortcuts in OneLake - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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? - CORRECT ANSWER - Lakehouse
Semantic Model
SQL analytics Endpoint
SQL analytics endpoint - CORRECT ANSWER - 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 - CORRECT ANSWER - 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? - CORRECT ANSWER - 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 - CORRECT ANSWER -
Apache Spark
SQL Analytics Endpoint
Dataflows
Data Pipelines
