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

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

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

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

Approaches to handling multiple tasks within a sprint?

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

Broadcast Joins and Shuffle Merge Joins?

Spark/Big Datamediumjoinsparksql0.5 min read
Snowflake
β†’
644

Calculating Databricks costs - explain DBU

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

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

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

Can you explain the concept of mappers in Spark, and how are they used in data transformations?

Spark/Big Datamediumpartitionspark0.5 min read
Infosys
β†’
647

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

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

Code a simple PySpark job to read a JSON file, filter records, and write output in Parquet format.

Spark/Big Datamediumpartitionpythonspark0.5 min read
American Express
β†’
649

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

Spark/Big Datahardjoinoptimizationpartition4 min read
Expedia
β†’
650

Create a DataFrame with default column types

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

Design an ETL pipeline using Kafka and Spark Streaming

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

Difference between Presto vs. Spark underlying architecture

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

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

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

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

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

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

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

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

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

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

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

Explain MapReduce Architecture.

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

Explain PySpark's Catalyst Optimizer.

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

Explain SCD1 and SCD2 in Databricks PySpark with examples.

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

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...3132333435...47Next
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