This is the free Microsoft DP-700 practice question bank —
70 of 132 total questions, each with a full explanation, free to
read with no signup required. Updated 2026-08-05.
Every answer is verified against official Microsoft documentation —
see our methodology.
Question 1
You have a Fabric workspace named Workspace1 that uses version control. Workspace1 and Azure DevOps are integrated.
In Azure DevOps, developers create a branch named Branch1 to test extract, transform, and load (ETL) updates.
You need to connect Workspace1 to Branch1. The solution must ensure that all the existing content in Branch1 is available in Workspace1.
What should you do?
A. From Workspace1, select Source control, and then select Sync.
B. From Workspace1, select Source control, select Current branch, select Branch1, and then select Commit.
C. From Azure DevOps, merge the contents of the main branch into Branch1.
D. From Workspace1, select Source control, and then select Branch out to new workspace.
Show Answer
Correct Answer: D
Explanation: To connect work to a different development branch while ensuring that the branch's existing content is available, Fabric's recommended workflow is to branch out to a new workspace. This creates a separate workspace connected to the target branch, after which the branch content is synchronized into that workspace. A Sync operation alone updates the currently connected branch; Commit pushes workspace changes to Git and does not switch branches.
Sources:
https://learn.microsoft.com/en-us/fabric/cicd/git-integration/manage-branches
Question 2
You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Table1.
You need to ensure that a user named User1 can view only specific rows in Table1.
What should you do first?
A. Create a security predicate.
B. Create a function.
C. Create a security policy.
D. Grant User1 the SELECT permission for Table1.
Show Answer
Correct Answer: B
Explanation: Row-level security in Fabric SQL endpoints/lakehouses is implemented by first creating an inline table-valued function that defines the filtering logic. That function is then referenced by a security policy to create the security predicate, after which appropriate SELECT permissions are granted. Therefore, the first step is to create the function.
Question 3
You have a Fabric workspace that contains a data pipeline named Pipeline1 and a notebook named Notebook1. Pipeline1 contains an activity that is used to run Notebook1. Pipeline1 is scheduled to run every 10 minutes.
You receive an alert that Pipeline1 failed during the notebook execution activity.
You need to identify in which cell the failure occurred.
What should you do from Monitor in the Fabric admin center?
A. Select the entry for the notebook execution, and then select the logs.
B. Select the entry for the notebook execution, and then view the item snapshot.
C. Select the entry for the pipeline execution, and then view the activity run.
D. Select the entry for the pipeline execution, and then select the output.
Show Answer
Correct Answer: A
Explanation: To determine which notebook cell failed, you need the notebook execution details. From Monitor, open the notebook execution entry and view its logs, which include cell-by-cell execution information and the error location. Pipeline-level activity runs or outputs identify the failed activity but not the specific notebook cell, and the item snapshot shows the submitted artifact rather than detailed execution logs.
Question 4
HOTSPOT
-
You have a Fabric workspace named Workspace1 that contains an Azure Data Factory pipeline named Pipeline1.
You need to monitor the execution and activity status of Pipeline1 and automatically email an alert if the pipeline fails. The solution must minimize development and administrative effort.
What should you use to monitor Pipeline1, and what should you use to email the alert? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Monitor Pipeline1: Monitor hub
Email alert: A Microsoft Power Automate flow
Explanation: Fabric Monitor hub is the built-in place to monitor Data Factory pipeline runs and activity status. To minimize development and administration for email notifications, use a Power Automate flow triggered from monitoring/alerts to send email.
Question 5
You have an Azure subscription that contains a blob storage account named sa1. sa1 contains two files named File1.csv and File2.csv.
You have a Fabric tenant that contains the items shown in the following table.
You need to configure Pipeline1 to perform the following actions:
• At 2 PM each day, process File1.csv and load the file into flh1.
• At 5 PM each day, process File2.csv and load the file into flh1.
The solution must minimize development effort.
What should you use?
A. a data pipeline trigger
B. a data pipeline schedule
C. a job definition
D. an activator
Show Answer
Correct Answer: A
Explanation: Use data pipeline triggers to run the same pipeline at specific times and pass different parameters (such as the source file) for each execution. Create two scheduled triggers: one at 2 PM for File1.csv and one at 5 PM for File2.csv. This minimizes development effort by reusing a single pipeline with parameterized input.
Question 6
You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1.
You perform the following actions:
• Connect Workspace1 to a Git repository and select the main branch.
• Create a new branch named feature1 and modify Lakehouse1.
• Merge the changes from feature1 into the main branch.
You need to ensure that the changes are available in Workspace1. The solution must minimize changes to Workspace1.
What should you do?
A. Disconnect Workspace1 from the Git repository and reconnect Workspace1 to the main branch.
B. From Workspace1, select Source control, and then select Updates.
C. From Workspace1, select Source control, and then select Commit.
D. Switch Workspace1 to the feature1 branch and refresh the workspace.
Show Answer
Correct Answer: B
Explanation: After merging changes from the feature branch into the main branch, the Git repository has newer content than the connected workspace. In Fabric Git integration, selecting Source control > Updates pulls the latest changes from the connected branch (main) into the workspace. This synchronizes the workspace with the merged changes while minimizing changes to the workspace. Committing would push workspace changes to Git, switching branches is unnecessary, and disconnecting/reconnecting is not required.
Question 7
HOTSPOT
-
You have a Fabric workspace.
You plan to deploy two Apache Spark environments that will each contain one of the following notebooks:
• Notebook1: A data ingestion notebook that will run as a scheduled Spark job
• Notebook2: An ad hoc notebook for interactive data analysis that will be used by a team of analysts and data scientists
You need to configure the Spark environments to meet the following requirements:
• For the environment that contains Notebook1, minimize compute costs.
• For the environment that contains Notebook2, support multiple concurrent users.
What should you use for each environment? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Notebook1: A serverless Spark environment
Notebook2: A custom Spark pool that has multiple nodes
Explanation: Serverless Spark minimizes costs for scheduled jobs by allocating compute on demand. A custom Spark pool with multiple nodes is appropriate for interactive workloads used concurrently by multiple analysts.
Question 8
HOTSPOT
-
You have a Fabric workspace that contains a large table named Table1. Table1 contains 2 billion rows.
You have a data source that generates a data file every 30 minutes. The file contains only changes that occurred since the last file was generated.
You plan to deploy a data pipeline that will process each data file when it is generated and load the contents into Table1.
You need to recommend which loading pattern to use for the following operations:
• Create new records.
• Delete existing records.
The solution must support the versioning of existing records.
What should you recommend for each operation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Create new records: Incremental
Delete existing records: Incremental
Explanation: The source provides change-only files every 30 minutes, so incremental processing is appropriate for inserts and deletes. To support versioning of existing records, apply incremental upserts/deletes using a versioned pattern (such as SCD or Delta history) rather than reloading full or snapshot data.
Question 9
You have a Fabric workspace that contains a lakehouse named Lakehouse1, a Dataflow Gen2 named Dataflow1, and a pipeline named Pipeline1. Dataflow1 loads data into Lakehouse1.
You need to ensure that Dataflow1 always performs a full data load into Lakehouse1. The solution must minimize how long it takes to load the data.
What should you do?
A. Change the pipeline templates.
B. For Dataflow1, set Update method to Replace.
C. To Dataflow1, add a data preview.
D. To Pipeline1, add an activity to invoke a SQL script.
Show Answer
Correct Answer: B
Explanation: Setting the Dataflow Gen2 destination Update method to Replace causes the target table in the lakehouse to be fully overwritten on each run, achieving a full load without requiring separate delete or SQL steps. This is more efficient than invoking SQL to truncate and reload, and the other options do not control full-load behavior.
Question 10
You have a Fabric lakehouse that contains the resources shown in the following table.
You need to use a notebook to query for customers in the United States and load the filtered data into USCustomers. The solution must minimize the number of scripts used.
Which statement should you use?
A. customers.write.format("parquet").mode("append").saveAsTable("USCustomers")
B. customers.write.format("delta").mode("overwrite").save("Tables/USCustomers")
C. customers.write.format("delta").mode("overwrite").saveAsTable("USCustomers")
D. customers.write. format("parquet").mode("append").save("Tables/USCustomers")
Show Answer
Correct Answer: C
Explanation: In a Fabric Lakehouse, managed tables use Delta format. Writing the filtered DataFrame as a managed table with saveAsTable avoids specifying a storage path, minimizing scripting. Using overwrite replaces the table contents with the current filtered US customer dataset rather than appending duplicates. Parquet options do not create the preferred managed Delta table.
$19
Get all 132 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.
