What is a Microsoft Fabric lakehouse?

• A. A relational database based on the Microsoft SQL Server database engine.
• B. A hierarchy of folders and files in Azure Data Lake Store Gen2.
• C. An analytical store that combines the file storage flexibility of a data lake with the SQL-based query capabilities of a data warehouse.
• D. A real-time streaming engine.

Answer: (C)

A lakehouse blends the best of both worlds: you keep data where a data lake stores it—flexible, scalable, and capable of holding diverse formats—yet you gain the SQL-based query power and analytics features of a data warehouse. In Microsoft Fabric, a lakehouse provides an analytical layer on top of your data lake storage, so you can run SQL queries, use BI tools, and perform analytics across structured and semi-structured data without moving it into a separate warehouse. This combines lake storage flexibility with warehouse-like capabilities such as familiar SQL access, governance, and performance optimizations. The other options describe only storage, a pure relational engine, or a streaming engine, none of which capture that integrated SQL analytics surface on lake data.