Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You manage a Microsoft Fabric workspace that contains 20 semantic models refreshing several times daily. You must receive an alert whenever any refresh exceeds 30 minutes and you must store refresh status and duration history in a lakehouse for trend analysis. What should you implement?
Enable the Email notification for refresh failure option on every semantic model and query Microsoft 365 audit logs for DatasetRefreshCompleted events to build a trend report.
Move the semantic models to a dedicated capacity and use the Fabric Capacity Metrics app to monitor refresh times and configure capacity-based alerts.
Build a Fabric pipeline that calls the Get Refresh History REST API for each semantic model, writes the results to a lakehouse table, and adds a data-driven alert on a Power BI report when refresh duration exceeds 30 minutes.
From the Monitoring hub, pin the Refresh history pane of each semantic model to a dashboard and configure a threshold alert on the pinned tiles.
The Get Refresh History REST API returns detailed records for every semantic-model refresh, including start time, end time, status, and duration. Orchestrating this call in a Fabric pipeline and persisting the JSON response to a lakehouse table gives a permanent operational history that can be queried for trend reporting. Once the data is visualised in a Power BI report, a standard data-driven alert can be added to fire when the calculated duration is greater than 30 minutes. Email failure notifications trigger only when a refresh fails, not when it runs long. Audit logs are difficult to query at scale for trending. The Monitoring hub and the Capacity Metrics app surface metrics but do not let you set custom duration-based alerts per semantic model.
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 Get Refresh History REST API and how does it work?
Open an interactive chat with Bash
What is a Fabric pipeline, and how is it used here?
Open an interactive chat with Bash
What is a data-driven alert in Power BI, and how is it applied here?
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 .