Microsoft DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric

Last checked October 22, 2026 against the official Microsoft exam page.

1. Question 1Ingest and transform data

   A team needs to load data from a relational source into a lakehouse on a schedule, with copy activities and error handling. Which Fabric item orchestrates this?

   1. AShortcut
   2. BWarehouse view only
   3. CPower BI report
   4. DData pipeline
   Show answer and explanationHide answer

   Correct answer: D

   Data pipelines orchestrate copy and transformation activities on schedules with control flow and error handling. Reports present data, shortcuts reference it, and views do not orchestrate loads.

2. Question 2Implement and manage an analytics solution

   A company wants one place to store data for engineers, analysts, and data scientists, using open table formats and no separate copies per team. Which Fabric component is the foundation for this?

   1. AA printed data catalogue
   2. BA weekly email attachment archive
   3. COneLake
   4. DA local file share on each laptop
   Show answer and explanationHide answer

   Correct answer: C

   OneLake is the single logical data lake for a Fabric tenant, shared by workloads and teams without duplicating data. Local shares, printed catalogues, and email archives do not provide shared, governed storage.

3. Question 3Monitor and optimize an analytics solution

   A pipeline run has been slow for a week. Which Fabric feature shows run history, duration, and failure details across items in a workspace?

   1. AA static chart in a presentation
   2. BMonitoring hub
   3. CThe workspace description
   4. DA printed calendar of runs
   Show answer and explanationHide answer

   Correct answer: B

   The monitoring hub shows activity history and details for items such as pipelines and notebooks, which supports diagnosis of slow runs. Calendars, static charts, and descriptions do not show run data.

4. Question 4Ingest and transform data

   A team prefers a low-code way to clean and reshape data from several sources and write the result to a lakehouse. Which Fabric item fits best?

   1. AA printed Power Query guide
   2. BA blank notebook with no code
   3. CDataflow Gen2
   4. DEventhouse
   Show answer and explanationHide answer

   Correct answer: C

   Dataflow Gen2 provides a low-code Power Query experience for transforming data and writing it to Fabric destinations. Printed guides are not a tool, and eventhouses store streaming data.

5. Question 5Implement and manage an analytics solution

   A team wants to query files that already exist in another cloud storage account without copying them into OneLake. Which Fabric feature provides this?

   1. AA shortcut to the external storage location
   2. BA screenshot of the lakehouse file list
   3. CA manual download of each file locally
   4. DA copy of the files in Recycle Bin
   Show answer and explanationHide answer

   Correct answer: A

   Shortcuts reference external data in place, so workloads can read it without duplicating it. Manual downloads and copies create duplicates, and screenshots do not provide data access.