Microsoft Fabric interview questions

A SaaS analytics platform that brings data engineering, data factory, warehousing, real-time analytics and Power BI together on OneLake.

A single, tenant-wide data lake for all Fabric items, storing tables in Delta format.

A lakehouse stores files and Delta tables and is mainly worked on with Spark. A warehouse is a full T-SQL experience with multi-table transactions.

A read-only T-SQL endpoint created for every lakehouse, so you can query its tables with SQL.

Links to data in other locations (ADLS, S3, other lakehouses) without copying it.

Power BI reads Delta tables in OneLake directly, giving near import speed without scheduled refresh copies.

A write-time optimisation of Parquet files that makes reads faster for Fabric engines, especially Power BI.

Dataflow Gen2 is low-code transformation with Power Query. Pipelines orchestrate activities like copy, notebooks and control flow.

The compute you buy (F SKUs) that all workspaces assigned to it share.

Spark notebooks transform data in lakehouses with PySpark or Spark SQL, and can be scheduled or run from pipelines.

Bronze, silver and gold layers, often as separate lakehouses, with notebooks or dataflows moving data between them.

Fabric's streaming workload: eventstreams for ingestion, Eventhouse with KQL databases for storage and querying, and Activator for alerts.

Kusto Query Language, used to query time-series and log data in Eventhouse.

Workspace roles, item permissions, OneLake security, row and column level security in the warehouse and semantic models, and sensitivity labels.

Git integration for workspaces and deployment pipelines to promote items from dev to test to prod.

The Monitoring hub for runs and the Capacity Metrics app for capacity usage and throttling.

COPY INTO, pipelines, dataflows, or cross-database queries from a lakehouse.

OPTIMIZE to compact small files and VACUUM to remove old files on lakehouse Delta tables.

The Microsoft Fabric Data Engineer Associate certification exam, covering ingestion, transformation, security, monitoring and optimisation in Fabric.

When the company already uses Power BI and Microsoft 365 and wants one platform with simple capacity-based pricing.