Streaming IoT Data into Fabric Lakehouse for NRT Dashboards
You have a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 processes data from more than 100 sources by using a medallion architecture. Lakehouse1 ingests the data in batch loads by using Dataflow Gen2. You need to collect IoT sensor data from connected devices in near-real-time (NRT). The solution must meet the following requirements: • Generate NRT dashboards and perform anomaly detection. • Store the streaming data for downstream batch processing into Lakehouse1. The solution must minimize development effort. What should you use?
Community Insight
The question tests choosing a native, low-code streaming ingestion path into Fabric, and the trap is picking a service that does anomaly detection but lives outside Fabric and adds deployment overhead, or defaulting to Dataflow Gen2.
This DP-700 scenario asks how to ingest IoT sensor telemetry in near-real-time, power NRT dashboards with anomaly detection, and land the data in Lakehouse1 for batch processing while minimizing development effort. The page establishes that Azure Event Hubs fed through Fabric's Real-Time Hub is the lowest-effort native path, while Dataflow Gen2 remains a batch-only tool.
Many learners choose Azure Stream Analytics (A) because it ships built-in anomaly detection functions, but ASA is a separate Azure service that must be provisioned, queried, and wired to outputs — increasing development effort instead of minimizing it; Dataflow Gen2 (D) is also wrongly reused even though it is a batch ingestion tool.
Community Discussion (2 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
Azure Event Hubs (B) is the recommended ingestion front end for IoT telemetry because it is exposed as a first-class source in Fabric's Real-Time Hub, so an eventstream can be configured with drag-and-drop rather than custom code. From that eventstream you fan out to a KQL eventhouse, where near-real-time dashboards and functions such as series_decompose_anomalies deliver the required anomaly detection. A second eventstream destination writes the same stream into a Delta table in Lakehouse1, satisfying the downstream batch-processing requirement with zero-code destinations. Because everything is configured inside the existing Fabric workspace, this meets the "minimize development effort" constraint better than any option that requires deploying and maintaining an external service or writing code.Official Reference
Exam Strategy
When a question says "minimize development effort" in Fabric, favor a native, no-code/low-code workspace feature over deploying an external Azure service or writing Spark code. Always re-read the stated workload type — if the requirement is near-real-time, eliminate batch tools like Dataflow Gen2 before comparing the remaining options.
Frequently Asked Questions
Why isn't Azure Stream Analytics the answer if it has built-in anomaly detection?
Stream Analytics does detect anomalies, but it runs as a standalone Azure resource outside the Fabric workspace, requiring extra provisioning, query writing, and output configuration — which violates the minimize-development-effort requirement.
Can Dataflow Gen2 handle the near-real-time IoT requirement?
No. Dataflow Gen2 is the batch ingestion tool already used for the medallion loads and cannot stream IoT sensor data for near-real-time dashboards.