Store semi-structured data readable by T-SQL, KQL, and Spark in an eventhouse

DP-700 By islever Editorial Last updated

Ingest and transform batch data

Short answer

B An eventhouse is the only listed Fabric store that can be read with KQL, T-SQL, and Spark, meeting the multi-engine read requirement.

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?
  1. a lakehouse
  2. an eventhouse Correct Answer
  3. a datamart
  4. a warehouse

Key Takeaways

KQL query capability is unique to eventhouses in Fabric; any requirement to read data via KQL rules out lakehouse, warehouse, and datamart as the sole store.

When data must be read with T-SQL, KQL, and Apache Spark and is written only by Spark, an eventhouse is the suitable Fabric data store because it is the only option among the choices that natively supports KQL reads alongside T-SQL and Spark.

Common mistake: Choosing a lakehouse solely because semi-structured data fits there, while overlooking that native KQL reads require an eventhouse (a lakehouse would need integration with Real-Time Intelligence).

Expert Analysis

Why the Answer Is Correct

The Fabric data store decision guide shows that an eventhouse supports read operations via KQL, T-SQL, and Spark, while a lakehouse does not natively serve KQL queries without integrating Real-Time Intelligence. Because the requirement explicitly includes reading the data with KQL, the eventhouse is the only listed store that fully satisfies all three read engines, and it also accepts Spark writes.

Why the Other Options Are Wrong

Option A (lakehouse) stores semi-structured data and supports Spark and T-SQL via the SQL endpoint, but not native KQL reads. Option C (datamart) is for self-service downstream reporting, not multi-engine analytical reads. Option D (warehouse) is relational and supports T-SQL, not KQL.

Community Comment Notes

Community voting is close (B 57 vs A 43). The highest-voted comment (38578c4, 11 likes) states KQL is available only in eventhouses, and several others link the Fabric decision guide confirming eventhouse read engines include KQL, T-SQL, and Spark.

Official Reference

https://learn.microsoft.com/en-us/fabric/fundamentals/decision-guide-data-store

This link opens the official vendor documentation in a new tab.

Community Votes

B
57%
A
43%

57% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 20 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 20

  1. 38578c4 👍 11 Answered B
    KQL is avaialble in eventhouse only https://learn.microsoft.com/en-us/fabric/fundamentals/decision-guide-data-store
  2. fffsssggg 👍 7 Answered B
    Eventhouse: Read operations: KQL, Spark and T-SQL Write operations: KQL, Spark https://learn.microsoft.com/en-us/fabric/get-started/decision-guide-data-store
  3. chimuelo69 👍 4 Answered A
    A lakehouse in Microsoft Fabric is a versatile storage option designed for semi-structured and unstructured data, combining the flexibility of a data lake with the structure of a data warehouse. It supports Apache Spark, T-SQL, and KQL queries, making it ideal for the requirements. Why the other options are not suitable: B. Eventhouse: Eventhouse is not a valid Microsoft Fabric storage option. C. Datamart: A datamart is designed for structured data and primarily supports T-SQL, but not Spark or KQL. D. Warehouse: A warehouse is optimized for structured data and supports T-SQL, but it is not designed for semi-structured data or Spark. A lakehouse is the best choice for storing data in a format that allows Spark to write it while enabling T-SQL and KQL for querying.
  4. 568f95c 👍 3 Answered A
    A Lakehouse in Microsoft Fabric is the best choice for storing semi-structured data while allowing access using T-SQL, KQL, and Apache Spark B. Eventhouse - Designed for real-time event processing. - Does not support T-SQL or Apache Spark writes. C. Datamart - Built for self-service BI, supports T-SQL, but not Spark-based writing. - Not optimized for semi-structured data. D. Warehouse - Optimized for structured relational data (fact & dimension tables). - Does not support KQL or Spark-based writes.
  5. GLG 👍 3 Answered A
    Lakehouse: data will only be written bij using Spark. You can use shortcuts to access the data from een Eventhouse for KQL queries. If real-time processing or KQL were requitements, Eventhouse would be more appropiate.
Show 15 more comments
  1. mmanrik 👍 3 Answered B
    The eventhouse is the only one out of the four options that allows the creation of a KQL Database, therefore it is the only option that fully meets the criteria (being able to read the date via KQL, T-SQL and Spark).
  2. Tuki93 👍 3 Answered A
    You have semi-structured data. The data will only be written by using Spark.
  3. QAZdbarhate12345678 👍 3 Answered A
    lakehouse is the most appropriate choice for this scenario
  4. ayushc 👍 2 Answered A
    By default you cannot query a lakehouse with kql but if you integrate it with Real time analytics you are able to query the lakehouse with kql
  5. SannaLH 👍 2 Answered B
    Like 38578c4 link says: Eventhouse support read with: KQL, T-SQL, Spark & write with: KQL, Spark, connector ecosystem
  6. kryper_reg 👍 2 Answered A
    Semi structured data should be stored in a lakehouse
  7. zxc01 👍 1 Answered B
    I think eventhouse should be correct answer because it can support KQL, Spark and T-SQL. And can support semi-structured data event not good like lakehouse. The problem if we keep semi-structured data in lakehouse, we still need eventhouse to execute KQL on them. However, we just can build shortcut in KQL database to point delta tables in lakehouse(by OneLake), we cannot point to semi-structured files.
  8. Adriel_1996 👍 1 Answered B
    Based on documentation read on eventhouse allows SQL,T-SQL and Spark. https://learn.microsoft.com/en-us/fabric/fundamentals/decision-guide-data-store
  9. DataConsultant 👍 1 Answered A
    A Lakehouse in Microsoft Fabric is the best choice for storing semi-structured data while allowing access using T-SQL, KQL, and Apache Spark
  10. CMDev 👍 1 Answered B
    Check this link and choose an answer, it must be B. https://learn.microsoft.com/en-us/fabric/fundamentals/decision-guide-data-store
  11. Pierrejul 👍 1 Answered B
    https://learn.microsoft.com/en-us/fabric/fundamentals/decision-guide-data-store
  12. pierre314 👍 1 Answered B
    Eventhouse: Read operations: KQL, Spark and T-SQL Write operations: KQL, Spark
  13. basene 👍 1 Answered A
    You are deal with semi-structured data and we would like to use only spark.
  14. JensQ 👍 1 Answered B
    Out of the available options, only eventhouse can be read using KQL
  15. Pierrejul 👍 1 Answered A
    lakehouse permit to read Spark data We are not in KQL

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

A 500-million-row fact table exceeds the F32 Direct Lake guardrail, so increase the capacity to F64

S-grade

Shortcut caching supports only S3/GCS shortcuts and excludes files larger than 1 GB

S-grade

Updating warehouse tables requires at least the Contributor workspace role because Write is not shareable to a Viewer

S-grade

Run T-SQL in a KQL database only by prefixing the query with a -- comment line

S-grade

← Back to DP-700 Study Guide