AnalyticsPOC data store recommendation: Which type of data store is suitable given read access via T-SQL or Python, semi-structured data, and Delta Lake compatibility?

AnalyticsPOC data store recommendation: Which type of data store is suitable given read access via T-SQL or Python, semi-structured data, and Delta Lake compatibility?

• A. Data Warehouse
• B. Data Lake
• C. Data Vault
• D. Lakehouse

Answer: (D)

The scenario is testing a storage option that unifies the flexibility of a data lake with the governance and performance of a data warehouse, while supporting SQL and Python access and Delta Lake features. A lakehouse provides exactly this blend: it stores data in a lake-style object store but offers warehouse-like capabilities such as ACID transactions, schema enforcement, and optimized query performance. Delta Lake compatibility is a key part of this, delivering reliable transactions, time travel, and strong data governance on semi-structured data, while still being accessible through common analytics tools like SQL (T-SQL-compatible) and Python. Data warehouses are optimized for structured data and traditional SQL workloads, and they’re not ideal for readily handling semi-structured data at scale or leveraging Delta Lake’s transactional layer. Data lakes handle diverse data types and formats but often lack robust transactional guarantees and seamless SQL-ready querying. Data Vault is a modeling approach rather than a standalone data store, so it doesn’t by itself address the storage and querying needs described.

The scenario is testing a storage option that unifies the flexibility of a data lake with the governance and performance of a data warehouse, while supporting SQL and Python access and Delta Lake features. A lakehouse provides exactly this blend: it stores data in a lake-style object store but offers warehouse-like capabilities such as ACID transactions, schema enforcement, and optimized query performance. Delta Lake compatibility is a key part of this, delivering reliable transactions, time travel, and strong data governance on semi-structured data, while still being accessible through common analytics tools like SQL (T-SQL-compatible) and Python.

Data warehouses are optimized for structured data and traditional SQL workloads, and they’re not ideal for readily handling semi-structured data at scale or leveraging Delta Lake’s transactional layer. Data lakes handle diverse data types and formats but often lack robust transactional guarantees and seamless SQL-ready querying. Data Vault is a modeling approach rather than a standalone data store, so it doesn’t by itself address the storage and querying needs described.