Dataford
Top 30
Prep plan
Updated weekly · Last refresh Aug 30

Persistent Data Engineer Interview Questions

The questions to prepare for a Persistent Data Engineer interview. Questions from real interview reports rank first. Updated weekly.

30questions
~4htotal time
Track your progressSign up free to work through all 30 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 9 questions · ~74 min
CI/CD for Data Engineering with Git and Azure DevOpsMedium
Recently asked

Tests your DevOps practices for automated testing, deployment, and release management in data engineering.

CI/CDgitDevOpsPersistent
Orchestrating Pipelines with ADF/AirflowMedium
Recently asked

Tests your pipeline orchestration design, dependency handling, and operational thinking.

OrchestrationDependenciesairflowPersistent
Unity Catalog Access ControlMedium
Recently asked

Tests your knowledge of enterprise data governance and secure access patterns in Databricks.

SecuritydatabricksPersistent
More Pipelines questions with a free account
2
SQL & Data Manipulation6 questions + 3 drills · ~79 min
Star vs Snowflake SchemasMedium
Recently asked

Tests your dimensional modeling choices and ability to justify tradeoffs for analytics workloads.

snowflake schemastar schemaData ModelingPersistent
Referential Integrity During Bulk DeletesHard
Recently asked

Tests your ability to plan safe large-scale data maintenance while preserving constraints and correctness.

transactionsdata integrityPersistent
Running Average With Window FunctionsEasy
Practice
Practice drill

Calculate each Hinge user's 30-day rolling average of daily interactions using CTEs and window functions.

Window FunctionsData AnalysissqlHingePersistent
Second Highest Trader SalaryEasy
Practice
Recently asked
Practice drill

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingeClinicalWorksInformaticaSpectraforce Technologies
Second-Highest Salary Without LIMITEasy
Practice
Practice drill

Use nested aggregation subqueries to find the second-highest distinct salary without LIMIT.

Subqueriessql queryPersistentPersistent Systems
More SQL & Data Manipulation questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Coding5 questions · ~41 min
Spark Client-Side vs Broadcast JoinsMedium
Recently asked

Tests your understanding of Spark join strategies and how to choose them for efficiency.

JoinssparkPersistent
Nested JSON to DataFrameMedium
Recently asked

Tests your practical Python data parsing skills and DataFrame loading workflow.

json parsingData StructurespythonPersistent
PySpark Skew and OOM FixesHard
Recently asked

Tests your performance engineering skills for distributed Spark workloads and memory-safe transformations.

sparkperformance analysisPersistent
More Coding questions with a free account
4
Behavioral & Leadership10 questions · ~82 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 30 questions plus 3 hands-on drills to finish this plan.