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 Β· 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 Datamediumpartitionpythonspark2 min read
AltimetrikInfosys
β†’
67

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

Spark/Big Datamediumpartitionsparksql2 min read
AltimetrikInfosys
β†’
68

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

Python/Codingmediumjoinpython2 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

Why do you want to join American Express?

Behavioralmediumjoin2 min read
American Express
β†’
75

Why do you want to join EPAM?

Behavioralmediumjoin1 min read
EPAM
β†’
76

Copy Large Files from On-Premises to Azure in ADF

Cloud/Toolsmediumwindow0.7 min read
Presidio
β†’
77

Data Load in Synapse Table?

Cloud/Toolsmediumjoin0.6 min read
Deloitte
β†’
78

How do you handle data cleanup and lifecycle management in S3?

Cloud/Toolsmediumpartition2 min read
Moonfare
β†’
79

How would you migrate 1TB of data using ADF?

Cloud/Toolsmediumpartition0.8 min read
Virtusa
β†’
80

How would you optimize cost when using AWS for large-scale data processing?

Cloud/Toolsmediumpartition0.7 min read
Wipro
β†’

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...9Next
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