Answer-first summary for fast verification
Answer: Lakehouse cannot serve low query latency with high reliability for BI workloads, only suitable for batch workloads.
The correct answer is **B**: 'Lakehouse cannot serve low query latency with high reliability for BI workloads, only suitable for batch workloads.' This statement is incorrect because a lakehouse can indeed replace traditional warehouses by leveraging storage and compute optimizations like caching to serve BI workloads with low query latency and high reliability. For more details on how lakehouses compare to traditional data warehouses, including the use of Spark Cache vs Delta Cache, refer to [Databricks documentation](https://docs.databricks.com/delta/optimizations/delta-cache.html) and [What Is a Lakehouse? – The Databricks Blog](https://www.databricks.com/blog/2020/01/30/what-is-a-lakehouse.html).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which of the following statements is incorrect when comparing a lakehouse to a traditional data warehouse?
A
Lakehouse can be accessed through various APIs, including but not limited to Python, R, and SQL.
B
Lakehouse cannot serve low query latency with high reliability for BI workloads, only suitable for batch workloads.
C
Lakehouse can have special indexes and caching optimized for Machine Learning.
D
Traditional Data Warehouses have storage and compute coupled.
E
Lakehouse uses standard data formats like Parquet.