Free Exam DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric Practice Questions

Sample Practice Questions

Try these 10 sample questions from the Exam DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric practice bank. Each includes the answer and explanation. Continue with the interactive practice above to review the full question set.

1. 1Which workspace role is required to change Apache Spark workspace settings in Fabric?

   1. A. Viewer role in the workspace
   2. B. Contributor role in the workspace
   3. C. Admin role in the workspace
   4. D. Member role in the workspace

   Answer: C

   Explanation: Microsoft states, "To make changes to the Apache Spark settings in a workspace, you should have the admin role for that workspace." The required role is Admin.

   Reference: Apache Spark workspace administration settings — Opening prerequisites

2. 2A large source table changes only slightly between runs. Which loading pattern copies just new or changed records rather than the entire table?

   1. A. Reload every source row each run
   2. B. An incremental load
   3. C. Append the full source each run
   4. D. Copy only records already in the target

   Answer: B

   Explanation: The tutorial describes incremental loading as "copy only new or changed data". This avoids copying all records on every run.

   Reference: Incrementally load data from Data Warehouse to Lakehouse — Introduction

3. 3In the legacy Monitoring hub, which view identifies jobs that triggered a pipeline run and jobs triggered by it?

   1. A. The workspace item containment hierarchy
   2. B. The data lineage dependency graph
   3. C. The deployment stage comparison view
   4. D. The upstream/downstream run hierarchy

   Answer: D

   Explanation: Microsoft states, "The hierarchical view shows upstream jobs that triggered a pipeline run and downstream jobs that the run triggered." This represents execution relationships rather than workspace containment.

   Reference: Monitor pipeline runs in the legacy Monitoring hub — View pipeline run relationships

4. 4A Fabric workspace needs Spark nodes sized explicitly for a workload. Which configuration action meets this requirement?

   1. A. Create a custom Spark pool with the required node size
   2. B. Change only the starter pool's maximum executor count
   3. C. Select another Spark runtime for the starter pool
   4. D. Enable high concurrency while keeping the starter pool

   Answer: A

   Explanation: The documentation states, "Custom Spark Pool: You can size the nodes, autoscale, and dynamically allocate executors based on your Spark job requirements." This is the Spark pool for explicit node sizing.

   Reference: Apache Spark workspace administration settings — Pool — Default pool for the workspace

5. 5An incremental load must detect inserts and updates. Which source column is suitable as a watermark if it reliably increases whenever either change occurs?

   1. A. A customer category column
   2. B. A customer name column
   3. C. A record creation timestamp
   4. D. A record last-modified timestamp

   Answer: D

   Explanation: The guide describes watermark values that "increase when rows are added or updated". A reliable last-modified timestamp meets both requirements; a creation date misses later updates.

   Reference: Incrementally load data from Data Warehouse to Lakehouse — High-level design — Pick a watermark column

6. 6A support engineer needs a downloadable table of pipeline activity-run monitoring data from the legacy Monitoring hub. Which action provides it?

   1. A. Copy one activity's input payload
   2. B. Export to CSV
   3. C. Copy the pipeline run identifier
   4. D. Copy one activity's output payload

   Answer: B

   Explanation: Microsoft states, "To download the activity run data, select Export to CSV." This exports monitoring records rather than pipeline definitions.

   Reference: Monitor pipeline runs in the legacy Monitoring hub — Filter and export activity runs

7. 7A workspace admin disables Customize compute configuration for items in the Spark settings. What configuration will environments use?

   1. A. Each notebook's last saved executor configuration
   2. B. The smallest custom pool and its configuration
   3. C. Each environment's independent compute configuration
   4. D. The workspace default pool and its configuration

   Answer: D

   Explanation: Microsoft states, "If the setting is turned off by the workspace admin, the Default pool and its compute configurations are used for all environments in the workspace." Disabling item customization enforces the default pool configuration.

   Reference: Apache Spark workspace administration settings — Pool — Customize compute configuration for items

8. 8An incremental copy has old watermark O and new watermark N. Which predicate matches the tutorial's nonoverlapping extraction window?

   1. A. Values greater than O and at most N
   2. B. Values at least O and at most N
   3. C. Values greater than O and greater than N
   4. D. Values less than O and at most N

   Answer: A

   Explanation: The source query uses "LastModifytime >" for the old watermark and "LastModifytime <=" for the new one. This excludes the prior boundary and includes the newly captured upper boundary.

   Reference: Incrementally load data from Data Warehouse to Lakehouse — Step 4 — Copy activity source query

9. 9Where can an engineer inspect the actual input and output payloads of a pipeline activity run in the legacy Monitoring hub?

   1. A. The activity's input and output links under Activity runs
   2. B. The activity's configured Source and Destination settings
   3. C. The run list's final status and duration columns
   4. D. The upstream and downstream execution hierarchy

   Answer: A

   Explanation: Microsoft states, "Under Activity runs, select an input or output link to view the corresponding data for an activity run." This inspects runtime payloads rather than design metadata.

   Reference: Monitor pipeline runs in the legacy Monitoring hub — View activity input, output, and performance

10. 10A workspace needs a shared Spark runtime version and library dependencies for notebooks and Spark job definitions. What should its admin configure?

    1. A. A workspace domain
    2. B. A default Environment
    3. C. A session timeout
    4. D. A job admission policy

    Answer: B

    Explanation: Microsoft states, "In an Environment you can configure compute properties, select different runtime, setup library package dependencies based on your workload requirements." Selecting it as the workspace default supplies these settings; domain, timeout, and admission controls do not define runtime dependencies.

    Reference: Apache Spark workspace administration settings — Environment