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
341

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

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

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
β†’
343

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

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

Explain read and write modes in Spark.

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

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

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

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

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

Explain the Medallion architecture and its benefits in data engineering.

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

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

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

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

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

Explain the architecture of Kafka

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

Explain the architecture of Kafka and its core components.

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

Explain the architecture of Spark Streaming

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

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

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

Explain the architecture of Spark, including the roles of driver, executors, DAGs, and SparkContext.

Spark/Big Datahardjoinoptimizationpartition2.5 min read
PWC
β†’
355

Explain the benefits of auto-scaling policies in EMR.

Spark/Big Datahardoptimizationpartition0.5 min read
Capco
β†’
356

Explain the benefits of using columnar storage formats like Parquet or ORC.

Spark/Big Datahardoptimizationpartition0.5 min read
Disney+ Hotstar
β†’
357

Explain the concept of RDD, DataFrame, and Dataset in PySpark.

Spark/Big Datahardoptimizationpartitionspark0.5 min read
Citi
β†’
358

Explain the concept of consumer groups in Kafka. How do they affect message processing?

Spark/Big Datahardoptimizationpartition0.5 min read
Citi
β†’
359

Explain the concept of preemptible VMs in Dataproc and their cost implications.

Spark/Big Datahardoptimizationpartitionspark0.5 min read
Aarete
β†’
360

Explain the configuration of a Spark cluster for optimal performance

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

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