DataEngPrep.tech

JavaScript is required to use this application. Please enable JavaScript in your browser settings or disable any extensions that may be blocking scripts.

Loading...

DataEngPrep.tech

Questions Practice AI Coach Dashboard Packs Blog

Home/Questions/Tag: window

#window

Questions tagged window · medium

All easy (0)medium (60+)hard (90+)

Write an SQL query to find the second-highest salary from an employee table.

SQLmediumpartitionsqlwindow0.8 min read

AccentureBCGCognizantIncedo+2

Demonstrate the difference between DENSE_RANK() and RANK()

SQLmediumpartitionwindow0.5 min read

CapcoImpetusKPMGWipro

Discuss differences between ROW_NUMBER(), RANK(), and DENSE_RANK(), and provide examples from your projects.

SQLmediumwindow0.5 min read

AareteAccentureFossil GroupYash Technologies

Explain the types of triggers in ADF, including schedule, tumbling window, and event-based triggers.

SQLmediumpartitionwindow0.5 min read

FedEx DataworksNihilentVirtusa

Explain SQL Window Functions with examples.

SQLmediumjoinpartitionsql0.5 min read

AareteDunnhumbyIncedo

Implement a query to find the top 5 customers by total sales amount.

SQLmediumpartitionwindow0.5 min read

Daniel WellingtonGoldman SachsSwiggy

SQL query to find the second highest salary from each department.

SQLmediumpartitionsqlwindow0.4 min read

AccentureYash Technologies

Write an SQL query to find duplicate emails in a users table.

SQLmediumpartitionsqlwindow0.5 min read

Daniel WellingtonGoldman SachsSwiggy

Triggers in ADF, especially tumbling window triggers.

SQLmediumpartitionwindow0.5 min read

AccentureYash Technologies

What is a window function? Explain with an example.

SQLmediumjoinpartitionwindow0.5 min read

11

Write a query to find the top three highest-paid employees in each department using window functions.

SQLmedium

12

Write complex SQL queries involving multiple joins, subqueries, and data aggregation logic.

SQLmedium

13

Convert complex SQL (CTEs, window functions, subqueries) to production-grade PySpark. Discuss when to use spark.sql() vs. DataFrame API, and the implications for testability, partitioning, and execution predictability.

Spark/Big Datamedium

14

Write the PySpark code to find the second highest salary in each department.

Spark/Big Datamedium

15

Copy Large Files from On-Premises to Azure in ADF

Cloud/Toolsmedium

16

Explain how you debug failed pipelines in ADF.

Cloud/Toolsmedium

17

Explain the key components of Apache Beam in the context of Google Dataflow.

Cloud/Toolsmedium

18

How do you merge data from different sources in ADF while maintaining data quality?

Cloud/Toolsmedium

+10 More Questions with Expert Answers

Unlock all 1,800+ expert answers, AI mock interviews, resume analyzer, SQL playground, and personalized progress tracking.

Unlock Full Access Try AI Coach Free

Other Tags

#join #partition #python #spark #optimization #sql #airflow #etl #bigquery #snowflake #lakehouse