Fabric & SQL Server Interview Question Bank

Most interview prep lists are generic. This one was built backwards from a real Microsoft Fabric Consultant JD and the actual pre-interview brief a candidate received — so it covers what's genuinely asked, not what's easy to list.

What's inside:

• 105 questions across 16 sections
• Heavy weighting on SQL Server / SSMS hands-on — normalization, DDL/DML/DCL, joins and CTEs, window functions, stored procedures and triggers, indexes, execution plans, transactions, backup/security
• Fabric-specific: OneLake, Lakehouse vs Warehouse, Direct Lake, Shortcuts, Mirroring, Capacities, Deployment Pipelines
• Data engineering: Medallion architecture, Delta Lake, incremental loading, Spark performance, idempotency
• Power BI & DAX: semantic models, row vs filter context, RLS/OLS
• Answer pointers on the high-trap questions
• Live coding drills to practice on a shared screen
• Behavioral/consulting questions in STAR format

Who it's for: data engineers with 5–12 years' experience preparing for Fabric, Azure, or senior data engineering interviews.

Note on currency: the document flags fast-moving Fabric features so you know which specifics to re-verify against current Microsoft Learn docs before your interview — Fabric changes quickly and stale answers cost you.