A DataEngineering Portal

For teams Log in Start practising free

Microsoft

SQL depth plus Python data handling; fewer Spark internals.

9 questions

SQL · 3Python · 1PySpark · 5

Status	Title	Technology	Topic	Acceptance	Difficulty
○	13.Second highest salary per department	SQL	Window functions	23.9%	Easy
○	5.Top N products per category	SQL	Aggregation	26.7%	Easy
○	16.Running balance per account	SQL	Window functions	50.0%	Medium
○	21.Validate JSON records against a schema	Python	Data modeling	100.0%	Easy
○	77.Running balance per account	PySpark	Window functions	100.0%	Medium
○	82.Median salary per department	PySpark	Aggregation	100.0%	Medium
○	83.Pivot revenue into a column per category	PySpark	Aggregation	—	Medium
○	89.Unpivot quarterly targets	PySpark	Aggregation	—	Medium
○	93.Days the feed never delivered	PySpark	Anti-join	—	Medium

Community-reported interview topics. Not official Microsoft questions and no affiliation is implied.