Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You are troubleshooting an hourly Dataflow Gen2 that transforms JSON files from a landing-zone folder and loads the results into a curated table. The last two refreshes failed. You need to determine the exact applied step that produced the error and review how many rows were processed immediately before the failure. Which action should you take in Microsoft Fabric?
Open the dataflow's Refresh history page and inspect the run-details pane for the failed refresh.
Query the lakehouse's _sys.diag_execution_log table for the dataflow run to retrieve per-step metrics.
Review the pipeline activity run details in the Monitor hub.
Enable query diagnostics in the Power Query editor and review the generated diagnostics tables.
The _sys.diag_execution_log system table records detailed execution information for every Dataflow Gen2 refresh, including each Power Query applied step, its duration, input and output row counts, and any error messages. By filtering this table for the failed run ID, you can pinpoint the step where the refresh stopped and inspect the row statistics right before the failure.
The Refresh history/run-details pane surfaces high-level error information but does not include per-step row counts. Query diagnostics only captures design-time traces inside the Power Query editor. Pipeline activity run details are available only when the dataflow is invoked from a pipeline and also lack internal transformation-step metrics.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is the _sys.diag_execution_log table in Microsoft Fabric?
Open an interactive chat with Bash
How can you filter the _sys.diag_execution_log table for a failed dataflow run?
Open an interactive chat with Bash
Why does the Refresh history page not provide enough detail to debug a failed dataflow?
Open an interactive chat with Bash
Microsoft Fabric Data Engineer Associate DP-700
Monitor and optimize an analytics solution
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .