What is an advantage of using a Delta Lake-based data lakehouse over classic enterprise data warehouse solutions?

Question

Options

• AOpen-source formats
• BSchema enforcement
• CACID transactions
• DGeneric optimizations

• A
  72% (34)
• B
  4% (2)
• C
  9% (4)
• D
  15% (7)

Explanation

Open-source formats like Parquet (used by Delta Lake) allow data to be accessed by any compatible tool - Spark, Presto, Hive, etc. - without vendor lock-in, which is a fundamental architectural advantage over proprietary EDW storage formats like those used by Teradata or Oracle. Schema enforcement (B) is not a differentiator - traditional EDWs have enforced schemas for decades; Delta Lake actually adds schema enforcement to data lakes, but that doesn't make it an advantage over EDWs. ACID transactions (C) are similarly a long-standing feature of classic EDWs, so Delta Lake achieving parity here is not a lakehouse-specific advantage over them. "Generic optimizations" (D) is nonsensical as an advantage - it implies less specialization, which would be a weakness, not a strength.

Memory tip: Associate Delta Lake with the word open - open formats, open ecosystem, no lock-in. Whenever a question asks what a lakehouse does better than a proprietary EDW, think "open-source" first.

No community discussion yet for this question.