Essential cookies keep authentication working. With your permission, we also use analytics cookies to understand and improve the product. Read our Privacy Policy

DataEngPrep.tech
QuestionsPracticeAI CoachDashboardPricingBlog
ProLogin

Interview Questions

Real questions from top companies Β· hard

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

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

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

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

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

Explain the architecture of Kafka

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

Explain the architecture of Kafka and its core components.

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

Explain the architecture of Spark Streaming

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

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

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

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

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

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

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

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

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

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

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

Explain the configuration of a Spark cluster for optimal performance

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

Explain the difference between TriggerDagRunOperator and ExternalTaskSensor in Airflow.

Spark/Big Datahardairflowoptimizationpartition0.5 min read
Citi
β†’
233

Explain the differences between Spark's shuffle and broadcast join. When would you use each?

Spark/Big Datahardjoinoptimizationpartition0.5 min read
HashedIn
β†’
234

How did you handle data ingestion and processing for large datasets?

Spark/Big Datahardpartitionspark0.5 min read
American Express
β†’
235

How do you resolve merge conflicts in Databricks notebooks?

Spark/Big Datahardoptimizationpartition0.8 min read
PWC
β†’
236

How do you set up CI/CD for a PySpark ETL workflow?

Spark/Big Datahardetloptimizationpartition0.7 min read
Microsoft
β†’
237

How do you store streaming data in Delta Lake and handle schema evolution?

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

How do you use Spark UI to debug stages, tasks, and performance issues?

Spark/Big Datahardoptimizationpartitionspark0.6 min read
PWC
β†’
239

How does Adaptive Query Execution (AQE) work?

Spark/Big Datahardjoinoptimizationpartition0.6 min read
Globant
β†’
240

How does Auto Loader avoid reloading files with the same name?

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

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...1011121314...22Next
Categories
All QuestionsSQLSpark / Big DataPython / CodingSystem DesignCloud / ToolsBehavioral
By Company
AmazonGoogleDatabricksSnowflakeAWSAzureMicrosoftNetflixUberTCS
Interview Guides
All GuidesTop SQL QuestionsTop Spark QuestionsPySpark QuestionsTop Python QuestionsTop System DesignKafka QuestionsAirflow QuestionsSQL Window FunctionsETL QuestionsData Modeling
Products
AI Interview CoachAnswer AnalyzerSQL PlaygroundResume AnalyzerAnswer Vault PDFsPricing
Company
About & Editorial PolicyContact UsAI DisclosureDisclaimerTerms of ServicePrivacy Policy
Β© 2026 DataEngPrep.tech. All rights reserved.
AboutBlogContactDisclaimer