Question

A retail company streams clickstream events into Microsoft Fabric. Analysts need to run interactive ad-hoc queries that filter and aggregate the last 90 days of events with sub-second response times, using time-series operators. The same raw data must also be retained for 7 years at the lowest possible storage cost for occasional compliance audits. Which storage design best meets both requirements?

Accepted Answer

Ingest into an Eventhouse for the hot 90-day window, and use a OneLake availability / export to Delta so older data lands cheaply in a lakehouse for long-term retention.

Answer

Store all 7 years of data in an Eventhouse (KQL database) and query it directly for both interactive analytics and compliance audits.

Answer

Store all data only in a lakehouse Delta table and query it with the SQL analytics endpoint for both interactive and compliance needs.

Answer

Store the 90-day data in a Warehouse using T-SQL and archive older data with a Dataflow Gen2 to a separate Warehouse.