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
181

You need to design a Kafka topic for a logging service. How would you decide the number of partitions and the key for partitioning to balance throughput and ordering requirements?

SQLhardjoinoptimizationpartition3.6 min read
Dunnhumby
β†’
182

Alternatives to the Medallion Architecture

Spark/Big Datahardjoinoptimizationpartition3.6 min read
KPMG
β†’
183

Apache Spark Architecture - RDD, DAG, cluster manager, driver node, worker node

Spark/Big Datahardjoinoptimizationpartition3.6 min read
Zen Data Shastra
β†’
184

Calculating Databricks costs - explain DBU

Spark/Big Datahardetloptimizationsql0.6 min read
JP Morgan
β†’
185

Can Presto work with Near Real-Time Data (Streaming Data Source)?

Spark/Big Datahardlakehousespark0.5 min read
Walmart
β†’
186

Conceptualize and design a real-time streaming data pipeline end-to-end.

Spark/Big Datahardjoinoptimizationpartition4 min read
Expedia
β†’
187

Design an ETL pipeline using Kafka and Spark Streaming

Spark/Big Datahardetloptimizationpartition3.7 min read
Meesho
β†’
188

Difference between Presto vs. Spark underlying architecture

Spark/Big Datahardetloptimizationpartition3.5 min read
Walmart
β†’
189

Explain Azure Databricks architecture and its integration with other Azure services.

Spark/Big Datahardoptimizationpartition3.6 min read
Fractal
β†’
190

Explain Delta Live Tables and their features, such as declarative pipeline definition and automatic data validation.

Spark/Big Datahardoptimizationpartitionpython0.7 min read
TCS
β†’
191

Explain Delta Table features – Z-ordering and Time Travel.

Spark/Big Datahardoptimizationpartition0.8 min read
Datametica
β†’
192

Explain Delta Time Travel and the purpose of the vacuum command.

Spark/Big Datahardoptimizationpartitionspark0.7 min read
PWC
β†’
193

Explain Hive, its purpose, and its default metadata storage.

Spark/Big Datahardetloptimizationpartition0.7 min read
Chryselys
β†’
194

Explain MapReduce Architecture.

Spark/Big Datahardoptimizationpartitionspark3.5 min read
HCL
β†’
195

Explain PySpark's Catalyst Optimizer.

Spark/Big Datahardjoinoptimizationpartition0.6 min read
Incedo
β†’
196

Explain SCD1 and SCD2 in Databricks PySpark with examples.

Spark/Big Datahardjoinoptimizationpartition0.6 min read
Hexaware
β†’
197

Explain Spark Architecture – Driver, Executors, and Tasks.

Spark/Big Datahardoptimizationpartitionspark3.6 min read
Datametica
β†’
198

Explain Spark transformations (lazy evaluation, wide vs narrow).

Spark/Big Datahardjoinoptimizationpartition0.6 min read
Apple
β†’
199

Explain Spark's execution process – Job/Stage/Task creation.

Spark/Big Datahardjoinoptimizationpartition0.6 min read
Datametica
β†’
200

Explain Spark's narrow vs. wide transformations and when to use each

Spark/Big Datahardjoinoptimizationpartition0.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...89101112...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