1 | Page
DP600 – MICROSOFT Fabrics Actual
Exam Newest /DP600 – MICROSOFT
Fabrics Practice Exam /DP600 –
MICROSOFT Fabrics Preparation With
350 Questions And Correct Answers
With Rationales| Already Graded A+|
Brand New!!!
You have a Fabric workspace named Workspace1.You plan to integrate
Workspace1 with Azure DevOps.You will use a Fabric deployment
pipeline named deployPipeline1 to deploy items from Workspace1 to
higher environment workspaces as part of a medallion architecture. You
will run deployPipeline1 by using an API call from an Azure DevOps
pipeline.You need to configure API authentication between Azure
DevOps and Fabric.Which type of authentication should you use?
A. service principal
B. Microsoft Entra username and password
C. managed private endpoint
D. workspace identity
----Solution----Answer: A
You have a Fabric workspace named Workspace1 that contains a
notebook named Notebook1.In Workspace1, you create a new notebook
,2 | Page
named Notebook2.You need to ensure that you can attach Notebook2 to
the same Apache Spark session as Notebook1.What should you do?
A. Enable high concurrency for notebooks.
B. Enable dynamic allocation for the Spark pool.
C. Change the runtime version.
D. Increase the number of executors.
----Solution----Answer: A
You have a Fabric workspace that contains a warehouse named
Warehouse1.You have an on-premises Microsoft SQL Server database
named Database1 that is accessed by using an on-premises data
gateway.You need to copy data from Database1 to Warehouse1.Which
item should you use?
A. an Apache Spark job definition
B. a data pipeline
C. a Dataflow Gen1 dataflow
D. an eventstream
----Solution----Answer: B
You have a Fabric capacity that contains a workspace named
Workspace1. Workspace1 contains a lakehouse named Lakehouse1, a
data pipeline, a notebook, and several Microsoft Power BI reports.A user
named User1 wants to use SQL to analyze the data in Lakehouse1.You
need to configure access for User1. The solution must meet the
following requirements:What should you do?
,3 | Page
A.Share Lakehouse1 with User1 directly and select Read all SQL
endpoint data.
B.Assign User1 the Viewer role for Workspace1. Share Lakehouse1
with User1 and select Read all SQL endpoint data.
C.Share Lakehouse1 with User1 directly and select Build reports on the
default semantic model.
D.Assign User1 the Member role for Workspace1. Share Lakehouse1
with User1 and select Read all SQL endpoint data.
----Solution----Answer: B
You have a Fabric workspace named Workspace1 that contains an
Apache Spark job definition named Job1.You have an Azure SQL
database named Source1 that has public internet access disabled.You
need to ensure that Job1 can access the data in Source1.What should you
create?
A.an on-premises data gateway
B.a managed private endpoint
C.an integration runtime
D.a data management gateway
----Solution----Answer: B
You have a Fabric workspace that contains a lakehouse named
Lakehouse1.In an external data source, you have data files that are 500
GB each. A new file is added every day.You need to ingest the data into
Lakehouse1 without applying any transformations. The solutionmust
meet the following requirements Trigger the process when a new file is
, 4 | Page
added.Provide the highest throughput.Which type of item should you use
to ingest the data?
A. Data pipeline
B. Environment
C. KQL queryset
D. Dataflow Gen2
----Solution----Answer: A
You have a Fabric workspace that contains a warehouse named
Warehouse1. Data is loaded daily into Warehouse1 by using data
pipelines and stored procedures.You discover that the daily data load
takes longer than expected.You need to monitor Warehouse1 to identify
the names of users that are actively running queries.Which view should
you use?
A. sys.dm_exec_connections
B. sys.dm_exec_requests
C. queryinsights.long_running_queries
D. queryinsights.frequently_run_queriesE. sys.dm_exec_sessions
----Solution----Answer: A
Security in Fabric must meet the following requirements:The data
engineers must have read and write access to all the lakehouses,
including the underlying files.The data analysts must only have read
access to the Delta tables in the gold layer.The data analysts must NOT
have access to the data in the bronze and silver layers.The data engineers
must be able to commit changes to source control in WorkspaceA.You
need to ensure that the data analysts can access the gold layer
DP600 – MICROSOFT Fabrics Actual
Exam Newest /DP600 – MICROSOFT
Fabrics Practice Exam /DP600 –
MICROSOFT Fabrics Preparation With
350 Questions And Correct Answers
With Rationales| Already Graded A+|
Brand New!!!
You have a Fabric workspace named Workspace1.You plan to integrate
Workspace1 with Azure DevOps.You will use a Fabric deployment
pipeline named deployPipeline1 to deploy items from Workspace1 to
higher environment workspaces as part of a medallion architecture. You
will run deployPipeline1 by using an API call from an Azure DevOps
pipeline.You need to configure API authentication between Azure
DevOps and Fabric.Which type of authentication should you use?
A. service principal
B. Microsoft Entra username and password
C. managed private endpoint
D. workspace identity
----Solution----Answer: A
You have a Fabric workspace named Workspace1 that contains a
notebook named Notebook1.In Workspace1, you create a new notebook
,2 | Page
named Notebook2.You need to ensure that you can attach Notebook2 to
the same Apache Spark session as Notebook1.What should you do?
A. Enable high concurrency for notebooks.
B. Enable dynamic allocation for the Spark pool.
C. Change the runtime version.
D. Increase the number of executors.
----Solution----Answer: A
You have a Fabric workspace that contains a warehouse named
Warehouse1.You have an on-premises Microsoft SQL Server database
named Database1 that is accessed by using an on-premises data
gateway.You need to copy data from Database1 to Warehouse1.Which
item should you use?
A. an Apache Spark job definition
B. a data pipeline
C. a Dataflow Gen1 dataflow
D. an eventstream
----Solution----Answer: B
You have a Fabric capacity that contains a workspace named
Workspace1. Workspace1 contains a lakehouse named Lakehouse1, a
data pipeline, a notebook, and several Microsoft Power BI reports.A user
named User1 wants to use SQL to analyze the data in Lakehouse1.You
need to configure access for User1. The solution must meet the
following requirements:What should you do?
,3 | Page
A.Share Lakehouse1 with User1 directly and select Read all SQL
endpoint data.
B.Assign User1 the Viewer role for Workspace1. Share Lakehouse1
with User1 and select Read all SQL endpoint data.
C.Share Lakehouse1 with User1 directly and select Build reports on the
default semantic model.
D.Assign User1 the Member role for Workspace1. Share Lakehouse1
with User1 and select Read all SQL endpoint data.
----Solution----Answer: B
You have a Fabric workspace named Workspace1 that contains an
Apache Spark job definition named Job1.You have an Azure SQL
database named Source1 that has public internet access disabled.You
need to ensure that Job1 can access the data in Source1.What should you
create?
A.an on-premises data gateway
B.a managed private endpoint
C.an integration runtime
D.a data management gateway
----Solution----Answer: B
You have a Fabric workspace that contains a lakehouse named
Lakehouse1.In an external data source, you have data files that are 500
GB each. A new file is added every day.You need to ingest the data into
Lakehouse1 without applying any transformations. The solutionmust
meet the following requirements Trigger the process when a new file is
, 4 | Page
added.Provide the highest throughput.Which type of item should you use
to ingest the data?
A. Data pipeline
B. Environment
C. KQL queryset
D. Dataflow Gen2
----Solution----Answer: A
You have a Fabric workspace that contains a warehouse named
Warehouse1. Data is loaded daily into Warehouse1 by using data
pipelines and stored procedures.You discover that the daily data load
takes longer than expected.You need to monitor Warehouse1 to identify
the names of users that are actively running queries.Which view should
you use?
A. sys.dm_exec_connections
B. sys.dm_exec_requests
C. queryinsights.long_running_queries
D. queryinsights.frequently_run_queriesE. sys.dm_exec_sessions
----Solution----Answer: A
Security in Fabric must meet the following requirements:The data
engineers must have read and write access to all the lakehouses,
including the underlying files.The data analysts must only have read
access to the Delta tables in the gold layer.The data analysts must NOT
have access to the data in the bronze and silver layers.The data engineers
must be able to commit changes to source control in WorkspaceA.You
need to ensure that the data analysts can access the gold layer
