Data engineering interview questions
SQL, Spark, pipelines, orchestration and warehousing.
348 questions · 24 topics · 48 free answers
0 of 348 practised · 0 bookmarked · saved on this device
348 questions
#1What are the types of joins?EasyConceptSQL for data engineers Pro answer
This answer is part of Pro
10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.
#2What are window functions and how do ROW_NUMBER, RANK and DENSE_RANK differ?MediumConceptSQL for data engineers Pro answer
This answer is part of Pro
10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.
#3How do you find the second highest salary per department?MediumConceptSQL for data engineers Pro answer
This answer is part of Pro
10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.
#4How do you remove duplicate rows from a table?MediumConceptSQL for data engineers Pro answer
This answer is part of Pro
10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.
#5What is a CTE and when is a recursive CTE useful?MediumConceptSQL for data engineers Pro answer
This answer is part of Pro
10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.
#6How do you write an incremental upsert in SQL?MediumConceptSQL for data engineers Pro answer
This answer is part of Pro
10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.
#7How do you calculate a running total and a moving average?MediumConceptSQL for data engineers Pro answer
This answer is part of Pro
10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.
#8What is a slowly changing dimension and what are Types 1, 2 and 3?MediumConceptSQL for data engineers Pro answer
This answer is part of Pro
10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.
#9A SQL report that ran in 2 minutes now takes 40. What do you check?MediumScenarioSQL for data engineers Pro answer
This answer is part of Pro
10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.
#10How do you handle skewed joins and data in distributed SQL engines?HardConceptSQL for data engineers Pro answer
This answer is part of Pro
10 of 348 Data engineering answers are free. A Pro pass opens the rest, including hands-on task steps.
Hunting for a Data engineering role too? See open Data engineering jobs.