You have a fabric workspace. You have semi-structured data. You need to read the data by using T-SQL, KQL, and Apache Spark. What will only be written by using Spark. What should you use to store…

Question

Options

• Aa lakehouse
• Ban eventhouse
• Ca data mart
• Da warehouse

• A
  4% (1)
• B
  81% (21)
• C
  12% (3)
• D
  4% (1)

Explanation

An Eventhouse (which contains KQL databases) is the correct choice because it is the only Fabric storage item that natively supports all three read engines simultaneously: KQL (its native query language), T-SQL (supported alongside KQL in Eventhouse), and Apache Spark (via the Kusto Spark connector). Critically, while KQL ingestion commands and streaming can also write to an Eventhouse, the scenario specifies that writes will be performed exclusively via Spark - which is a supported write path using the Spark-Kusto connector. A Lakehouse supports T-SQL (read-only via the SQL analytics endpoint) and Spark, but KQL is not a native read interface without configuring OneLake shortcuts into a separate KQL database. A Warehouse and Data Mart are SQL-only and do not support KQL or direct Spark writes in the same integrated way. Eventhouse is purpose-built for semi-structured, time-series, and analytical data queryable across all three engines.

No community discussion yet for this question.