Databricks Certified Data Engineer - Associate

The correct answer is E. A data lakehouse enables both batch and streaming analytics, which is a key benefit over traditional data warehouses that typically focus only on batch processing. Traditional data warehouses are optimized for structured data and batch processing, while data lakehouses combine the best features of data lakes and data warehouses, supporting both batch and real-time streaming analytics.

Explanation of other options:

• A: Incorrect. Both data lakehouses and traditional data warehouses provide relational systems of data management.
• B: Incorrect. While some data lakehouses may support version control through features like Delta Lake's time travel, this is not a fundamental benefit unavailable in traditional data warehouses.
• C: Incorrect. Traditional data warehouses also couple storage and compute, often even more tightly than data lakehouses.
• D: Incorrect. Data lakehouses typically use open storage formats (like Parquet, ORC) rather than proprietary formats, which is actually an advantage over some traditional data warehouses that use proprietary formats.