πŸͺ

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

DDataEngPrep.tech
Home
PricingBlog
Sign InStart Free→

Interview Questions

Real questions from top companies in Spark/Big Data Β· medium

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

What work is done by the executor memory in Spark?

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

When and how do you use Broadcast Join?

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

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

Spark/Big Datamediumpartitionpythonspark2 min read
AltimetrikInfosys
β†’
24

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

Spark/Big Datamediumpartitionsparksql2 min read
AltimetrikInfosys
β†’
25

Broadcast Joins and Shuffle Merge Joins?

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

Can you explain the concept of mappers in Spark, and how are they used in data transformations?

Spark/Big Datamediumpartitionspark0.5 min read
Infosys
β†’
27

Code a simple PySpark job to read a JSON file, filter records, and write output in Parquet format.

Spark/Big Datamediumpartitionpythonspark0.5 min read
American Express
β†’
28

How do you handle out-of-memory errors in Spark jobs?

Spark/Big Datamediumjoinpartitionspark0.5 min read
Fragma Data Systems
β†’
29

How do you handle very large datasets in Spark to ensure scalability and efficiency?

Spark/Big Datamediumjoinpartitionspark0.5 min read
Coforge
β†’
30

Provide specific examples of challenges faced with PySpark and SQL and solutions implemented.

Spark/Big Datamediumjoinpartitionspark0.5 min read
S&P Global
β†’
31

Split a DataFrame such that even numbers appear in one column and odd numbers in another

Spark/Big Datamediumpartitionpythonspark0.5 min read
KPMG
β†’
32

Steps to mount storage in Databricks.

Spark/Big Datamediumsparkwindow0.5 min read
Chubb
β†’
33

Transformation vs. Action in PySpark?

Spark/Big Datamediumjoinpartitionspark0.6 min read
Comcast
β†’
34

What Hadoop command would you use to merge multiple files into one?

Spark/Big Datamediumpartitionspark0.5 min read
Infosys
β†’
35

What are the limitations of the REORG command with respect to large datasets?

Spark/Big Datamediumpartition0.5 min read
PWC
β†’
36

What causes Out of Memory (OOM) issues in Databricks, and how do you resolve them?

Spark/Big Datamediumpartitionspark0.5 min read
PWC
β†’
37

What is Shuffle and How to Handle It in Spark

Spark/Big Datamediumjoinpartitionspark0.5 min read
Nagarro
β†’
38

Write PySpark code to extract data from a CSV and create a table.

Spark/Big Datamediumpartitionpythonspark0.3 min read
HCL
β†’
39

Write PySpark code to save a DataFrame in Parquet format to an S3 bucket.

Spark/Big Datamediumpartitionpythonspark0.3 min read
Carelon
β†’
40

Write a PySpark job that calculates the number of unique users who logged in per day, but exclude any logins from inactive users listed in a separate file.

Spark/Big Datamediumjoinpartitionpython0.3 min read
Dunnhumby
β†’

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
Previous123Next
Topic Hubs
All Topic Hubs (12 Competencies) β†’All 1,863+ QuestionsSQL Interview QuestionsApache Spark QuestionsPySpark QuestionsPython for Data EngineersSystem Design InterviewData Modeling & WarehousingStreaming (Kafka/Flink)SQL Window FunctionsETL Pipeline Design
Company Hubs
All Company Hubs (100+ Companies) β†’AmazonGoogleMetaDatabricksSnowflakeNetflixUberStripeMicrosoftAppleGoldman SachsAWS Engineering
Academies & Guides
All Guides & ArticlesData Engineering AcademyForward Deployed AI AcademyClient Simulation StudioApache Airflow QuestionsAzure Data EngineerBehavioral & STAR MethodCloud & Distributed Tools
AI Tools & Products
Answer Analyzer (Free)AI Mock InterviewsSQL PlaygroundATS Resume AnalyzerOffline PDF Answer VaultsMembership & Pricing
Company
About & Editorial PolicyContact UsAI DisclosureDisclaimerTerms of ServicePrivacy Policy
Β© 2026 DataEngPrep.tech. All rights reserved.
AboutBlogContactDisclaimer