#window

Questions tagged window · hard

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

Joins and window functions - INNER, LEFT, RIGHT, FULL OUTER, ROW_NUMBER(), RANK(), DENSE_RANK()

SQLhardjoinpartitionwindow0.7 min read

FordKPMGNihilent

→

How do you handle late-arriving data in Spark Structured Streaming?

Spark/Big Datahardsparkwindow0.5 min read

BitwiseIncedoSwiggy

→

Briefly explain the architecture of Kafka.

System Design/Architecturehardjoinoptimizationpartition3 min read

Delivery HeroGrover

→

Retrieve the most recent sale_timestamp for each product (Latest Transaction).

General/Otherhardbigquerypartitionsnowflake0.6 min read

PresidioSwiggy

→

Explain the difference between batch and streaming data processing in Data Fusion.

Spark/Big Datahard

How would you implement a sliding window aggregation in Spark Structured Streaming?

Spark/Big Datahard

Implement a Spark job to find the top 10 most frequent words in a large text file.

Spark/Big Datahard

What is the small-file problem in Spark, and how do you solve it?

Spark/Big Datahard

Describe a time you had to make a difficult decision with limited information.

Behavioralhard

On-Premises to Cloud Integration Runtime

Cloud/Toolshard

Find orders exceeding $1,000 in the last 30 days.

General/Otherhard

Implement a rate-limiter to control API requests per user.

General/Otherhard

+16 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

1 2 3...5 Next

Other Tags

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

#window

Questions tagged window · hard

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

Joins and window functions - INNER, LEFT, RIGHT, FULL OUTER, ROW_NUMBER(), RANK(), DENSE_RANK()

SQLhardjoinpartitionwindow0.7 min read

FordKPMGNihilent

→

How do you handle late-arriving data in Spark Structured Streaming?

Spark/Big Datahardsparkwindow0.5 min read

BitwiseIncedoSwiggy

→

Briefly explain the architecture of Kafka.

System Design/Architecturehardjoinoptimizationpartition3 min read

Delivery HeroGrover

→

Retrieve the most recent sale_timestamp for each product (Latest Transaction).

General/Otherhardbigquerypartitionsnowflake0.6 min read

PresidioSwiggy

→

Explain the difference between batch and streaming data processing in Data Fusion.

Spark/Big Datahard

How would you implement a sliding window aggregation in Spark Structured Streaming?

Spark/Big Datahard

Implement a Spark job to find the top 10 most frequent words in a large text file.

Spark/Big Datahard

What is the small-file problem in Spark, and how do you solve it?

Spark/Big Datahard

Describe a time you had to make a difficult decision with limited information.

Behavioralhard

On-Premises to Cloud Integration Runtime

Cloud/Toolshard

Find orders exceeding $1,000 in the last 30 days.

General/Otherhard

Implement a rate-limiter to control API requests per user.

General/Otherhard

+16 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

1 2 3...5 Next

Other Tags

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