DP600 - Microsoft Fabrics Exam
DP600 - MICROSOFT FABRICS EXAM NEWEST 2025/2026 WITH
COMPLETE QUESTIONS AND CORRECT ANSWERS |ALREADY
GRADED A+||BRAND NEW VERSION!
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?
a. Add Column From Example
b. Conditional Column
c. Replace Values
d. Split Column
d
Fill in the blank: "A basic KQL query follows the pattern: <table_name> | where
<condition> | (...) <columns>."
s. select
b. display
c. project
d. show
c
The use of SQL or SQL Functions within a KQL Queryset removes the ability to .....
with it.
a. perform data analytics
b. create visualizations
c. build Power BI Reports
d. execute complex algorithms
1|Page
, DP600 - Microsoft Fabrics Exam
c
How can SQL queries be translated into KQL in Microsoft Fabric?
s. By using the -- convert syntax
b. By using the -- translate syntax
c. By using the -- adapt syntax
d. By using the -- explain syntax
d
T-SQL cannot be run against a Microsoft Fabric KQL database.
a. TRUE
b. FALSE
b
Using T-SQL over KQL in Microsoft Fabric allows for direct publishing to Power BI
from the Queryset
a. TRUE
b. FALSE
b
What is the purpose of using the project operator in KQL queries?
a. To perform aggregations such as count, sum, and avg.
b. To specify which columns to include in your query output.
c. To filter data based on specific conditions.
b
What does KQL allow a data consumer to do with data from various sources?
a. KQL allows you to create your own custom functions in KQL to perform specific
data analysis tasks.
2|Page
, DP600 - Microsoft Fabrics Exam
b. KQL allows you to ingest data from various sources such as Azure Event Hubs,
Azure IoT Hub, and Azure Storage.
c. KQL allows you to export query results to various destinations such as Azure
Blob Storage, Azure Data Lake Storage, and Azure Event Hubs.
b
What does the Fabric Main Editor enable a data consumer to do?
a. Create and link object to read and write objects to a lakehouse
b. Query a KQL database
c. Create a Microsoft Fabric Eventstream
a
You are profiling the data stored in a Fabric lakehouse.You run the following
statement.df.describe().show()Which three functions will be included in the
results for the numeric data?
a. AVG
b. COUNT
c. DISTINCTCOUNT
d. MEAN
e. STD (standard deviation)
f. TOP
g. MIN MAX
b, d, e, g
You are profiling the data stored in a Fabric lakehouse.You run the following
statement.df.describe().show()Which three functions will be included in the
results for the object data?
a. AVG
3|Page
, DP600 - Microsoft Fabrics Exam
b. COUNT
c. DISTINCTCOUNT
d. MEAN
e. STD (standard deviation)
f. TOP
g. MIN MAX
h. UNIQUE
i. FREQ
f, h, i
You have a Fabric tenant that contains a workspace named Workspace1.
Workspace1 contains a lakehouse. The lakehouse contains a table named
Customers and a Fabric notebook.You plan to use the notebook to profile the data.
In the notebook, you set up the following DataFrame that references the
Customers table.
df = Spark.sql("Select * from Customers")
You need to profile the data in the DataFrame. The solution must minimize
administrative effort.What should you do?
a. Create a pandas DataFrame first, and then visualize the data in an embedded
Microsoft Power BI report by running QuickVisualize method on the pandas
DataFrame.
b. Display the DataFrame by running display(df), and then clicking the Inspect
button.
c. Display the DataDrame by running display(df), and then switching to chart view.
d. Visualize the data in an embedded Microsoft Power BI report by running the
QuickVisualize method on the DataFrame.
b
4|Page
DP600 - MICROSOFT FABRICS EXAM NEWEST 2025/2026 WITH
COMPLETE QUESTIONS AND CORRECT ANSWERS |ALREADY
GRADED A+||BRAND NEW VERSION!
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?
a. Add Column From Example
b. Conditional Column
c. Replace Values
d. Split Column
d
Fill in the blank: "A basic KQL query follows the pattern: <table_name> | where
<condition> | (...) <columns>."
s. select
b. display
c. project
d. show
c
The use of SQL or SQL Functions within a KQL Queryset removes the ability to .....
with it.
a. perform data analytics
b. create visualizations
c. build Power BI Reports
d. execute complex algorithms
1|Page
, DP600 - Microsoft Fabrics Exam
c
How can SQL queries be translated into KQL in Microsoft Fabric?
s. By using the -- convert syntax
b. By using the -- translate syntax
c. By using the -- adapt syntax
d. By using the -- explain syntax
d
T-SQL cannot be run against a Microsoft Fabric KQL database.
a. TRUE
b. FALSE
b
Using T-SQL over KQL in Microsoft Fabric allows for direct publishing to Power BI
from the Queryset
a. TRUE
b. FALSE
b
What is the purpose of using the project operator in KQL queries?
a. To perform aggregations such as count, sum, and avg.
b. To specify which columns to include in your query output.
c. To filter data based on specific conditions.
b
What does KQL allow a data consumer to do with data from various sources?
a. KQL allows you to create your own custom functions in KQL to perform specific
data analysis tasks.
2|Page
, DP600 - Microsoft Fabrics Exam
b. KQL allows you to ingest data from various sources such as Azure Event Hubs,
Azure IoT Hub, and Azure Storage.
c. KQL allows you to export query results to various destinations such as Azure
Blob Storage, Azure Data Lake Storage, and Azure Event Hubs.
b
What does the Fabric Main Editor enable a data consumer to do?
a. Create and link object to read and write objects to a lakehouse
b. Query a KQL database
c. Create a Microsoft Fabric Eventstream
a
You are profiling the data stored in a Fabric lakehouse.You run the following
statement.df.describe().show()Which three functions will be included in the
results for the numeric data?
a. AVG
b. COUNT
c. DISTINCTCOUNT
d. MEAN
e. STD (standard deviation)
f. TOP
g. MIN MAX
b, d, e, g
You are profiling the data stored in a Fabric lakehouse.You run the following
statement.df.describe().show()Which three functions will be included in the
results for the object data?
a. AVG
3|Page
, DP600 - Microsoft Fabrics Exam
b. COUNT
c. DISTINCTCOUNT
d. MEAN
e. STD (standard deviation)
f. TOP
g. MIN MAX
h. UNIQUE
i. FREQ
f, h, i
You have a Fabric tenant that contains a workspace named Workspace1.
Workspace1 contains a lakehouse. The lakehouse contains a table named
Customers and a Fabric notebook.You plan to use the notebook to profile the data.
In the notebook, you set up the following DataFrame that references the
Customers table.
df = Spark.sql("Select * from Customers")
You need to profile the data in the DataFrame. The solution must minimize
administrative effort.What should you do?
a. Create a pandas DataFrame first, and then visualize the data in an embedded
Microsoft Power BI report by running QuickVisualize method on the pandas
DataFrame.
b. Display the DataFrame by running display(df), and then clicking the Inspect
button.
c. Display the DataDrame by running display(df), and then switching to chart view.
d. Visualize the data in an embedded Microsoft Power BI report by running the
QuickVisualize method on the DataFrame.
b
4|Page
