A Dataflow Gen2 that loads data from a SharePoint folder fails with 'Access to the resource is forbidden.' The dataflow uses a service principal for authentication. The service principal has been granted access to the SharePoint site. The dataflow runs successfully when a user runs it manually, but fails when scheduled. What is the most likely cause?

The scheduled refresh uses a different authentication context than the manual run

The SharePoint folder's file names contain special characters

The SharePoint site's regional settings are different from the dataflow's region

The dataflow's refresh type is set to 'Refresh only' instead of 'Full refresh'

A T-SQL stored procedure in a Fabric Warehouse fails with 'The transaction log for database 'xxx' is full.' The warehouse uses the default storage configuration. The procedure performs a large bulk insert. You need to resolve the error without losing data. What should you do?

Increase the warehouse's reserved capacity

Change the database's recovery model to SIMPLE

Delete the stored procedure and recreate it

Break the bulk insert into smaller batches and commit each batch

A Dataflow Gen2 in Fabric fails because a query step references a column that does not exist. Which of the following is the most effective way to resolve this?

Change the data source to one that has the column

Delete the query and recreate it

Edit the query step to use the correct column name

An Eventhouse query returns 'Query execution failed: Partial query failure' when aggregating data over a large time range. The Eventhouse has a single database with a default cache policy. The query works for a smaller time range. What is the most likely cause?

The Eventstream's partitioning is set to a single partition

The Eventhouse's data sharding is misconfigured

The Eventhouse's ingestion batching policy is too small

The query exceeds the Eventhouse's per-query memory or CPU limits

An Eventstream is configured to ingest data from an Azure Event Hubs instance and output to a Lakehouse. The Eventstream shows a 'Deserialization error' for a batch of events. The Event Hubs is sending JSON data. Which action should you take?

Check the Eventstream's data format settings to ensure they match the JSON structure of the incoming events.

Increase the Eventstream's partition count to handle more data.

Restart the Eventstream to clear the error state.

Change the output to a different Lakehouse table.

Microsoft Certified:Fabric Data Engineer Associate

Domain 3Objective 2

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

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 46–50

46expert · hard
A Dataflow Gen2 that loads data from a SharePoint folder fails with 'Access to the resource is forbidden.' The dataflow uses a service principal for authentication. The service principal has been granted access to the SharePoint site. The dataflow runs successfully when a user runs it manually, but fails when scheduled. What is the most likely cause?
Select an answer first
47expert · hard
A T-SQL stored procedure in a Fabric Warehouse fails with 'The transaction log for database 'xxx' is full.' The warehouse uses the default storage configuration. The procedure performs a large bulk insert. You need to resolve the error without losing data. What should you do?
Select an answer first
48foundation · easy
A Dataflow Gen2 in Fabric fails because a query step references a column that does not exist. Which of the following is the most effective way to resolve this?
Select an answer first
49application · medium
An Eventhouse query returns 'Query execution failed: Partial query failure' when aggregating data over a large time range. The Eventhouse has a single database with a default cache policy. The query works for a smaller time range. What is the most likely cause?
Select an answer first
50application · medium
An Eventstream is configured to ingest data from an Azure Event Hubs instance and output to a Lakehouse. The Eventstream shows a 'Deserialization error' for a batch of events. The Event Hubs is sending JSON data. Which action should you take?
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.