DataEngPrep.tech
QuestionsPracticeAI CoachDashboardPacksBlog
ProLogin

Interview Questions

Real questions from top companies Β· hard

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

Explain Spark Architecture – Driver, Executors, and Tasks.

Spark/Big Datahardoptimizationpartitionspark3.6 min read
Datametica
β†’
322

Explain Spark transformations (lazy evaluation, wide vs narrow).

Spark/Big Datahardjoinoptimizationpartition0.6 min read
Apple
β†’
323

Explain Spark's execution process – Job/Stage/Task creation.

Spark/Big Datahardjoinoptimizationpartition0.6 min read
Datametica
β†’
324

Explain Spark's narrow vs. wide transformations and when to use each

Spark/Big Datahardjoinoptimizationpartition0.5 min read
Morgan Stanley
β†’
325

Explain a scenario-based question on Spark optimization and how you would troubleshoot performance issues.

Spark/Big Datahardjoinoptimizationpartition0.6 min read
American Express
β†’
326

Explain aggregation functions in PySpark with examples and use cases.

Spark/Big Datahardoptimizationpartitionspark0.5 min read
Hexaware
β†’
327

Explain caching techniques in Databricks.

Spark/Big Datahardoptimizationpartition0.6 min read
Incedo
β†’
328

Explain data encryption in Databricks, both at rest and in transit.

Spark/Big Datahardoptimizationpartition0.6 min read
TCS
β†’
329

Explain database drivers/connectors and their use cases.

Spark/Big Datahardoptimizationpartitionpython0.6 min read
Gartner
β†’
330

Explain how Glue's Spark-based architecture handles data parallelism.

Spark/Big Datahardetloptimizationpartition3.5 min read
Capco
β†’
331

Explain how HDFS (Hadoop Distributed File System) stores data across nodes.

Spark/Big Datahardoptimizationpartition0.6 min read
BCG
β†’
332

Explain how I handle performance optimizations, scheduling tasks, and monitoring DAGs in Airflow.

Spark/Big Datahardairflowoptimization0.6 min read
S&P Global
β†’
333

Explain how Kafka handles real-time data streaming and guarantees message delivery.

Spark/Big Datahardoptimizationpartition0.5 min read
Swiggy
β†’
334

Explain how Spark groups transformations into stages. What causes a stage boundary?

Spark/Big Datahardjoinoptimizationpartition0.6 min read
Microsoft
β†’
335

Explain how Spark handles data partitioning and the role of shuffles in performance tuning.

Spark/Big Datahardjoinoptimizationpartition0.6 min read
Uber
β†’
336

Explain how Spark processes a 500GB file, covering memory allocation, shuffles, and spillovers to disk.

Spark/Big Datahardoptimizationpartitionspark0.6 min read
Carelon
β†’
337

Explain how spark.read.format("delta").load() works

Spark/Big Datahardoptimizationpartitionspark0.5 min read
Meesho
β†’
338

Explain how to overwrite a file stored in S3 using PySpark.

Spark/Big Datahardoptimizationpartitionspark0.4 min read
Carelon
β†’
339

Explain how to schedule an automated task using Apache Airflow.

Spark/Big Datahardairflowoptimizationpartition0.6 min read
BCG
β†’
340

Explain how you would design a partition strategy for a large dataset in HDFS.

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

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...1516171819...34Next
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