Microsoft SQL interview questions
Telemetry, subscriptions and cloud usage — aggregations over time. Practice reconstructed Microsoft-style SQL, Python and pandas interview questions below — run and grade them instantly in your browser.
sqlpandaspythoneasy4medium8hard4
typical interview loop
- 1.Recruiter screen
- 2.Technical screen: SQL plus a Python data-manipulation exercise
- 3.Onsite: data modeling / pipeline design, coding, behavioral
- › Date bucketing and rolling windows are common.
- › Explain trade-offs between CTEs and subqueries.
most-tested topics
GROUP BY
3
filtering
3
JOIN
3
groupby
2
sorting
2
ratios
2
Based on 16 reconstructed Microsoft-style questions.
practice path
1 free · 15 Protype
level
- 1Azure spend per servicesqleasy
- 2Cost per tenantpandaseasy
- 3Parse a meter linepythoneasy
- 4Tenants by plansqleasy
- 5Active seats per tenantpandasmedium
- 6Alert severity escalationpythonmedium
- 7Churned license valuesqlmedium
- 8Seat utilisationsqlmedium
- 9Service mix matrixpandasmedium
- 10Spend per tenant namesqlmedium
- 11Teams engagement per tenantsqlmedium
- 12Unresolved critical and high alertssqlmedium
- 13Compute spend growth March to Aprilsqlhard
- 14Compute spend share per tenantsqlhard
- 15Merge overlapping meeting blockspythonhard
- 16Top spending day per tenantsqlhard
Unlock all 16 Microsoft questions with Pro.
upgrade