Question

A logistics company needs a solution in Microsoft Fabric to process GPS pings from thousands of delivery trucks. The data arrives continuously, and dispatchers need a live dashboard showing each truck's most recent location with under 10 seconds of latency. The engineering team also wants to route the same incoming pings to a Lakehouse for later historical analysis. Which approach best satisfies both the low-latency dashboard and the historical archive requirements with the least custom code?

Accepted Answer

Create an Eventstream that ingests the GPS pings, then add both an Eventhouse (KQL Database) destination for real-time querying and a Lakehouse destination for historical storage.

Answer

Schedule a Dataflow Gen2 to run every minute that reads the GPS pings and writes them to a Lakehouse table used by the dashboard.

Answer

Use a Data pipeline with a Copy activity on a 5-minute schedule to land the pings in a Warehouse and build the dashboard on top of it.

Answer

Write a PySpark structured streaming job that reads the pings and writes only to a Lakehouse Delta table, then connect the dashboard directly to that table.