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
261

How would you handle unstructured data in Hive?

Spark/Big Datahardoptimizationpartition0.5 min read
Coforge
β†’
262

How would you identify and resolve a shuffle spill in Spark UI?

Spark/Big Datahardoptimizationpartitionspark0.5 min read
PWC
β†’
263

How would you manage the streaming data schema and handle schema evolution in Delta Lake?

Spark/Big Datahardoptimizationpartition0.5 min read
Meesho
β†’
264

How would you manage transitions to Glacier Instant Retrieval and Deep Archive?

Spark/Big Datahardoptimizationpartition0.6 min read
Capco
β†’
265

How would you migrate metadata from Hive Metastore to Glue?

Spark/Big Datahardoptimizationpartitionspark0.6 min read
Capco
β†’
266

If a consumer fails to process a message due to data corruption, describe how you would configure Kafka to handle retries and avoid message loss.

Spark/Big Datahardoptimizationpartition0.5 min read
Dunnhumby
β†’
267

In Spark, what is the difference between cores and executors?

Spark/Big Datahardoptimizationpartitionspark0.5 min read
Dunnhumby
β†’
268

Share your experience in working with big data technologies such as Hadoop, Spark, or AWS EMR. How have you leveraged these tools in your previous projects?

Spark/Big Datahardjoinoptimizationpartition0.6 min read
Amazon
β†’
269

Spark Architecture - Components include Driver, Executors, Cluster Manager, and Tasks

Spark/Big Datahardoptimizationpartitionspark2.5 min read
Presidio
β†’
270

Spark Tungsten & Catalyst Optimizer

Spark/Big Datahardjoinoptimizationpartition0.8 min read
Walmart
β†’
271

Steps to link a Databricks notebook to an ADF pipeline

Spark/Big Datahardspark0.6 min read
Kaseya
β†’
272

Trade-offs between batch processing (Spark) vs. real-time streams (Kafka)

Spark/Big Datahardpartitionspark0.7 min read
PayPal
β†’
273

Usage of UDFs?

Spark/Big Datahardoptimizationpythonsql0.6 min read
Citi
β†’
274

Walk through how you would debug the data ingestion process to identify slow stages.

Spark/Big Datahardpartitionspark0.6 min read
Swiggy
β†’
275

Walkthrough Spark's architecture, focusing on driver, executors, and DAGs

Spark/Big Datahardoptimizationpartitionspark2.5 min read
KPMG
β†’
276

What are Spark optimizations, and can you explain them?

Spark/Big Datahardjoinoptimizationpartition0.6 min read
Cognizant
β†’
277

What is Predicate Pushdown and AQE with Example

Spark/Big Datahardjoinoptimizationpartition0.6 min read
Nagarro
β†’
278

What role would Kafka or similar event-driven platforms play in your architecture?

Spark/Big Datahardetloptimizationpartition2.6 min read
Meesho
β†’
279

Write a PySpark script to check for missing values and duplicate rows in a DataFrame. How would you ensure data quality before saving it to a storage system?

Spark/Big Datahardpartitionspark0.9 min read
Dunnhumby
β†’
280

Write a Spark job to count word occurrences from an S3 dataset.

Spark/Big Datahardoptimizationpartitionspark0.6 min read
Daniel Wellington
β†’

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