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
1421

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

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

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

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

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

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

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

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

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

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

Explain how to schedule an automated task using Apache Airflow.

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

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

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

Explain how you would implement real-time analytics using a streaming platform like Kafka or Kinesis.

Spark/Big Datahardoptimizationpartitionspark0.6 min read
Adidas
β†’
1429

Explain how you would use Kafka Connect to ingest data from a relational database into Kafka while ensuring minimal latency and exactly-once semantics.

Spark/Big Datahardoptimizationpartitionsql0.5 min read
Dunnhumby
β†’
1430

Explain job execution in Spark: stages, tasks, Catalyst Optimizer

Spark/Big Datahardjoinoptimizationpartition0.5 min read
KPMG
β†’
1431

Explain read and write modes in Spark.

Spark/Big Datahardoptimizationpartitionspark0.5 min read
Globant
β†’
1432

Explain repartition vs. coalesce. Which one would you use to reduce shuffle operations?

Spark/Big Datahardoptimizationpartition0.5 min read
American Express
β†’
1433

Explain the DAG in Spark and how it plays a role in execution.

Spark/Big Datahardoptimizationpartitionspark0.5 min read
Coforge
β†’
1434

Explain the Medallion architecture and its benefits in data engineering.

Spark/Big Datahardoptimizationpartition3.4 min read
Puma
β†’
1435

Explain the architecture and role of the Hive Metastore in a data pipeline

Spark/Big Datahardoptimizationpartitionspark3.3 min read
Meesho
β†’
1436

Explain the architecture of Databricks, including the control plane and data plane.

Spark/Big Datahardoptimizationpartition3.3 min read
TCS
β†’
1437

Explain the architecture of Kafka

Spark/Big Datahardoptimizationpartition2.7 min read
Meesho
β†’
1438

Explain the architecture of Kafka and its core components.

Spark/Big Datahardoptimizationpartition2.6 min read
Fragma Data Systems
β†’
1439

Explain the architecture of Spark Streaming

Spark/Big Datahardoptimizationpartitionspark2.6 min read
Meesho
β†’
1440

Explain the architecture of Spark, including its components such as driver, executor, and cluster manager.

Spark/Big Datahardoptimizationpartitionspark2.6 min read
Capgemini
β†’

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...7071727374...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