DataEngPrep.tech
QuestionsPracticeAI CoachDashboardPacksBlog
ProLogin

Interview Questions

Real questions from top companies

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

What is the command to import data from HDFS to Hive?

Spark/Big Datamediumpartition0.4 min read
Coforge
β†’
1662

What is the difference between Lazy Evaluation and Eager Execution in PySpark?

Spark/Big Datahardjoinoptimizationspark0.4 min read
Incedo
β†’
1663

What is the difference between MapReduce and Spark?

Spark/Big Datahardspark0.5 min read
Globant
β†’
1664

What is the difference between Pandas DataFrame and Spark DataFrame? When would you prefer using each?

Spark/Big Datahardetlspark0.4 min read
Dunnhumby
β†’
1665

What is the difference between external and internal tables in Hive?

Spark/Big Dataeasyspark0.4 min read
Dunnhumby
β†’
1666

What is the difference between head() and take() in PySpark?

Spark/Big Dataeasyspark0.4 min read
Globant
β†’
1667

What is the difference between managed and external tables in Hive or Spark SQL?

Spark/Big Dataeasysparksql0.3 min read
Infosys
β†’
1668

What is the difference between map and flatMap in Spark transformations?

Spark/Big Dataeasyspark0.4 min read
Coforge
β†’
1669

What is the difference between partitions and repartitions in Spark, and when do you use each?

Spark/Big Datamediumpartitionspark0.5 min read
Coforge
β†’
1670

What is the importance of the checkpoint location in Databricks?

Spark/Big Datahardjoin0.4 min read
TCS
β†’
1671

What is the most common performance bottleneck in Spark jobs, and how would you resolve it?

Spark/Big Datamediumjoinpartitionspark0.4 min read
Bristol Myers Squibb
β†’
1672

What is the purpose of the VACUUM command in Delta Lake?

Spark/Big Dataeasy0.4 min read
Puma
β†’
1673

What is the role of Zookeeper in Kafka?

Spark/Big Datamediumpartition0.4 min read
Fragma Data Systems
β†’
1674

What is the salting technique, and when would you use it?

Spark/Big Datahardjoinpartition0.4 min read
American Express
β†’
1675

What is the usage of Optimize and REORG commands in Databricks?

Spark/Big Datamediumpartitionwindow0.5 min read
PWC
β†’
1676

What limitations do you face when using Delta Tables in a multi-cloud environment?

Spark/Big Dataeasylakehouse0.4 min read
PWC
β†’
1677

What metrics do you use to determine whether a Spark job is going well or not?

Spark/Big Dataeasyspark0.5 min read
Delivery Hero
β†’
1678

What performance optimization techniques have you applied in Spark, Sqoop, or Databricks?

Spark/Big Datahardoptimizationpartitionspark0.3 min read
Capgemini
β†’
1679

What performance tuning techniques do you apply in both Sqoop and Spark to optimize their execution?

Spark/Big Datamediumjoinpartitionspark0.4 min read
Infosys
β†’
1680

What role does Kafka play in real-time data streaming pipelines?

Spark/Big Datahardpartitionspark0.4 min read
BCG
β†’

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
Previous1...8283848586...94Next
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