Which Fabric data store should be used to store data on OneLake and support CREATE TABLE statements?

• A. SQL Endpoint
• B. Lakehouse
• C. KQL database
• D. Warehouse

Answer: (D)

When you need a data store that sits on top of OneLake and supports standard SQL DDL like CREATE TABLE, you use a Warehouse. It provides a relational, schema-defined store whose data is persisted in OneLake, and it accepts SQL commands to define and manage tables, making it suitable for structured, transactional workloads. The SQL Endpoint is just a compute surface for running SQL against existing data, not a dedicated storage layer. The Lakehouse offers lake-like storage with schema, but for explicit relational CREATE TABLE semantics on OneLake, the Warehouse is the intended relational storage. KQL databases use a different query language and do not align with SQL CREATE TABLE in this context.