1|Page
DP600 – MICROSOFT Fabrics Actual Exam
Newest 2026-2027 /DP600 – MICROSOFT Fabrics
Practice Exam /DP600 – MICROSOFT Fabrics
Preparation With 150 Questions And Correct
Answers With Rationales| Already Graded A+
You are planning a Fabric analytics solution for the following users:
2,000 Microsoft Power BI consumers without an individual Power BI
Pro license.
32 Power BI modelers with an individual Power BI Pro license.
16 data scientists
You need to recommend a Fabric capacity SKU. The solution must
minimize costs.
What should you recommend?
F64
You have a Fabric workspace that contains a lakehouse named
Lakehouse1.
A user named User1 plans to use Lakehouse explorer to read
Lakehouse1 data.
,2|Page
You need to assign a workspace role to User1. The solution must follow
the principle of least privilege.
Which workspace role should you assign to User1?
Contributor
You have a Fabric tenant that contains a workspace named Workspace1.
Workspace1 contains a lakehouse, a data pipeline, a notebook, and
several Microsoft Power BI reports.
A user named User1 plans to use SQL to access the lakehouse to analyze
data. User1 must have the following access:
User1 must have read-only access to the lakehouse.
User1 must NOT be able to access the rest of the items in Workspace1.
User1 must NOT be able to use Spark to query the underlying files in
the lakehouse.
You need to configure access for User1.
What should you do?
Share the lakehouse with User1 directly and select Read all SQL
Endpoint data.
You have a Fabric tenant.
You notice a Fabric compute usage issue, which is causing performance
issues.
,3|Page
You need to increase the Fabric capacity unit size.
What should you use?
Azure portal
You have a Fabric tenant that has XMLA Endpoint set to Read Write.
You need to use the XMLA endpoint to deploy changes to only one table
from the data model.
What is the main limitation of using XMLA endpoints for the Microsoft
Power BI deployment process?
A PBIX file cannot be downloaded from the Power BI service.
You have a Fabric tenant that contains a lakehouse.
On a local computer, you have a CSV file that contains a static list of
company office locations.
You need to recommend a method to perform a one-time copy to ingest
the CSV file into the lakehouse. The solution must minimize
administrative effort.
Which method should you recommend?
a local file upload by using Lakehouse explorer
, 4|Page
You have a Fabric tenant that contains two lakehouses named
Lakehouse1 and Lakehouse2. Lakehouse1 contains a table named
FactSales that is partitioned by a column named CustomerID.
You need to create a shortcut to the FactSales table in Lakehouse2. The
shortcut must only connect to data for CustomerID 100.
What should you do?
As you create the shortcut, select the CustomerKey=100 folder under the
FactSales folder in Tables.
You have a Fabric workspace. The workspace contains a Dataflow Gen2
query that displays dimensional product information. The query table
contains a column named Product ID/Name that is a concatenation of
Product ID and Product Name values.
You need to use an applied step in Microsoft Power Query Editor to
create a new column for Product ID and Product Name. The solution
must use a single command to create two new columns and remove the
original combined (Product ID/Name) column.
Which applied step should you use?
Split Column
You have a Fabric workspace that contains a Microsoft Power BI report.
You need to modify the column names in the Power BI report without
changing the original names in the underlying Delta table.
DP600 – MICROSOFT Fabrics Actual Exam
Newest 2026-2027 /DP600 – MICROSOFT Fabrics
Practice Exam /DP600 – MICROSOFT Fabrics
Preparation With 150 Questions And Correct
Answers With Rationales| Already Graded A+
You are planning a Fabric analytics solution for the following users:
2,000 Microsoft Power BI consumers without an individual Power BI
Pro license.
32 Power BI modelers with an individual Power BI Pro license.
16 data scientists
You need to recommend a Fabric capacity SKU. The solution must
minimize costs.
What should you recommend?
F64
You have a Fabric workspace that contains a lakehouse named
Lakehouse1.
A user named User1 plans to use Lakehouse explorer to read
Lakehouse1 data.
,2|Page
You need to assign a workspace role to User1. The solution must follow
the principle of least privilege.
Which workspace role should you assign to User1?
Contributor
You have a Fabric tenant that contains a workspace named Workspace1.
Workspace1 contains a lakehouse, a data pipeline, a notebook, and
several Microsoft Power BI reports.
A user named User1 plans to use SQL to access the lakehouse to analyze
data. User1 must have the following access:
User1 must have read-only access to the lakehouse.
User1 must NOT be able to access the rest of the items in Workspace1.
User1 must NOT be able to use Spark to query the underlying files in
the lakehouse.
You need to configure access for User1.
What should you do?
Share the lakehouse with User1 directly and select Read all SQL
Endpoint data.
You have a Fabric tenant.
You notice a Fabric compute usage issue, which is causing performance
issues.
,3|Page
You need to increase the Fabric capacity unit size.
What should you use?
Azure portal
You have a Fabric tenant that has XMLA Endpoint set to Read Write.
You need to use the XMLA endpoint to deploy changes to only one table
from the data model.
What is the main limitation of using XMLA endpoints for the Microsoft
Power BI deployment process?
A PBIX file cannot be downloaded from the Power BI service.
You have a Fabric tenant that contains a lakehouse.
On a local computer, you have a CSV file that contains a static list of
company office locations.
You need to recommend a method to perform a one-time copy to ingest
the CSV file into the lakehouse. The solution must minimize
administrative effort.
Which method should you recommend?
a local file upload by using Lakehouse explorer
, 4|Page
You have a Fabric tenant that contains two lakehouses named
Lakehouse1 and Lakehouse2. Lakehouse1 contains a table named
FactSales that is partitioned by a column named CustomerID.
You need to create a shortcut to the FactSales table in Lakehouse2. The
shortcut must only connect to data for CustomerID 100.
What should you do?
As you create the shortcut, select the CustomerKey=100 folder under the
FactSales folder in Tables.
You have a Fabric workspace. The workspace contains a Dataflow Gen2
query that displays dimensional product information. The query table
contains a column named Product ID/Name that is a concatenation of
Product ID and Product Name values.
You need to use an applied step in Microsoft Power Query Editor to
create a new column for Product ID and Product Name. The solution
must use a single command to create two new columns and remove the
original combined (Product ID/Name) column.
Which applied step should you use?
Split Column
You have a Fabric workspace that contains a Microsoft Power BI report.
You need to modify the column names in the Power BI report without
changing the original names in the underlying Delta table.
