#join

Questions tagged join · medium

All easy (0)medium (210+)hard (250+)

What is normalization and denormalization? When would you use each?

SQLmediumetljoin0.4 min read

PresidioSwiggy

→

What is a window function? Explain with an example.

SQLmediumjoinpartitionwindow0.5 min read

CitiFreecharge

→

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

SQLmedium

Explain how Adaptive Query Execution changes the economics of Spark tuning. What problems does it solve at runtime, and when might you still need manual intervention (e.g., salting, broadcast hints)?

Spark/Big Datamedium

How do you handle data skewness in Spark?

Spark/Big Datamedium

What is Adaptive Query Execution (AQE) in Spark 3.x, and how does it improve performance?

Spark/Big Datamedium

When and how do you use Broadcast Join in Spark?

Spark/Big Datamedium

What is broadcasting in Spark, and why is it used? Can you give an example of its use?

Spark/Big Datamedium

What work is done by the executor memory in Spark?

Spark/Big Datamedium

When and how do you use Broadcast Join?

Spark/Big Datamedium

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

Previous 1 2 3 4...11 Next

Other Tags

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

#join

Questions tagged join · medium

All easy (0)medium (210+)hard (250+)

What is normalization and denormalization? When would you use each?

SQLmediumetljoin0.4 min read

PresidioSwiggy

→

What is a window function? Explain with an example.

SQLmediumjoinpartitionwindow0.5 min read

CitiFreecharge

→

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

SQLmedium

Explain how Adaptive Query Execution changes the economics of Spark tuning. What problems does it solve at runtime, and when might you still need manual intervention (e.g., salting, broadcast hints)?

Spark/Big Datamedium

How do you handle data skewness in Spark?

Spark/Big Datamedium

What is Adaptive Query Execution (AQE) in Spark 3.x, and how does it improve performance?

Spark/Big Datamedium

When and how do you use Broadcast Join in Spark?

Spark/Big Datamedium

What is broadcasting in Spark, and why is it used? Can you give an example of its use?

Spark/Big Datamedium

What work is done by the executor memory in Spark?

Spark/Big Datamedium

When and how do you use Broadcast Join?