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 warehouse named DW1 that loads data by using a data pipeline named Pipeline1. Pipeline1 uses a Copy data activity with a dynamic SQL source. Pipeline1 is scheduled to run every 15 minutes.
You discover that Pipeline1 keeps failing.
You need to identify which SQL query was executed when the pipeline failed.
What should you do?
- A . From Monitoring hub, select the latest failed run of Pipeline1, and then view the output JSON.
- B . From Monitoring hub, select the latest failed run of Pipeline1, and then view the input JSON.
- C . From Real-time hub, select Fabric events, and then review the details of Microsoft.Fabric.ItemReadFailed.
- D . From Real-time hub, select Fabric events, and then review the details of Microsoft.
Fabric.ItemUpdateFailed.
B
Explanation:
The input JSON contains the configuration details and parameters passed to the Copy data activity during execution, including the dynamically generated SQL query.
Viewing the input JSON for the failed pipeline run provides direct insight into what query was executed at the time of failure.
You have an Azure Data Lake Storage Gen2 account named storage1 and an Amazon S3 bucket named storage2.
You have the Delta Parquet files shown in the following table.

You have a Fabric workspace named Workspace1 that has the cache for shortcuts enabled.
Workspace1 contains a lakehouse named Lakehouse1.
Lakehouse1 has the following shortcuts:
– A shortcut to ProductFile aliased as Products
– A shortcut to StoreFile aliased as Stores
– A shortcut to TripsFile aliased as Trips
The data from which shortcuts will be retrieved from the cache?
- A . Trips and Stores only
- B . Products and Store only
- C . Stores only
- D . Products only
- E . Products. Stores, and Trips
B
Explanation:
When the cache for shortcuts is enabled in Fabric, the data retrieval is governed by the caching behavior, which generally retains data for a specific period after it was last accessed. The data from the shortcuts will be retrieved from the cache if the data is stored in locations that support caching. Here’s a breakdown based on the data’s location:
Products: The ProductFile is stored in Azure Data Lake Storage Gen2 (storage1). Since Azure Data Lake is a supported storage system in Fabric and the file is relatively small (50 MB), this data is most likely cached and can be retrieved from the cache.
Stores: The StoreFile is stored in Amazon S3 (storage2), and even though it is stored in a different cloud provider, Fabric can cache data from Amazon S3 if caching is enabled. This data (25 MB) is likely cached and retrievable.
Trips: The TripsFile is stored in Amazon S3 (storage2) and is significantly larger (2 GB) compared to the other files. While Fabric can cache data from Amazon S3, the larger size of the file (2 GB) may exceed typical cache sizes or retention windows, causing this file to likely be retrieved directly from the source instead of the cache.
Notebook_02
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . Split the Directed Acyclic Graph (DAG) definition into three separate definitions.
- B . Change the concurrency to 3.
- C . Move the declaration of Notebook_03 to the top of the Directed Acyclic Graph (DAG) definition.
- D . Move the declaration of Notebook_02 to the bottom of the Directed Acyclic Graph (DAG) definition.
- E . Add dependencies to the execution of Note boo k_02.
- F . Add dependencies to the execution of Notebook_03.