Question

A retail analytics team loads a nightly sales fact table into a Fabric warehouse. The data engineer must be notified automatically whenever a nightly load results in fewer than 1,000 new rows, which indicates a likely upstream ingestion problem. The solution should require minimal custom code and integrate with the team's existing Fabric monitoring. What should the engineer configure?

Accepted Answer

Create a Data Activator (Activator) alert on a query result that counts new rows and trigger an email when the count falls below the threshold.

Answer

Enable diagnostic logging on the warehouse and manually review the query insights views each morning.

Answer

Add a Teams message activity at the end of the pipeline that always posts the total row count regardless of value.

Answer

Configure a semantic model refresh failure alert so an email is sent when the model fails to refresh.