An Eventhouse receives data from an Eventstream that uses a 'Group by' aggregation. The Eventhouse shows a 'Query execution timeout' error for a KQL query that aggregates data over a 30-day period. The query worked before but now times out. Which action should you take?

Optimize the KQL query by using materialized views or pre-aggregations.

Increase the Eventhouse's cache size.

Change the Eventstream's aggregation window to a larger interval.

Reduce the query's time range to 7 days.

A Dataflow Gen2 refresh fails with the error 'DataSource.Error: The server was unable to process the request...' The data source is an on-premises SQL Server accessed through an on-premises data gateway. The gateway status shows 'Online'. What should you do first?

Check the gateway's connectivity to the SQL Server and the credentials stored in the data source settings

Replace the on-premises data gateway with a VNet gateway

Recreate the Dataflow Gen2 from scratch

Increase the Dataflow Gen2 timeout setting to 30 minutes

A data pipeline in Fabric fails with an error stating 'The file does not exist' when trying to read from a source file. Which of the following is the most common cause?

The file is too large for the pipeline to process

The file was deleted or moved after the pipeline was configured

The pipeline has insufficient permissions to read the file

The file format is not supported by the pipeline

A Dataflow Gen2 loads data from a REST API into a Lakehouse. The dataflow fails with a 'Web.Contents' error that says 'The remote server returned an error: (401) Unauthorized.' The API endpoint is correct and the API key is stored in a Fabric workspace secret. Which action should you take?

Check if the API key has expired or been rotated in the secret store.

Add a 'Remove errors' step to the query.

Increase the dataflow's timeout setting.

Change the API endpoint to a different version.

A OneLake shortcut in Microsoft Fabric fails with an error stating 'Path not found'. Which of the following is the most likely cause?

The target path in the shortcut is incorrect or the target has been moved

The target data is in an unsupported format

The user does not have permission to the target

Microsoft Certified:Fabric Data Engineer Associate

Domain 3Objective 2

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

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 1–5

1expert · hard
An Eventhouse receives data from an Eventstream that uses a 'Group by' aggregation. The Eventhouse shows a 'Query execution timeout' error for a KQL query that aggregates data over a 30-day period. The query worked before but now times out. Which action should you take?
Select an answer first
2application · medium
A Dataflow Gen2 refresh fails with the error 'DataSource.Error: The server was unable to process the request...' The data source is an on-premises SQL Server accessed through an on-premises data gateway. The gateway status shows 'Online'. What should you do first?
Select an answer first
3foundation · easy
A data pipeline in Fabric fails with an error stating 'The file does not exist' when trying to read from a source file. Which of the following is the most common cause?
Select an answer first
4expert · hard
A Dataflow Gen2 loads data from a REST API into a Lakehouse. The dataflow fails with a 'Web.Contents' error that says 'The remote server returned an error: (401) Unauthorized.' The API endpoint is correct and the API key is stored in a Fabric workspace secret. Which action should you take?
Select an answer first
5foundation · easy
A OneLake shortcut in Microsoft Fabric fails with an error stating 'Path not found'. 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.