Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You use Microsoft Fabric Data Factory to ingest data from an on-premises SQL Server database into a lakehouse. A pipeline with a Copy data activity runs every hour. You need to create a near-real-time dashboard that shows, for each pipeline run, the amount of data written and the duration of the copy operation so you can identify ingestion slowdowns as soon as they happen.
Which Fabric feature should you use to feed the dashboard with the required monitoring information without writing custom logging code?
The ActivityRuns table in the Fabric Monitoring Hub, queried with Kusto
The Fabric Capacity Metrics Power BI app filtered to the Data Factory workload
The Dataflow Gen2 run-history view available from the Dataflow monitoring page
The output JSON that can be downloaded from each Copy data activity run blade
Fabric automatically streams copy-activity telemetry such as DataWritten, DataRead, and Duration to the Monitoring Hub. These metrics are stored in the ActivityRuns table, which can be queried with Kusto Query Language. By connecting a Power BI report to that table, you can surface per-run details immediately after each execution. Downloading individual activity-output JSON files or examining Dataflow Gen2 history does not scale for programmatic reporting, and the Fabric Capacity Metrics app focuses on capacity-level, not per-pipeline, data.
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 Kusto Query Language (KQL)?
Open an interactive chat with Bash
What is the ActivityRuns table in Microsoft Fabric Monitoring Hub?
Open an interactive chat with Bash
How can Power BI be connected to the ActivityRuns table for real-time monitoring?
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 .