DP-700 - Monitor and Optimize an Analytics Solution (33% of the exam) - Section 3.2

Monitor semantic model refresh and configure alerts for Microsoft Fabric items.

Monitor semantic model refresh history and diagnose scheduled refresh failures in Microsoft Fabric. Configure Data Activator alerts on capacity and item events, and route notifications to email or Microsoft Teams to reduce response time for refresh issues.

semantic model refresh historyscheduled refresh failuresData Activator (Activator) alertsalerts on capacity and item eventsemail and Teams notifications

Practice question for this objective

Free sampleMonitor and Optimize an Analytics Solutionmedium

A data engineer owns several import-mode semantic models in a Microsoft Fabric workspace. The business wants a single chat message posted to a Microsoft Teams channel within moments of any of these models completing a refresh that ends in failure, and the rule should react to the refresh event itself rather than poll on a fixed clock. The engineer wants a managed, no-code path that watches the item event and sends the Teams message. Which Microsoft Fabric capability should the engineer use to drive this notification?

  • AAdd a scheduled trigger to a Data Factory pipeline that runs every five minutes, reads the refresh history, and posts to Teams when it finds a failed run.
  • BTurn on the scheduled refresh failure email notification on each model and rely on a mailbox rule to forward those messages into the Microsoft Teams channel.
  • CConfigure a Data Activator (Activator) rule that listens to the semantic model refresh failure event and sends a Microsoft Teams message when a failed refresh is detected. Correct
  • DBuild a Spark notebook that queries the refresh history through the API on a timer and calls a Teams webhook whenever it observes a failed refresh of any model.
Data Activator watches Fabric item events such as a failed semantic model refresh and sends Teams or email notifications with no code or polling. Data Activator (Activator) subscribes to Fabric item events, including semantic model refresh outcomes, and fires an action such as a Microsoft Teams message the moment the matching event occurs, removing the need for any scheduled polling job.

Why A is wrong: A scheduled pipeline can post to Teams, but it polls on a fixed clock and adds operational overhead, which the requirement to react to the event without polling rules out.

Why B is wrong: Refresh failure email is built in, but it sends email to owners rather than a Teams channel, and a forwarding rule is an external workaround outside Fabric rather than a managed event-driven path.

Why C is correct: Data Activator can watch Fabric item events such as a semantic model refresh failure and trigger a Microsoft Teams message with no code and no fixed polling interval, matching the requirement exactly.

Why D is wrong: A notebook on a timer could post to Teams, but it requires custom code and timed polling, the opposite of the managed, no-code, event-driven approach the requirement calls for.

See more DP-700 practice questions, answers explained.

Exam traps in Monitor and Optimize an Analytics Solution

Answers that look right on this material and are not. Each one is a distractor from a different question in the DP-700 bank for this domain.

  • Open the workspace lineage view, which lays out the upstream sources feeding the semantic model so the team can read the failing source's error from the diagram.

    Why it is wrong: Lineage view shows dependency relationships between items but does not record per-refresh run times or error messages, so it cannot tell the engineer why a particular refresh failed.

  • Open each semantic model's refresh history every morning and infer capacity pressure from any refreshes that took longer than usual to complete overnight.

    Why it is wrong: Slow refreshes can hint at pressure, but reading one item's history is manual, indirect, and does not measure capacity throttling, so it cannot reliably alert on the capacity-level condition.

  • The Monitoring hub, which lists recent runs of pipelines, dataflows, and notebooks across the workspace but does not expand the per-refresh error of a semantic model.

    Why it is wrong: The Monitoring hub is a useful cross-item run list, but for a semantic model it does not surface the per-refresh error detail that refresh history exposes, so it is not the most direct view here.

Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.