Question
You have a Fabric workspace.
You have semi-structured data.
You need to read the data by using T-SQL, KQL, and Apache Spark. The data will only be written by using Spark.
What should you use to store the data?
- A. a lakehouse Correct
- B. an eventhouse
- C. a datamart
- D. a warehouse
Explanation
A lakehouse is the Fabric store for semi-structured data written by Spark: Spark writes the Delta tables natively, T-SQL reads them through the lakehouse's SQL analytics endpoint, and KQL can query them through a OneLake shortcut in a KQL database. An eventhouse is designed for streaming event data that is ingested through KQL and connectors, not for data authored by Spark. A warehouse is written with T-SQL rather than Spark, and a datamart is a self-service Power BI item that does not support Spark or KQL.
