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
201

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

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

Explain caching techniques in Databricks.

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

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

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

Explain database drivers/connectors and their use cases.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Explain how to schedule an automated task using Apache Airflow.

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

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

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

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

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

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

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

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

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

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

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

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

Explain the Medallion architecture and its benefits in data engineering.

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

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