DataEngPrep.tech
QuestionsPracticeAI CoachDashboardPacksBlog
ProLogin

Interview Questions

Real questions from top companies Β· easy

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

What is Azure Data Factory (ADF), and what are its main components?

Cloud/Toolseasy0.6 min read
EYIncedoTech Mahindra
β†’
22

What is the role of the Integration Runtime (IR) in ADF?

Cloud/Toolseasy0.7 min read
EYIncedoTech Mahindra
β†’
23

Explain Common Table Expressions (CTEs) and their benefits.

SQLeasybigquery0.5 min read
AareteDunnhumbyIncedo
β†’
24

Explain the difference between UNION and UNION ALL.

SQLeasy0.4 min read
PresidioSwiggy
β†’
25

What is the difference between a clustered and non-clustered index?

SQLeasybigquerysql0.4 min read
PresidioSwiggy
β†’
26

What is the difference between DELETE and TRUNCATE?

SQLeasy0.4 min read
PresidioSwiggy
β†’
27

What is a CTE (Common Table Expression)? What are its uses?

SQLeasybigquerysnowflake0.6 min read
Fossil GroupKaseya
β†’
28

When would you architecturally choose Dataset[T] over DataFrame in a Scala Spark pipeline, and what are the scalability and portability trade-offs? Include type-safety benefits vs. operational constraints.

Spark/Big Dataeasyetlpythonspark0.6 min read
CoforgeLTIMindtree
β†’
29

Write a Python function to find the first non-repeating character in a string.

Python/Codingeasypython0.7 min read
Delivery HeroDunnhumby
β†’
30

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

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

Explain the difference between a list and a tuple in Python.

Python/Codingeasypython0.5 min read
AltimetrikInfosys
β†’
32

How do you handle exceptions in Python? Provide an example.

Python/Codingeasypython0.4 min read
AltimetrikInfosys
β†’
33

What is the difference between shallow copy and deep copy in Python?

Python/Codingeasypython0.5 min read
AltimetrikInfosys
β†’
34

Write a Python function to find the first non-repeating character in a string.

Python/Codingeasypython0.4 min read
AltimetrikInfosys
β†’
35

What are decorators in Python, and how do they work?

Python/Codingeasypython0.4 min read
AltimetrikInfosys
β†’
36

Explain the difference between args and kwargs in Python.

Python/Codingeasypython0.4 min read
AltimetrikInfosys
β†’
37

What is the difference between a set and a list in Python?

Python/Codingeasypython0.4 min read
AltimetrikInfosys
β†’
38

How do you handle memory management in Python?

Python/Codingeasyetlpython0.4 min read
AltimetrikInfosys
β†’
39

Write a Python function to find the maximum value in a list without using the built-in max() function.

Python/Codingeasypython0.4 min read
AltimetrikInfosys
β†’
40

Can you describe a situation where you had to work with a difficult stakeholder? How did you manage the situation and what was the outcome?

Behavioraleasy0.8 min read
PresidioSwiggy
β†’

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
Previous1234...36Next
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