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: join

#join

Questions tagged join

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

Why do you want to join this company?

Behavioralmediumjoin0.5 min read

AccentureDelivery HeroFragma Data Systems

What is Snowflake's architecture, and why is it unique?

Cloud/Toolshardbigqueryjoinoptimization3 min read

EYIncedoTech Mahindra

Briefly explain the architecture of Kafka.

System Design/Architecturehardjoinoptimizationpartition3 min read

Delivery HeroGrover

Describe the data pipeline architecture you've worked with.

System Design/Architecturehardjoinoptimizationpartition3 min read

Fragma Data SystemsGrover

Explain the trade-offs between batch and real-time data processing. Provide examples of when each is appropriate.

System Design/Architecturehardjoin0.8 min read

What is the difference between OLTP and OLAP?

General/Otherhardbigqueryetljoin0.7 min read

AareteDunnhumbyFragma Data Systems

What is the difference between SQL and NoSQL databases?

General/Othermediumjoinsql0.7 min read

AareteDunnhumbyFragma Data Systems

Detail examples of inner, outer, left, and right joins.

SQLmediumjoin0.7 min read

ImpetusTech Mahindra

Explain SQL Window Functions with examples.

SQLmediumjoinpartitionsql0.5 min read

AareteDunnhumbyIncedo

Explain the use of the MERGE statement in SQL.

SQLmediumbigqueryjoinpartition0.5 min read

AareteDunnhumbyIncedo

How do you handle NULL values in SQL? Mention functions like COALESCE and ISNULL.

SQLmediumjoinsql0.5 min read

AareteDunnhumbyIncedo

How do you optimize a long-running SQL query?

SQLhardjoinoptimizationpartition0.6 min read

AareteDunnhumbyIncedo

What are primary keys and foreign keys? Why are they important?

SQLmediumjoin0.4 min read

What is a self-join, and when would you use it?

SQLmediumjoin0.4 min read

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

SQLmediumetljoin0.4 min read

What is a window function? Explain with an example.

SQLmediumjoinpartitionwindow0.5 min read

37

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

SQLmedium

38

Design a cost-aware resource strategy for a Databricks workload with spiky and batch jobs. Explain Dynamic Resource Allocation, when to disable it, and how min/max executors and spot instances affect cost and SLAs.

Spark/Big Datahard

39

Design an anti-skew strategy for a join on a high-cardinality key with a long-tail distribution (e.g., a few keys hold 80% of rows). Cover salting, split-skew, AQE, and cost/operational trade-offs.

Spark/Big Datahard

40

Prioritize Spark optimizations by impact and effort. Discuss partitioning strategy, caching policy, join selection, shuffle reduction, and when each becomes a scalability or cost bottleneck.

Spark/Big Datahard

+4 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...24 Next

Other Tags

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