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. An integrated machine learning model repository.

Answer: (C)

A lakehouse is an analytical store that blends the flexible, file-based storage of a data lake with the SQL-based query capabilities and analytics features of a data warehouse. In Fabric, this means you can keep diverse data types in the lake and still run fast SQL queries, use BI tools, and apply governance and schema management—all in one place. The idea is to analyze data without moving it into a separate warehouse, while still getting the performance and ac‑id-like reliability typically associated with a data warehouse. It’s not just a relational database engine, nor merely a folder structure in the data lake, nor a machine learning model repository—the lakehouse unifies storage and analytics on top of the data lake.