DP600-MICROSOFT FABRIC EXAM/DP600-
MICROSOFT FABRIC PRACTICE EXAM
2026/2027 WITH ACTUAL CORRECT
QUESTIONS AND VERIFIED DETAILED
ANSWERS |CURRENTLY TESTING
QUESTIONS AND SOLUTIONS|ALREADY
GRADED A+|NEWEST|JUST
RELEASED!!|GUARANTEED PASS
You have a Fabric workspace that contains a data pipeline with a fact table and two dimension
tables. The fact table contains customer data. One dimension table contains customer
information and a column with Customer ID information, and the other dimension table
contains calendar information and a column with Date ID information.
You need to ensure that each customer's sales data is provisioned to their own Parquet file
under the Parquet folder structure.
Which data pipeline configuration should you implement?
Partition by customer ID on the fact table.
You have a Fabric workspace that contains a Microsoft Power BI report named Sales.
You plan to use Dataflow Gen2 to add an additional column to the report. The new column must
be based on the unit price of a product. Any product that has a unit price that is greater than
$1,000 must be labeled as High, while any product that has a unit price that is less than $1,000
must be labeled as Regular.
What should you select on the Add column tab in Power Query Editor?
Conditional column
1|Page
,You have a Fabric tenant that contains a lakehouse named Lakehouse1.
You have an external Snowflake database that contains a table with 200 million rows.
You need to use a data pipeline to migrate the database to Lakehouse1.
What is the most performant (fastest) method for ingesting data this large (200 million rows) by
using a data pipeline?
Data Pipeline (Copy data)
You have a Fabric workspace named Workspace1 that contains a data pipeline named Pipeline1.
You plan to use the Office 365 Outlook activity to send an email message each time Pipeline1
experiences issues with pipeline connectors.
You need to connect the Office 365 Outlook activity to each main pipeline activity. The solution
must minimize the number of email messages sent by the activity.
Which connection should you use for the Office 365 Outlook activity?
On fail
You have a Fabric workspace named Workspace1.
You plan to create a data pipeline to ingest data into Workspace1.
You need to ensure that the pipeline activity supports parameterization.
Which two activities support parameterization in the data pipeline UI? Each correct answer
presents part of the solution.
notebooks & SQL stored procedures
You have a Fabric workspace that contains a complex semantic model for a Microsoft Power BI
report.
You need to optimize the semantic model for analytical queries and use denormalization to
reduce the model complexity and the number of joins between tables.
Which tables should you denormalize?
2|Page
,Snowflaked dimension tables
You are designing a semantic model for a Microsoft Power BI report. You have a table named
Employee that contains the following columns: EmployeeID, EmployeeName, and
EmployeePosition. You have a table named Contract that contains the following columns:
EmployeeID and ContractType.
You plan to denormalize both tables and include the ContractType attribute.
You need to ensure that all the rows in the Employee table are preserved and include any
matching rows from the Contract table.
Which type of join should you specify in the Power Query Merge queries transformation?
Left outer
You have a Fabric warehouse.
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.
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.
3|Page
, 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.
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
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
4|Page
MICROSOFT FABRIC PRACTICE EXAM
2026/2027 WITH ACTUAL CORRECT
QUESTIONS AND VERIFIED DETAILED
ANSWERS |CURRENTLY TESTING
QUESTIONS AND SOLUTIONS|ALREADY
GRADED A+|NEWEST|JUST
RELEASED!!|GUARANTEED PASS
You have a Fabric workspace that contains a data pipeline with a fact table and two dimension
tables. The fact table contains customer data. One dimension table contains customer
information and a column with Customer ID information, and the other dimension table
contains calendar information and a column with Date ID information.
You need to ensure that each customer's sales data is provisioned to their own Parquet file
under the Parquet folder structure.
Which data pipeline configuration should you implement?
Partition by customer ID on the fact table.
You have a Fabric workspace that contains a Microsoft Power BI report named Sales.
You plan to use Dataflow Gen2 to add an additional column to the report. The new column must
be based on the unit price of a product. Any product that has a unit price that is greater than
$1,000 must be labeled as High, while any product that has a unit price that is less than $1,000
must be labeled as Regular.
What should you select on the Add column tab in Power Query Editor?
Conditional column
1|Page
,You have a Fabric tenant that contains a lakehouse named Lakehouse1.
You have an external Snowflake database that contains a table with 200 million rows.
You need to use a data pipeline to migrate the database to Lakehouse1.
What is the most performant (fastest) method for ingesting data this large (200 million rows) by
using a data pipeline?
Data Pipeline (Copy data)
You have a Fabric workspace named Workspace1 that contains a data pipeline named Pipeline1.
You plan to use the Office 365 Outlook activity to send an email message each time Pipeline1
experiences issues with pipeline connectors.
You need to connect the Office 365 Outlook activity to each main pipeline activity. The solution
must minimize the number of email messages sent by the activity.
Which connection should you use for the Office 365 Outlook activity?
On fail
You have a Fabric workspace named Workspace1.
You plan to create a data pipeline to ingest data into Workspace1.
You need to ensure that the pipeline activity supports parameterization.
Which two activities support parameterization in the data pipeline UI? Each correct answer
presents part of the solution.
notebooks & SQL stored procedures
You have a Fabric workspace that contains a complex semantic model for a Microsoft Power BI
report.
You need to optimize the semantic model for analytical queries and use denormalization to
reduce the model complexity and the number of joins between tables.
Which tables should you denormalize?
2|Page
,Snowflaked dimension tables
You are designing a semantic model for a Microsoft Power BI report. You have a table named
Employee that contains the following columns: EmployeeID, EmployeeName, and
EmployeePosition. You have a table named Contract that contains the following columns:
EmployeeID and ContractType.
You plan to denormalize both tables and include the ContractType attribute.
You need to ensure that all the rows in the Employee table are preserved and include any
matching rows from the Contract table.
Which type of join should you specify in the Power Query Merge queries transformation?
Left outer
You have a Fabric warehouse.
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.
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.
3|Page
, 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.
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
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
4|Page
