Microsoft DP-700 Practice Exams
Last updated on Nov 16,2026- Exam Code: DP-700
- Exam Name: Microsoft Fabric Data Engineer
- Certification Provider: Microsoft
- Latest update: Nov 16,2026
You have a Fabric workspace that contains an eventstream named EventStream1. EventStream1 outputs events to a table in a lakehouse.
You need to remove files that are older than seven days and are no longer in use.
Which command should you run?
- A . VACUUM
- B . COMPUTE
- C . OPTIMIZE
- D . CLONE
A
Explanation:
VACUUM is used to clean up storage by removing files no longer in use by a Delta table. It removes old and unreferenced files from Delta tables. For example, to remove files older than 7 days: VACUUM delta.`/path_to_table` RETAIN 7 HOURS;
What should you do to optimize the query experience for the business users?
- A . Enable V-Order.
- B . Create and update statistics.
- C . Run the VACUUM command.
- D . Introduce primary keys.
You have a Fabric workspace that contains a lakehouse and a notebook named Notebook1. Notebook1 reads data into a DataFrame from a table named Table1 and applies transformation logic. The data from the DataFrame is then written to a new Delta table named Table2 by using a merge operation.
You need to consolidate the underlying Parquet files in Table1.
Which command should you run?
- A . VACUUM
- B . BROADCAST
- C . OPTIMIZE
- D . CACHE
C
Explanation:
To consolidate the underlying Parquet files in Table1 and improve query performance by optimizing the data layout, you should use the OPTIMIZE command in Delta Lake. The OPTIMIZE command coalesces smaller files into larger ones and reorganizes the data for more efficient reads. This is particularly useful when working with large datasets in Delta tables, as it helps reduce the number of files and improves performance for subsequent queries or operations like MERGE.
You need to ensure that the data analysts can access the gold layer lakehouse.
What should you do?
- A . Add the DataAnalyst group to the Viewer role for WorkspaceA.
- B . Share the lakehouse with the DataAnalysts group and grant the Build reports on the default semantic model permission.
- C . Share the lakehouse with the DataAnalysts group and grant the Read all SQL Endpoint data permission.
- D . Share the lakehouse with the DataAnalysts group and grant the Read all Apache Spark permission.
C
Explanation:
Data Analysts’ Access Requirements must only have read access to the Delta tables in the gold layer and not have access to the bronze and silver layers.
The gold layer data is typically queried via SQL Endpoints. Granting the Read all SQL Endpoint data permission allows data analysts to query the data using familiar SQL-based tools while restricting access to the underlying files.
HOTSPOT
HOTSPOT
You have a Fabric workspace named Workspace1_DEV that contains the following items:
– 10 reports
– Four notebooks
– Three lakehouses
– Two data pipelines
– Two Dataflow Gen1 dataflows
– Three Dataflow Gen2 dataflows
– Five semantic models that each has a scheduled refresh policy
You create a deployment pipeline named Pipeline1 to move items from Workspace1_DEV to a new workspace named Workspace1_TEST.
You deploy all the items from Workspace1_DEV to Workspace1_TEST.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.


You have a Fabric workspace named Workspace1.
You plan to configure Git integration for Workspacel by using an Azure DevOps Git repository. An Azure DevOps admin creates the required artifacts to support the integration of Workspacel
Which details do you require to perform the integration?
- A . the project, Git repository, branch, and Git folder
- B . the organization, project. Git repository, and branch
- C . the Git repository URL and the Git folder
- D . the personal access token (PAT) for Git authentication and the Git repository URL
You need to develop an orchestration solution in fabric that will load each item one after the other. The solution must be scheduled to run every 15 minutes.
Which type of item should you use?
- A . warehouse
- B . data pipeline
- C . Dataflow Gen2 dataflow
- D . notebook
You have five Fabric workspaces.
You are monitoring the execution of items by using Monitoring hub.
You need to identify in which workspace a specific item runs.
Which column should you view in Monitoring hub?
- A . Start time
- B . Capacity
- C . Activity name
- D . Submitter
- E . Item type
- F . Job type
- G . Location
G
Explanation:
To identify in which workspace a specific item runs in Monitoring hub, you should view the Location column. This column indicates the workspace where the item is executed. Since you have multiple workspaces and need to track the execution of items across them, the Location column will show you the exact workspace associated with each item or job execution.
You have a Fabric workspace that contains a semantic model named Modell. You need to monitor the refresh history of Model 1 and visualize the refresh history in a chart.
What should you use?
- A . the refresh history from the settings of Model1.
- B . a notebook
- C . a Dataflow Gen2 dataflow
- D . a data pipeline
You have a Fabric warehouse named DW1. DW1 contains a table that stores sales data and is used by multiple sales representatives.
You plan to implement row-level security (RLS).
You need to ensure that the sales representatives can see only their respective data.
Which warehouse object do you require to implement RLS?
- A . ISTORED PROCEDURE
- B . CONSTRAINT
- C . SCHEMA
- D . FUNCTION
D
Explanation:
To implement Row-Level Security (RLS) in a Fabric warehouse, you need to use a function that defines the security logic for filtering the rows of data based on the user’s identity or role. This function can be used in conjunction with a security policy to control access to specific rows in a table.
In the case of sales representatives, the function would define the filtering criteria (e.g., based on a column such as SalesRepID or SalesRepName), ensuring that each representative can only see their respective data.