Architecture Challenges
Architecture LabintermediateMicrosoft FabricOneLakePower BI
Lakehouse or Warehouse in Microsoft Fabric
Choose the right store for a mixed analytics workload.
Data Architect · Scenario
A retailer is consolidating on Microsoft Fabric. Data engineers work in Python and Spark on semi-structured clickstream data, while a BI team writes T-SQL and needs governed, low-latency reporting for finance. Leadership wants one platform, not a zoo of engines.
Vraag 1 van 3
Where should the raw clickstream and engineered feature tables live?
The engineering team is Spark-first and works with large semi-structured files.
Vraag 2 van 3
The finance BI team needs governed T-SQL with multi-table transactions. What serves them best?
Vraag 3 van 3