DataEngPrep.tech
QuestionsPracticeAI CoachDashboardPacksBlog
ProLogin

Interview Questions

Real questions from top companies

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

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

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

Explain the benefits of auto-scaling policies in EMR.

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

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

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

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

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

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

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

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

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

Explain the configuration of a Spark cluster for optimal performance

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

Explain the difference between TriggerDagRunOperator and ExternalTaskSensor in Airflow.

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

Explain the difference between coalescing and repartitioning in Spark

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

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

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

Explain the impact of Vacuum and Analyze operations on performance.

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

Explain the role of DAGs (Directed Acyclic Graphs) in Spark.

Spark/Big Datahardoptimizationpartitionspark0.5 min read
Freecharge
β†’
1453

Explain your approach to monitoring and logging Spark jobs in AWS. What tools would you use to identify performance bottlenecks?

Spark/Big Dataeasyspark0.6 min read
EPAM
β†’
1454

Explain your choice of streaming framework (Kafka, Spark Streaming, etc.).

Spark/Big Datahardoptimizationpartitionspark0.5 min read
Fragma Data Systems
β†’
1455

Fault Tolerance in Spark vs. Hadoop?

Spark/Big Datahardoptimizationpartitionspark0.5 min read
Capco
β†’
1456

Given a DataFrame with columns id and name, add a new column department: If id < 100 assign HR, if id >= 100 and id < 200 assign admin.

Spark/Big Datahardoptimizationpartitionspark0.4 min read
Dunnhumby
β†’
1457

Given two DataFrames, perform specified data transformations and store the result in a new DataFrame

Spark/Big Datahardjoinoptimizationpartition0.4 min read
PayPal
β†’
1458

GroupByKey vs ReduceByKey – Differences and performance implications?

Spark/Big Datahardoptimizationpartition0.4 min read
Datametica
β†’
1459

Handling Skewness in Data - salting, broadcast join

Spark/Big Datahardjoinoptimizationpartition0.4 min read
Meesho
β†’
1460

Handling custom data types in Spark

Spark/Big Datahardoptimizationpartitionspark0.4 min read
JP Morgan
β†’

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...7172737475...94Next
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