Essential cookies keep authentication working. With your permission, we also use analytics cookies to understand and improve the product. Read our Privacy Policy

DataEngPrep.tech
QuestionsPracticeAI CoachDashboardPricingBlog
ProLogin

Interview Questions

Real questions from top companies in Spark/Big Data

700+ Easy450+ Medium650+ Hard
All CategoriesBehavioralSpark/Big DataSQLPython/CodingSystem Design/ArchitectureCloud/ToolsGeneral/Othereasymediumhard
41

What are the key components of the Spark execution model (Job, Stage, Task)?

Spark/Big Datahardjoinoptimizationpartition0.7 min read
FedEx DataworksFreight Tiger
β†’
42

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

Spark/Big Datamediumjoinpartitionspark0.6 min read
HashedInSnowflake
β†’
43

What is Spark's Catalyst Optimizer? Explain its stages.

Spark/Big Datahardjoinoptimizationspark0.7 min read
DunnhumbyFragma Data Systems
β†’
44

What is the difference between Spark RDDs, DataFrames, and Datasets?

Spark/Big Datahardoptimizationpartitionpython0.6 min read
AccentureFragma Data Systems
β†’
45

What is the difference between repartition and coalesce in Spark?

Spark/Big Datamediumpartitionspark0.6 min read
AccentureFedEx Dataworks
β†’
46

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

Spark/Big Datahardpartitionsparkwindow0.7 min read
Daniel WellingtonIncedo
β†’
47

When and how do you use Broadcast Join in Spark?

Spark/Big Datamediumjoinsparksql0.6 min read
Delivery HeroFragma Data Systems
β†’
48

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

Spark/Big Datamediumjoinsparksql0.7 min read
AltimetrikInfosys
β†’
49

What is the difference between Managed and External Tables in Databricks?

Spark/Big Dataeasysnowflakespark0.6 min read
AltimetrikIncedo
β†’
50

What is the difference between map and flatMap in Spark, and when would you use each?

Spark/Big Datamediumpartitionspark0.6 min read
AltimetrikInfosys
β†’
51

What is the purpose of the Bronze, Silver, and Gold layers in a data pipeline?

Spark/Big Datamedium0.6 min read
CapgeminiInfosys
β†’
52

What work is done by the executor memory in Spark?

Spark/Big Datamediumjoinpartitionspark0.6 min read
AltimetrikInfosys
β†’
53

When and how do you use Broadcast Join?

Spark/Big Datamediumjoinsparksql0.6 min read
AltimetrikInfosys
β†’
54

Why is SparkSession used in Spark 2.0 and later versions?

Spark/Big Datahardpythonsparksql0.5 min read
AltimetrikInfosys
β†’
55

Write a Python script to find the count of each word in a text file using Spark.

Spark/Big Datamediumpartitionpythonspark2 min read
AltimetrikInfosys
β†’
56

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

Spark/Big Datamediumpartitionsparksql2 min read
AltimetrikInfosys
β†’
57

Alternatives to the Medallion Architecture

Spark/Big Datahardjoinoptimizationpartition3.6 min read
KPMG
β†’
58

Apache Spark Architecture - RDD, DAG, cluster manager, driver node, worker node

Spark/Big Datahardjoinoptimizationpartition3.6 min read
Zen Data Shastra
β†’
59

Approaches to handling multiple tasks within a sprint?

Spark/Big Dataeasy0.6 min read
Snowflake
β†’
60

Broadcast Joins and Shuffle Merge Joins?

Spark/Big Datamediumjoinsparksql0.5 min read
Snowflake
β†’

Reading isn't practice. Get AI feedback on your answers.

Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.

Try AI Answer Coach β€” FreeStart a Mock Interview
Previous12345...11Next
Categories
All QuestionsSQLSpark / Big DataPython / CodingSystem DesignCloud / ToolsBehavioral
By Company
AmazonGoogleDatabricksSnowflakeAWSAzureMicrosoftNetflixUberTCS
Interview Guides
All GuidesTop SQL QuestionsTop Spark QuestionsPySpark QuestionsTop Python QuestionsTop System DesignKafka QuestionsAirflow QuestionsSQL Window FunctionsETL QuestionsData Modeling
Products
AI Interview CoachAnswer AnalyzerSQL PlaygroundResume AnalyzerAnswer Vault PDFsPricing
Company
About & Editorial PolicyContact UsAI DisclosureDisclaimerTerms of ServicePrivacy Policy
Β© 2026 DataEngPrep.tech. All rights reserved.
AboutBlogContactDisclaimer