Exam DP-700 Topic 1 Question 20 Discussion

Actual exam question for Microsoft's DP-700 exam
Question #: 20
Topic #: 1
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?

Suggested Answer: A Vote an answer

A lakehouse is the best option for storing semi-structured data when you need to read it using T-SQL, KQL, and Apache Spark. A lakehouse combines the flexibility of a data lake (which can handle semi-structured and unstructured data) with the performance features of a data warehouse. It allows data to be written using Apache Spark and can be queried using different technologies such as T-SQL (for SQL-based querying), KQL (Kusto Query Language for querying), and Apache Spark (for distributed processing). This solution is ideal when dealing with semi-structured data and requiring a versatile querying approach.

by machfer54 at May 09, 2025, 05:04 PM

Limited Time Offer

15%

Off

Get Premium DP-700 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
jadito6581
2026-07-04 10:30:31
an eventhouse
upvoted 1 times
...
jsduna
2025-07-23 10:56:48
B is correct, you can't use KQL in a Lakehouse
upvoted 3 times
...
kundradevansh5
2025-07-12 11:13:43
B is correct
upvoted 2 times
...
sarra.ben.alaya
2025-07-08 01:57:48
correct answer B. an eventhouse that ensures read option with KQL, T-SQL and Spark.
in the Lakehouse only Spark and T-SQL are supported for reading
upvoted 2 times
...
machfer54
2025-05-09 17:04:44
it's not possible to read data using kql in a lakehouse the eventhouse is the correct answer
upvoted 2 times
...
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10