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

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.

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.