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