query.lab
all companies

Microsoft data interview guide

Telemetry, subscriptions and cloud usage — aggregations over time.

typical interview loop

  1. 1.Recruiter screen
  2. 2.Technical screen: SQL plus a Python data-manipulation exercise
  3. 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

filtering
3
GROUP BY
3
JOIN
3
groupby
2
sorting
2
Window functions
2

Based on 16 reconstructed Microsoft-style questions.

practice path

0 free · 16 Pro
  1. 1Active seats per tenantpandasMedium
  2. 2Alert severity escalationpythonMedium
  3. 3Azure spend per servicesqlEasy
  4. 4Churned license valuesqlMedium
  5. 5Compute spend growth March to AprilsqlHard
  6. 6Compute spend share per tenantsqlHard
  7. 7Cost per tenantpandasEasy
  8. 8Merge overlapping meeting blockspythonHard
  9. 9Parse a meter linepythonEasy
  10. 10Seat utilisationsqlMedium
  11. 11Service mix matrixpandasMedium
  12. 12Spend per tenant namesqlMedium
  13. 13Teams engagement per tenantsqlMedium
  14. 14Tenants by plansqlEasy
  15. 15Top spending day per tenantsqlHard
  16. 16Unresolved critical and high alertssqlMedium

Unlock all 16 Microsoft questions with Pro.

upgrade