A Dataflow Gen2 loads data from a SharePoint folder into a Lakehouse. The dataflow fails with a 'Query execution failed' error. The error details show a 'DataFormat.Error: Invalid cell value' for a column that previously contained only numbers. Which action should you take?

Change the column data type to 'Any' in the dataflow query.

Add a 'Remove errors' step to the query to filter out rows with invalid values.

Inspect the source file for a new row with a non-numeric value in that column.

Disable the 'Enable load' option for the query to skip the error.

A OneLake shortcut in Microsoft Fabric fails because the target path was moved. Which of the following is the most effective way to resolve this?

Ignore the error and wait for the path to be restored

Update the shortcut's target path to the new location

Change the shortcut type to a different source

Recreate the shortcut from scratch

An Eventhouse in Microsoft Fabric fails to ingest data with an error indicating 'Partition is full'. What does this error typically indicate?

The data partition has reached its maximum size limit

The Eventhouse has insufficient permissions

The data source is not accessible

An Eventstream is configured with a custom endpoint as a source. The endpoint receives data, but the Eventstream's 'Input events' metric remains at zero. The custom endpoint's URL is correct. What should you investigate?

Whether the data being sent to the custom endpoint uses the correct authentication method and format

Whether the Eventhouse's ingestion policy is set to 'Batching'

Whether the Eventstream's throughput is set to 1 MB/s

Whether the Eventstream's output destination is paused

A data pipeline in Microsoft Fabric fails when copying data from an on-premises SQL Server to a Lakehouse. The error message indicates a 'Login timeout expired'. Which of the following is the most likely cause?

The SQL Server is not reachable from the integration runtime

The SQL Server query is syntactically incorrect

The pipeline run has exceeded its scheduled time

The destination Lakehouse has insufficient storage capacity

Microsoft Certified:Fabric Data Engineer Associate

Domain 3Objective 2

Identify and Resolve Errors DP-700 Practice Questions (Page 2)

Part of the Monitor and optimize an analytics solution domain, which accounts for 30–35% of the DP-700 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~12–23 in this domain), expect 4–8 from this objective — we provide 60 practice questions to prepare you well beyond it. (estimate)

60questions here

12free pages

14concepts

30–35%of the exam

Questions 6–10

6application · medium
A Dataflow Gen2 loads data from a SharePoint folder into a Lakehouse. The dataflow fails with a 'Query execution failed' error. The error details show a 'DataFormat.Error: Invalid cell value' for a column that previously contained only numbers. Which action should you take?
Select an answer first
7foundation · easy
A OneLake shortcut in Microsoft Fabric fails because the target path was moved. Which of the following is the most effective way to resolve this?
Select an answer first
8foundation · easy
An Eventhouse in Microsoft Fabric fails to ingest data with an error indicating 'Partition is full'. What does this error typically indicate?
Select an answer first
9application · medium
An Eventstream is configured with a custom endpoint as a source. The endpoint receives data, but the Eventstream's 'Input events' metric remains at zero. The custom endpoint's URL is correct. What should you investigate?
Select an answer first
10foundation · easy
A data pipeline in Microsoft Fabric fails when copying data from an on-premises SQL Server to a Lakehouse. The error message indicates a 'Login timeout expired'. Which of the following is the most likely cause?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-700

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-700” is a trademark of its owner, used for identification only.