Microsoft Fabric interview questionsTechnical interview questions
← Interview & exam prep
Technical interview questions

Microsoft Fabric interview questions

15 questions from beginner to advanced, each with the correct answer and a one-line explanation of why. Study them here, or take them as a timed test.

15 questionsBeginner 8 · Intermediate 7Answers + explanations
Take it as a timed test
Free PDF
All 389 questions & answers, in one file

DAX, Excel, Power BI, Fabric, certification practice and analyst interviews — every answer with the reason behind it. Print it, study it offline.

Instant download, plus the free Tuesday briefing. Unsubscribe in one click.

Beginner 8 questions

1OneLake is…

  1. A single storage account per report
  2. A capacity SKU
  3. A visual
  4. A gateway
  5. One unified, tenant-wide logical data lake
Show answerHide answer

E · One unified, tenant-wide logical data lake OneLake is the single, organization-wide data lake underpinning Fabric (OneDrive for data).

2Direct Lake storage mode…

  1. Reads Delta/Parquet from OneLake without import or DirectQuery translation
  2. Requires a gateway
  3. Caches in the browser
  4. Imports data on a schedule
  5. Only works on-premises
Show answerHide answer

A · Reads Delta/Parquet from OneLake without import or DirectQuery translation Direct Lake reads columnar files directly, giving import-like speed without a refresh copy.

3A OneLake 'shortcut'…

  1. Is a keyboard macro
  2. Copies data nightly
  3. References data in place without copying it
  4. Compresses tables
  5. Deletes duplicates
Show answerHide answer

C · References data in place without copying it Shortcuts virtualize external/other data into OneLake without duplication.

4A Lakehouse combines…

  1. Lake storage with a SQL analytics endpoint and table semantics
  2. Only files
  3. Only a database
  4. Two gateways
  5. Two warehouses
Show answerHide answer

A · Lake storage with a SQL analytics endpoint and table semantics A Lakehouse gives you files + Delta tables + a read-only SQL endpoint in one item.

5The Delta Lake format is essentially…

  1. JSON only
  2. Parquet plus a transaction log enabling ACID
  3. A zip archive
  4. An Excel file
  5. Plain CSV
Show answerHide answer

B · Parquet plus a transaction log enabling ACID Delta = Parquet data files + a JSON transaction log for ACID and time travel.

6Fabric compute is billed in…

  1. Reports
  2. Capacity Units (CU) via F SKUs
  3. Users
  4. Refreshes
  5. Gigabytes
Show answerHide answer

B · Capacity Units (CU) via F SKUs Fabric capacities (F2, F64, …) are measured in Capacity Units.

7A Fabric Notebook primarily runs on…

  1. SSAS
  2. VertiPaq
  3. Excel
  4. Apache Spark
  5. A gateway
Show answerHide answer

D · Apache Spark Notebooks execute Spark (PySpark/Scala/SQL) against Lakehouse data.

8Data Factory in Fabric provides…

  1. A semantic model
  2. Only visuals
  3. RLS
  4. Pipelines and dataflows for orchestration and ETL
  5. A gateway
Show answerHide answer

D · Pipelines and dataflows for orchestration and ETL Fabric Data Factory offers pipelines and Dataflows Gen2 for moving and transforming data.

Intermediate 7 questions

9Direct Lake typically FALLS BACK to DirectQuery when…

  1. Unsupported features or data exceed the mode's guardrails
  2. A slicer is used
  3. The user is offline
  4. RLS is applied
  5. The report is large
Show answerHide answer

A · Unsupported features or data exceed the mode's guardrails Exceeding guardrails (size/features) triggers automatic DirectQuery fallback.

10In Fabric, a Warehouse (vs a Lakehouse) offers…

  1. Only Python
  2. No SQL
  3. Only Spark
  4. Files only
  5. Full T-SQL with multi-table read/write transactions
Show answerHide answer

E · Full T-SQL with multi-table read/write transactions The Warehouse is a full T-SQL engine with read/write; the Lakehouse SQL endpoint is read-only.

11The medallion architecture layer order is…

  1. Raw → Gold → Bronze
  2. Silver → Bronze → Gold
  3. Bronze → Silver → Gold
  4. Bronze → Gold
  5. Gold → Silver → Bronze
Show answerHide answer

C · Bronze → Silver → Gold Bronze (raw) → Silver (cleaned/conformed) → Gold (curated/serving).

12V-Order optimization…

  1. Reorders Parquet for faster VertiPaq/Direct Lake reads
  2. Deletes duplicates
  3. Adds indexes to SQL
  4. Encrypts files
  5. Sorts rows alphabetically
Show answerHide answer

A · Reorders Parquet for faster VertiPaq/Direct Lake reads V-Order is a write-time Parquet optimization that speeds columnar reads.

13Dataflows Gen2 can write their output to…

  1. Only the Power BI model
  2. Nowhere; they are read-only
  3. Lakehouse/Warehouse (and other) destinations
  4. Only CSV on disk
  5. Only Excel
Show answerHide answer

C · Lakehouse/Warehouse (and other) destinations Gen2 dataflows support configurable output destinations like Lakehouse and Warehouse.

14The SQL analytics endpoint of a Lakehouse is…

  1. A Spark cluster
  2. Read/write T-SQL
  3. Read-only T-SQL over the Delta tables
  4. A gateway
  5. A dataflow
Show answerHide answer

C · Read-only T-SQL over the Delta tables You can query (SELECT) the Lakehouse tables via T-SQL, but writes go through Spark/Delta, not this endpoint.

15A default semantic model over a Lakehouse uses which storage mode?

  1. Import
  2. Dual
  3. DirectQuery
  4. Direct Lake
  5. Composite
Show answerHide answer

D · Direct Lake Fabric auto-creates a Direct Lake semantic model over the Lakehouse tables.

What changed lately? Latest Microsoft Fabric news, releases & questions →

Coming soon $19 one-time · early-access price
Prep Pro: full mock exams
  • Full-length, timed mock exams in the real PL-300, DP-600 and MO-201 format
  • Score breakdown by skill, with a study plan for your weak spots
  • New questions every month, written against the current exam outline

No payment now. We'll email you once, when it opens.

More technical interview questions