Pass Microsoft DP-700 Exam in First Attempt Easily
Real Microsoft DP-700 Exam Questions, Accurate & Verified Answers As Experienced in the Actual Test!

Verified by experts
2 products

You save $34.99

DP-700 Premium Bundle

  • Premium File 160 Questions & Answers
  • Last Update: Nov 15, 2026
  • Training Course 160 Lectures
$74.99 $109.98

Purchase Individually

  • Premium File

    160 Questions & Answers
    Last Update: Nov 15, 2026

    $76.99
    $69.99
  • Training Course

    160 Lectures

    $43.99
    $39.99

Implementing Data Engineering Solutions Using Microsoft Fabric DP-700 Practice Test 16

Question 150

A production analytics workflow has this requirement: A new Dataflow Gen2 refresh appears to succeed but row totals double because the destination is in Append mode. What is the most appropriate change if success must be shown by this test: two identical refreshes produce stable logical row counts?

  1. Select the intended replace/upsert/write behavior and add idempotence checks.
  2. Review the destination mapping and normalize incompatible event types before ingestion.
  3. Update the shortcut target path and check the source folder exists.
  4. Replace the full driver collection with distributed operations and bounded sampling.

Explanation

Correct Answer

A:

Destination write mode defines whether repeat refreshes accumulate or replace records. Verify that two identical refreshes produce stable logical row counts.

Incorrect Answers

B:

Schema drift can break a streaming destination even when the source remains connected. However, this alone does not show that two identical refreshes produce stable logical row counts.

C:

Shortcut path references are not automatically rewritten when source folders are relocated. However, this alone does not show that two identical refreshes produce stable logical row counts.

D:

Collect moves data to driver memory and can exhaust it irrespective of executor capacity. However, this alone does not show that two identical refreshes produce stable logical row counts.

Question 151

The reviewer will approve this deployment only when it fixes both issues: (a) A Power BI semantic model shows stale metrics after data ingestion succeeded. (b) A dashboard must show failed source refreshes across lakehouses and warehouses without granting operators write access. Which proposed pair of changes is appropriate?

  1. (1) Check the semantic model refresh history and dependencies after the upstream load; and (2) grant suitable read/monitor permissions and configure supported run-status views.
  2. (1) Open the Dataflow Gen2 refresh history and examine query/destination errors and row activity; and (2) grant suitable read/monitor permissions and configure supported run-status views.
  3. (1) Check the semantic model refresh history and dependencies after the upstream load; and (2) open the notebook/Spark application run details and relevant driver or executor logs.
  4. (1) Open the Dataflow Gen2 refresh history and examine query/destination errors and row activity; and (2) open the notebook/Spark application run details and relevant driver or executor logs.

Explanation

Correct Answer

A:

Step 1 resolves requirement A: Upstream data arrival is separate from semantic model refresh completion. Step 2 resolves requirement B: Monitoring visibility can be separated from authoring or item modification privileges. Both acceptance tests are required: a successful model refresh timestamp follows the completed ingest and report values update; and an observer sees relevant failures but cannot change pipeline definitions.

Incorrect Answers

B:

Monitoring visibility can be separated from authoring or item modification privileges. The other proposed action (Open the Dataflow Gen2 refresh history and examine query/destination errors and row activity) does not implement the first control. Upstream data arrival is separate from semantic model refresh completion.

C:

Upstream data arrival is separate from semantic model refresh completion. The other proposed action (open the notebook/Spark application run details and relevant driver or executor logs) addresses a different operation. Monitoring visibility can be separated from authoring or item modification privileges.

D:

Upstream data arrival is separate from semantic model refresh completion. Monitoring visibility can be separated from authoring or item modification privileges. The proposed steps (Open the Dataflow Gen2 refresh history and examine query/destination errors and row activity; open the notebook/Spark application run details and relevant driver or executor logs) address other capabilities instead of this required pair.

Question 152

A Microsoft Fabric project must complete both tasks before signoff. Task 1: A production workspace must disallow notebook authors from freely overriding pool sizes because cost controls depend on approved defaults. Task 2: Teams want separate ownership of marketing and finance data while using the same Fabric tenant. Choose exactly TWO controls that collectively meet the requirements.

  1. Configure the supported Apache Airflow job or workspace settings and validate the managed orchestration environment.
  2. Use appropriate Fabric domains and workspace organizational boundaries and retain security-role separation.
  3. Review and configure relevant workspace OneLake settings and data security controls rather than notebook code alone.
  4. Disable item-level compute customization in the workspace Spark settings.

Explanation

Correct Answers

B:

Business domains organize content, while workspaces and OneLake roles govern operational access. Confirm that each domain inventory shows its own workspaces and access tests respect role boundaries.

D:

Workspace governance can enforce shared Spark compute settings instead of permitting arbitrary environment overrides. Confirm that a contributor cannot change the blocked environment compute configuration.

Incorrect Answers

A:

Airflow configuration belongs to the workspace/orchestration setup rather than individual Spark SQL statements.

C:

Workspace-level configuration governs data access and connectivity across multiple items.

Question 153

The data platform team needs a narrowly scoped fix: Daily notebook outputs should generate an alert when row counts drop outside an accepted band. Which approach satisfies the documented test that a deliberately truncated batch triggers an anomaly alert while the prior good batch does not?

  1. Inspect Query Insights and execution history for the warehouse or SQL endpoint.
  2. Compute and publish validation metrics and attach an alert to a threshold breach.
  3. Capture notebook run metadata, environment reference and execution result.
  4. Record both source event time and ingestion completion time in freshness telemetry.

Explanation

Correct Answer

B:

Data quality anomalies may not appear as compute failures unless explicitly measured. Verify that a deliberately truncated batch triggers an anomaly alert while the prior good batch does not.

Incorrect Answers

A:

Query history exposes SQL execution trends distinct from copy/load duration. However, this alone does not show that a deliberately truncated batch triggers an anomaly alert while the prior good batch does not.

C:

Run provenance identifies the environment that produced a dataset. However, this alone does not show that a deliberately truncated batch triggers an anomaly alert while the prior good batch does not.

D:

Event-to-query latency differs from service-only ingest processing time. However, this alone does not show that a deliberately truncated batch triggers an anomaly alert while the prior good batch does not.

Question 154

The data platform team needs a narrowly scoped fix: One high-memory Spark stage consistently exceeds the capacity limit although retries succeed only sporadically. Which approach satisfies the documented test that a controlled concurrency test runs jobs within the approved capacity envelope?

  1. Review and configure relevant workspace OneLake settings and data security controls rather than notebook code alone.
  2. Review capacity and Spark job concurrency/resource settings before increasing retries.
  3. Configure workspace and item permissions separately from domain classification.
  4. Configure the supported Apache Airflow job or workspace settings and validate the managed orchestration environment.

Explanation

Correct Answer

B:

Capacity exhaustion differs from transient faults and requires resource or concurrency management. Verify that a controlled concurrency test runs jobs within the approved capacity envelope.

Incorrect Answers

A:

Workspace-level configuration governs data access and connectivity across multiple items. However, this alone does not show that a controlled concurrency test runs jobs within the approved capacity envelope.

C:

Domain assignment supports discoverability and governance but is not the row or item authorization boundary. However, this alone does not show that a controlled concurrency test runs jobs within the approved capacity envelope.

D:

Airflow configuration belongs to the workspace/orchestration setup rather than individual Spark SQL statements. However, this alone does not show that a controlled concurrency test runs jobs within the approved capacity envelope.

Question 155

The project has two blockers. Blocker A: A workspace's data engineers must control the default Apache Airflow integration behavior without editing each existing DAG. Blocker B: A Spark session fails when a custom library is installed in a notebook cell but not available to scheduled jobs. What pair of actions resolves both blockers?

  1. (1) Assign the workspace to the approved Fabric domain through domain/workspace settings; and (2) add the supported narrowly scoped data-connection rule or managed private endpoint for the approved target.
  2. (1) Configure the supported Apache Airflow job or workspace settings and validate the managed orchestration environment; and (2) package the dependency in a published Fabric Environment referenced by both notebook and job definitions.
  3. (1) Configure the supported Apache Airflow job or workspace settings and validate the managed orchestration environment; and (2) add the supported narrowly scoped data-connection rule or managed private endpoint for the approved target.
  4. (1) Assign the workspace to the approved Fabric domain through domain/workspace settings; and (2) package the dependency in a published Fabric Environment referenced by both notebook and job definitions.

Explanation

Correct Answer

B:

Step 1 resolves requirement A: Airflow configuration belongs to the workspace/orchestration setup rather than individual Spark SQL statements. Step 2 resolves requirement B: A reusable environment is more reliable than relying on interactive-only session mutations. Both acceptance tests are required: a scheduled DAG runs using the approved workspace integration settings; and the scheduled Spark job imports the same dependency as the interactive notebook.

Incorrect Answers

A:

Airflow configuration belongs to the workspace/orchestration setup rather than individual Spark SQL statements. A reusable environment is more reliable than relying on interactive-only session mutations. The proposed steps (Assign the workspace to the approved Fabric domain through domain/workspace settings; add the supported narrowly scoped data-connection rule or managed private endpoint for the approved target) address other capabilities instead of this required pair.

C:

Airflow configuration belongs to the workspace/orchestration setup rather than individual Spark SQL statements. The other proposed action (add the supported narrowly scoped data-connection rule or managed private endpoint for the approved target) addresses a different operation. A reusable environment is more reliable than relying on interactive-only session mutations.

D:

A reusable environment is more reliable than relying on interactive-only session mutations. The other proposed action (Assign the workspace to the approved Fabric domain through domain/workspace settings) does not implement the first control. Airflow configuration belongs to the workspace/orchestration setup rather than individual Spark SQL statements.

Question 156

A Fabric data engineering release must address both of these independent requirements: (1) Fabric notebooks are edited directly in production, and the team cannot identify which Git commit introduced a failing transformation. (2) A database project contains a table definition change that would unintentionally drop production data. Which combined plan meets both without substituting an unrelated change?

  1. (1) Assign a distinct, approved workspace to each stage and verify stage-item bindings; and (2) configure a supported Fabric deployment pipeline with development, test and production workspaces.
  2. (1) Assign a distinct, approved workspace to each stage and verify stage-item bindings; and (2) review deployment-generated schema changes and apply safe migration controls before promotion.
  3. (1) Connect the supported workspace to a Git repository/branch and commit supported item definitions; and (2) configure a supported Fabric deployment pipeline with development, test and production workspaces.
  4. (1) Connect the supported workspace to a Git repository/branch and commit supported item definitions; and (2) review deployment-generated schema changes and apply safe migration controls before promotion.

Explanation

Correct Answer

D:

Step 1 resolves requirement A: Fabric Git integration versions item definitions so changes can be reviewed and traced. Step 2 resolves requirement B: Database schema deployment can have destructive consequences even when a source diff is syntactically valid. Both acceptance tests are required: the problematic notebook definition can be mapped to and reverted from a recorded commit; and the deployment test preserves existing production rows and rejects unapproved drops.

Incorrect Answers

A:

Fabric Git integration versions item definitions so changes can be reviewed and traced. Database schema deployment can have destructive consequences even when a source diff is syntactically valid. The proposed steps (Assign a distinct, approved workspace to each stage and verify stage-item bindings; configure a supported Fabric deployment pipeline with development, test and production workspaces) address other capabilities instead of this required pair.

B:

Database schema deployment can have destructive consequences even when a source diff is syntactically valid. The other proposed action (Assign a distinct, approved workspace to each stage and verify stage-item bindings) does not implement the first control. Fabric Git integration versions item definitions so changes can be reviewed and traced.

C:

Fabric Git integration versions item definitions so changes can be reviewed and traced. The other proposed action (configure a supported Fabric deployment pipeline with development, test and production workspaces) addresses a different operation. Database schema deployment can have destructive consequences even when a source diff is syntactically valid.

Question 157

A Fabric engineer has implemented the following change: Use a five-minute tumbling window on the event timestamp. The original requirement was: A streaming query needs a nonoverlapping five-minute aggregate that resets at each fixed boundary. Which observation best validates that the change works?

  1. A malformed test record is quarantined while valid events remain queryable.
  2. The region summary matches the base table and repeated queries improve in latency.
  3. Representative twelve-minute-late events are included under the approved configuration.
  4. Events at two adjacent intervals appear in distinct five-minute aggregates.

Explanation

Correct Answer

D:

Tumbling windows partition time into fixed, nonoverlapping intervals.

Incorrect Answers

A:

Separating invalid records from typed valid rows allows streaming jobs to continue safely. It does not show that events at two adjacent intervals appear in distinct five-minute aggregates.

B:

Materialized aggregations can precompute repeated summaries to reduce query cost. It does not show that events at two adjacent intervals appear in distinct five-minute aggregates.

C:

A too-short watermark can exclude valid late events; a longer delay retains more state. It does not show that events at two adjacent intervals appear in distinct five-minute aggregates.

Question 158

An auditor reviews the applied Fabric control: Compute and publish validation metrics and attach an alert to a threshold breach. It was selected to address: Daily notebook outputs should generate an alert when row counts drop outside an accepted band. Which evidence demonstrates the intended result?

  1. An audit record links a published table to the notebook run and runtime configuration.
  2. Monitoring identifies the stalled destination and the last accepted event.
  3. A successful model refresh timestamp follows the completed ingest and report values update.
  4. A deliberately truncated batch triggers an anomaly alert while the prior good batch does not.

Explanation

Correct Answer

D:

Data quality anomalies may not appear as compute failures unless explicitly measured.

Incorrect Answers

A:

Run provenance identifies the environment that produced a dataset. It does not show that a deliberately truncated batch triggers an anomaly alert while the prior good batch does not.

B:

Source activity does not prove a downstream destination is consuming messages. It does not show that a deliberately truncated batch triggers an anomaly alert while the prior good batch does not.

C:

Upstream data arrival is separate from semantic model refresh completion. It does not show that a deliberately truncated batch triggers an anomaly alert while the prior good batch does not.

Question 159

A Fabric data engineer receives a change request: Fabric notebooks are edited directly in production, and the team cannot identify which Git commit introduced a failing transformation. Which action best produces this measurable result: the problematic notebook definition can be mapped to and reverted from a recorded commit?

  1. Put quality gates and approval checks in the supported CI/CD workflow before the production deployment action.
  2. Separate Git source-of-truth and stage promotion according to the approved CI/CD architecture.
  3. Connect the supported workspace to a Git repository/branch and commit supported item definitions.
  4. Assign a distinct, approved workspace to each stage and verify stage-item bindings.

Explanation

Correct Answer

C:

Fabric Git integration versions item definitions so changes can be reviewed and traced. Verify that the problematic notebook definition can be mapped to and reverted from a recorded commit.

Incorrect Answers

A:

Version control alone does not enforce release quality or change authorization. However, this alone does not show that the problematic notebook definition can be mapped to and reverted from a recorded commit.

B:

Git sync and environment deployment are different workflows with different source-of-truth expectations. However, this alone does not show that the problematic notebook definition can be mapped to and reverted from a recorded commit.

D:

Stage separation isolates release scopes so testing does not modify the production workspace. However, this alone does not show that the problematic notebook definition can be mapped to and reverted from a recorded commit.

Question 160

An auditor reviews the applied Fabric control: Use the applicable Microsoft Fabric/Microsoft Purview audit log search with principal, time and operation filters. It was selected to address: Auditors need to determine who changed an artifact or accessed supported Fabric resources during a specified interval. Which evidence demonstrates the intended result?

  1. The audit query returns the matching activity with actor and timestamp.
  2. The displayed label and review evidence agree with the actual governance decision.
  3. The labels appear on the intended items while existing access permissions remain intact.
  4. The user reads only the allowed rows and columns with no role-combination error.

Explanation

Correct Answer

A:

Supported Fabric audit events expose administrative or item activities without being the same as pipeline data logs.

Incorrect Answers

B:

Promotion is a discoverability signal; certification requires an authorized organizational review process. It does not show that the audit query returns the matching activity with actor and timestamp.

C:

Sensitivity labels mark data classification and inform downstream governance; they do not automatically grant read access. It does not show that the audit query returns the matching activity with actor and timestamp.

D:

Combining row and column filters in unsupported separate roles can cause query errors. It does not show that the audit query returns the matching activity with actor and timestamp.

Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Practice Tests

Purchase Individually

  • Premium File

    160 Questions & Answers
    Last Update: Nov 15, 2026

    $76.99
    $69.99
  • Training Course

    160 Lectures

    $43.99
    $39.99

SPECIAL OFFER: GET 10% OFF
This is ONE TIME OFFER

You save
10%

Enter Your Email Address to Receive Your 10% Off Discount Code

SPECIAL OFFER: GET 10% OFF

You save
10%

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from support@examlabs.com and follow the directions.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your email address below to get started with our interactive software demo of your free trial.

  • Realistic exam simulation and exam editor with preview functions
  • Whole exam in a single file with several different question types
  • Customizable exam-taking mode & detailed score reports