Fabric Analytics Engineer Associate Practice Test 2026 – Your All-in-One Complete Guide to Exam Success!

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards

From $12.50Unlock all

Session length

1 / 20

What data storage solution located in a Fabric workspace supports access via T-SQL or Python and can store unstructured or semi-structured data?

Data lake

Data warehouse

Datamart

Lakehouse

Access methods like T-SQL and Python alongside the ability to store unstructured or semi-structured data point to a lakehouse. A lakehouse combines the flexible storage of a data lake with the governance, performance, and schema features of a data warehouse, so you can keep raw or semi-structured data in one place and query it with SQL (T-SQL) or analyze it from Python. In Fabric, this unified storage model lets analysts run familiar SQL queries and data scientists work directly in Python on the same data, covering both workloads efficiently. By contrast, a data lake focuses on raw files without centralized SQL querying, a data warehouse centers on highly structured data optimized for SQL, and a datamart is a smaller, subject-area subset of a warehouse—none of these inherently pair unstructured data storage with both SQL and Python access in a single, unified way.