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 in Spark/Big Data Β· easy

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

What is the difference between Managed and External tables in Hive/Spark?

Spark/Big Dataeasyspark2 min read
CitiDunnhumbyFragma Data Systems
β†’
2

When would you architecturally choose Dataset[T] over DataFrame in a Scala Spark pipeline, and what are the scalability and portability trade-offs? Include type-safety benefits vs. operational constraints.

Spark/Big Dataeasyetlpythonspark0.6 min read
CoforgeLTIMindtree
β†’
3

What is the difference between Managed and External Tables in Databricks?

Spark/Big Dataeasysnowflakespark0.6 min read
AltimetrikIncedo
β†’
4

Approaches to handling multiple tasks within a sprint?

Spark/Big Dataeasy0.6 min read
Snowflake
β†’
5

Can you share a time when you had to shift focus due to urgent tasks?

Spark/Big Dataeasy0.5 min read
Moonfare
β†’
6

Create a DataFrame with default column types

Spark/Big Dataeasypythonsparksql0.4 min read
KPMG
β†’
7

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

How do you compare the time investment and value of a task?

Spark/Big Dataeasy0.5 min read
Delivery Hero
β†’
9

How do you handle bad data in Databricks?

Spark/Big Dataeasy0.5 min read
PWC
β†’
10

Sqoop Incremental Import?

Spark/Big Dataeasysql0.6 min read
Altimetrik
β†’
11

Sqoop command for importing multiple tables

Spark/Big Dataeasyairflowsql0.5 min read
Meesho
β†’
12

Suppose you have a DAG that ingests data from multiple databases. How would you increase task parallelism in Airflow to improve performance without overloading the system?

Spark/Big Dataeasyairflowsql0.6 min read
Dunnhumby
β†’
13

Suppose you need to import 5 tables from an external RDBMS (like MySQL) into Hadoop HDFS. Write the Sqoop command

Spark/Big Dataeasyairflowsql0.6 min read
Meesho
β†’
14

Task Dependencies in DAG

Spark/Big Dataeasyairflow0.5 min read
Verizon
β†’
15

What are the advantages of using Delta Lake over Parquet?

Spark/Big Dataeasy0.5 min read
Puma
β†’
16

What are the differences between %pip and %conda commands in Databricks?

Spark/Big Dataeasypython0.6 min read
TCS
β†’
17

What are the different modes in which you can submit Spark jobs? Explain each.

Spark/Big Dataeasyspark0.5 min read
Dunnhumby
β†’
18

What are the performance considerations when using Auto Loader?

Spark/Big Dataeasy0.5 min read
TCS
β†’
19

What are transient clusters in EMR, and when would you use them?

Spark/Big Dataeasyetl0.5 min read
Persistent Systems
β†’
20

Write PySpark code to filter and count records.

Spark/Big Dataeasypythonsparksql0.3 min read
Bitwise
β†’

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
12Next
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