Home › Interview Questions › Roles › Data
📊 Role interview intel
📊

Data

4,011 real questions asked by candidates interviewing for Data — captured live by Assisting AI. Updated weekly.

📅 Last seen: Aug 2026 🗓️ First seen: May 2026 📈 Total asks: 4,011
4,011 Questions asked
May 2026 First seen
Aug 2026 Last seen
4011 Unique questions

🥧 Difficulty mix

How hard are these questions?

4011 QUESTIONS
Easy 561 (14%)Medium 2900 (72%)Hard 550 (14%)

📊 Question type

Breakdown by interview phase

Conceptual 2807 Debugging 438 System Design 435 Coding 114 Other 111 Behavioral 106

🔥 12-week activity

When candidates are asked these

W24468 questions in 2026-24468W25444 questions in 2026-25444W26393 questions in 2026-26393W27116 questions in 2026-27116W28W29W304 questions in 2026-304W31W32W33W344 questions in 2026-344W35

Last 12 weeks →

🏷️ Top topics

Where these questions cluster

Data Engineering 1692
Databases Sql 1063
Streaming 416
Big Data Spark 416
Data Science 416
Sql 5
Security 3
Access Control 3

👤 Experience level mix

What seniority these are asked at

Fresher (0-1yr) 561Junior (1-3yr) 3Mid (3-6yr) 2897Senior (6+yr) 550

📝 Recent questions

Latest 10 asked by candidates

🟡 Medium ✅

Do you know what Delta Lake is and what it does?

Delta Lake Databricks Data Lake
Conceptual · Asked 1× · Aug 2026
🟡 Medium ✅

You should not allow your MCP to run arbitrary code because it can be dangerous. How would you restrict the MCP to only allow certain operations, such as predefined safe SQL statements?

Security Sql Injection Access Control
Conceptual · Asked 1× · Aug 2026
🟡 Medium ✅

How would you restrict the MCP to only allow predefined safe SQL operations?

Security Sql Access Control
Conceptual · Asked 1× · Aug 2026
🟡 Medium ✅

Would you allow your MCP to execute arbitrary SQL against a connected SQL database?

Security Sql Access Control
Conceptual · Asked 1× · Aug 2026
🟡 Medium ✅

How would you write a SQL query to find the first and last purchase dates for each customer-product pair, ensuring that each pair has at least two completed orders?

Sql Cte Window Functions
Coding · Asked 1× · Jul 2026
🟡 Medium ✅

Write a SQL query that returns the first and last purchase dates for each customer-product pair, only including pairs with at least two completed orders.

Sql Cte Aggregation
Coding · Asked 1× · Jul 2026
🟡 Medium ✅

Describe how you would use a CTE and window functions to rank purchases by date and then filter for the first and last occurrences for each customer-product pair.

Sql Cte Window Functions
Coding · Asked 1× · Jul 2026
🟡 Medium ✅

In a real project, tell me about a time you had to troubleshoot an EMR issue that affected performance. What specific steps did you take to isolate the root cause?

Emr Spark Root Cause Analysis
Behavioral · Asked 1× · Jul 2026
🟡 Medium ✅

When would you choose Parquet in a real project?

Data Engineering
Conceptual · Asked 1× · Jun 2026
🟡 Medium ✅

What are common mistakes engineers make when using ORC?

Data Engineering
Conceptual · Asked 1× · Jun 2026

🎤 Want these answered in real-time during your interview?

Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.

Get Assisting AI — Starts at ₹500