📘 Free DP-600 Sample Questions
Case study -
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to
complete each case. However, there may be additional case studies and sections on this exam. You must manage
your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the
case study. Case studies might contain exhibits and other resources that provide more information about the
scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to
make changes before you move to the next section of the exam. After you begin a new section, you cannot return
to this section.
A
Store at the semantic models and reports in Data Lake Gen2 storage.
B
Modify the settings of the Research workspaces to use a GitHub repository.
C
Modify the settings of the Research division workspaces to use an Azure Repos repository.
D
Store all the semantic models and reports in Microsoft OneDrive.
Correct Answer:
C. Modify the settings of the Research division workspaces to use an Azure Repos repository.
Explanation:
Modify the settings of the Research division workspaces to use an Azure Repos repository.Only Git currently
supported.
Reference:
https://learn.microsoft.com/en-us/fabric/cicd/git-integration/intro-to-git-integration
HOTSPOT -
Case study -
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to
complete each case. However, there may be additional case studies and sections on this exam. You must manage
your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the
case study. Case studies might contain exhibits and other resources that provide more information about the
scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to
make changes before you move to the next section of the exam. After you begin a new section, you cannot return
to this section.
A
Correct Answer:
A.
Explanation:
Domain.
The Fabric Admin Portal.
Reference:
https://learn.microsoft.com/en-us/fabric/governance/domains#configure-domain-settings
Case study-
This is a case study. Case Studies are not timed separately. You can use much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage
your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the
case study. Case studies might contain exhibits and other resources that provide more information about the
scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to
make changes before you move to the next section of the exam. After you begin a new section, you cannot return
to this section.
A
an Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the maximum value of
the OrderID column in the destination lakehouse
B
an Azure Data Factory pipeline that executes a Stored procedure activity to retrieve the minimum value of the
OrderID column in the destination lakehouse
C
an Azure Data Factory pipeline that executes a dataflow to retrieve the minimum value of the OrderID column
in the destination lakehouse
D
an Azure Data Factory pipeline that executes a dataflow to retrieve the maximum value of the OrderID
column in the destination lakehouse
Correct Answer:
D. an Azure Data Factory pipeline that executes a dataflow to retrieve the maximum value of the OrderID
column in the destination lakehouse
Explanation:
D. an Azure Data Factory pipeline that executes a dataflow to retrieve the maximum value of the OrderID
column in the destination lakehouse. A dataflow can be used to retrieve the max OrderID number (stored in
the destination table - OrderID is a sequencial number). This number can be used to set from which row data
must be added to the destination table (implementing an incremental load).
Case study -
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to
complete each case. However, there may be additional case studies and sections on this exam. You must manage
your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the
case study. Case studies might contain exhibits and other resources that provide more information about the
scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to
make changes before you move to the next section of the exam. After you begin a new section, you cannot return
to this section.
A
spark.read.format(“delta”).load(“Tables/productline1/ResearchProduct”)
B
spark.sql(“SELECT * FROM Lakehouse1.ResearchProduct ”)
C
external_table(‘Tables/ResearchProduct)
D
external_table(ResearchProduct)
Correct Answer:
B. spark.sql(“SELECT * FROM Lakehouse1.ResearchProduct ”)
Explanation:
spark.sql(“SELECT * FROM Lakehouse1.ResearchProduct ”)
The syntax of C and D is correct for KQL databases (incorrect in this use-case). When the shortcut is created,
no additional folders have been added to the Tables section, therefore answer A is incorrect. Once created,
the line of answer B can be used to access data correctly.
https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts
HOTSPOT -
Case study -
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to
complete each case. However, there may be additional case studies and sections on this exam. You must manage
your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the
case study. Case studies might contain exhibits and other resources that provide more information about the
scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to
make changes before you move to the next section of the exam. After you begin a new section, you cannot return
to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore
the content of the case study before you answer the questions. Clicking these buttons displays information such
as business requirements, existing environment, and problem statements. If the case study has an All Information
tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you
are ready to answer a question, click the Question button to return to the question.
Overview -
Litware, Inc. is a manufacturing company that has offices throughout North America. The analytics team at Litware
contains data engineers, analytics engineers, data analysts, and data scientists.
Existing Environment -
Fabric Environment -
Litware has been using a Microsoft Power BI tenant for three years. Litware has NOT enabled any Fabric capacities
and features.
Available Data -
Litware has data that must be analyzed as shown in the following table.
A
Correct Answer:
A.
Explanation:
Data Engineers: Read all Apache Spark - because they need to be able to work with Spark for Data curation.
Data Analysts: Build Reports on the default dataset - because they are report builders
Data Scientists: Read All SQL analytics Endpoints data_ They leverage curated data (by engineers) to do
predictive analytics.
HOTSPOT -
Case study -
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to
complete each case. However, there may be additional case studies and sections on this exam. You must manage
your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the
case study. Case studies might contain exhibits and other resources that provide more information about the
scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to
make changes before you move to the next section of the exam. After you begin a new section, you cannot return
to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore
the content of the case study before you answer the questions. Clicking these buttons displays information such
as business requirements, existing environment, and problem statements. If the case study has an All Information
tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you
are ready to answer a question, click the Question button to return to the question.
Overview -
Litware, Inc. is a manufacturing company that has offices throughout North America. The analytics team at Litware
contains data engineers, analytics engineers, data analysts, and data scientists.
Existing Environment -
Fabric Environment -
Litware has been using a Microsoft Power BI tenant for three years. Litware has NOT enabled any Fabric capacities
and features.
Available Data -
Litware has data that must be analyzed as shown in the following table.
A
Correct Answer:
A.
Explanation:
View
CASE
WHEN List Price BETWEEN 50 AND 1000)THEN 'medium'.
Case study -
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
A
a stored procedure
B
a pipeline that contains a KQL activity
C
a Spark notebook
D
a dataflow
Correct Answer:
D. a dataflow
Explanation:
D. a dataflow.
Even though the text reads "Data will be loaded without transformation in one area of the AnalyticsPOC data
store": in general, dataflows are used when data transformations are involved after ingestion. As suggested
by user BHARAT, the Copy Activity should be the optimal solution
Case study -
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to
complete each case. However, there may be additional case studies and sections on this exam. You must manage
your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the
case study. Case studies might contain exhibits and other resources that provide more information about the
scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to
make changes before you move to the next section of the exam. After you begin a new section, you cannot return
to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore
the content of the case study before you answer the questions. Clicking these buttons displays information such
as business requirements, existing environment, and problem statements. If the case study has an All Information
tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you
are ready to answer a question, click the Question button to return to the question.
Overview -
Litware, Inc. is a manufacturing company that has offices throughout North America. The analytics team at Litware
contains data engineers, analytics engineers, data analysts, and data scientists.
Existing Environment -
Fabric Environment -
Litware has been using a Microsoft Power BI tenant for three years. Litware has NOT enabled any Fabric capacities
and features.
Available Data -
Litware has data that must be analyzed as shown in the following table.
A
a data lake
B
a warehouse
C
a lakehouse
D
an external Hive metastore
Correct Answer:
C. a lakehouse
Explanation:
A lakehouse The data store must handle semi-structured and unstructured data, therefore a Lakehouse
should be the optimal solution supporting read access with T-SQL and Python.
You have a Fabric warehouse that contains a table named Staging.Sales. Staging.Sales contains the following
columns.
A
Correct Answer:
A.
Explanation:
A. SELECT ProductID, ProductName, SUM(Amount) AS TotalAmount
FROM Staging.Sales
WHERE DATEPART(YEAR, SaleDate) = '2023'
GROUP BY ProductID, ProductName
HOTSPOT -
You have a data warehouse that contains a table named Stage.Customers. Stage.Customers contains all the
customer record updates from a customer relationship management (CRM) system. There can be multiple updates
per customer.
You need to write a T-SQL query that will return the customer ID, name. postal code, and the last updated time of
the most recent row for each customer ID.
How should you complete the code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.