DataEngPrep.tech
QuestionsPracticeAI CoachDashboardPacksBlog
ProLogin

Interview Questions

Real questions from top companies Β· medium

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

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
β†’
62

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

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

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

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

What work is done by the executor memory in Spark?

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

When and how do you use Broadcast Join?

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

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

Spark/Big Datamediumpartitionpythonspark0.4 min read
AltimetrikInfosys
β†’
67

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

Spark/Big Datamediumpartitionsparksql0.5 min read
AltimetrikInfosys
β†’
68

Write a Python function to check if a string is a palindrome.

Python/Codingmediumjoinpython0.4 min read
AltimetrikInfosys
β†’
69

Describe a time when you went above and beyond for a project or a customer.

Behavioralmediumpartition0.7 min read
PresidioSwiggy
β†’
70

Give an example of a time you failed and what you learned from it.

Behavioralmediumjoin0.7 min read
PresidioSwiggy
β†’
71

Can you provide an example of a time when you went above and beyond for a project?

Behavioralmediumpartition0.7 min read
Wipro
β†’
72

Examples of conflicts with team members and how they were resolved.

Behavioralmediumairflowjoin1 min read
Thoughtworks
β†’
73

How do you handle conflict with a product manager?

Behavioralmedium0.7 min read
Google
β†’
74

Share a time when you had to explain a complex technical issue to a non-technical stakeholder.

Behavioralmediumjoin0.2 min read
Adidas
β†’
75

Tell me about a time when a Spark job failed in production. How did you fix it?

Behavioralmediumjoinpartitionspark0.2 min read
Microsoft
β†’
76

Tell me about a time when you faced a tight deadline in a project, and how did you manage it?

Behavioralmedium0.2 min read
PLEO
β†’
77

Tell me about a time you handled a data pipeline failure during a critical operation.

Behavioralmediumpartition0.2 min read
Goldman Sachs
β†’
78

What challenges can arise when using high degrees of parallelism?

Behavioralmediumpartition0.2 min read
Virtusa
β†’
79

What challenges did you encounter when scaling your project?

Behavioralmediumpartitionspark0.2 min read
Bitwise
β†’
80

What storage format would you choose for analytics-heavy workloads and why?

Behavioralmediumlakehousepartition0.2 min read
Microsoft
β†’

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
Previous123456...24Next
Categories
All QuestionsSQLSpark / Big DataPython / CodingSystem DesignCloud / ToolsBehavioral
By Company
AmazonGoogleDatabricksSnowflakeMicrosoftNetflixUberTCS
Interview Guides
All GuidesTop SQL QuestionsTop Spark QuestionsTop Python QuestionsTop System DesignSQL Window FunctionsETL QuestionsData Modeling
Products
AI Interview CoachAnswer AnalyzerSQL PlaygroundResume AnalyzerInterview PacksPricing
Company
About UsContact UsAI DisclosureDisclaimerTerms of ServicePrivacy Policy
Β© 2026 DataEngPrep.tech. All rights reserved.
AboutBlogContactDisclaimer