Dataford
Top 16
Company roadmap
Updated weekly · Last refresh Aug 30

TTT Interview Questions

The questions to prepare for TTT interviews, across all roles. Questions from real interview reports rank first. Updated weekly.

16questions
~2htotal time
Track your progressSign up free to work through all 16 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 2 drills · ~56 min
Second Highest Without AggregatesHard
Practice

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsTTT
SQL Join Types With ExamplesEasy

Tests SQL join understanding and ability to reason about result sets.

null handlingJoinsmany-to-oneTTT
Normalized E-Commerce SchemaMedium

Tests your database design skills, normalization choices, and ability to model typical e-commerce entities.

schema designnormalizationData ModelingTTT
Optimize Complex SQL QueryHard

Tests your SQL performance troubleshooting approach, including query plans, indexing, and rewrite strategies.

Performance TuningJoinsAggregationsTTT
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
Rank Quora Acquisition ChannelsMedium
Practice
Practice drill

Use joins, a CTE, and aggregation to rank Quora acquisition channels by activated-user conversion rate.

JoinsRankingAggregationsHelloFreshArgo DataQuora
2
Coding4 questions · ~36 min
Python Memory Management ExplainedEasy

Explain how Python manages memory using reference counting, garbage collection, and object allocation.

Hash TablesArraysStringsTTT
Parse Logs for Error PatternsMedium

Tests Python scripting ability for log parsing and pattern extraction.

log parsingStringspythonTTT
Lists vs Tuples in PythonEasy

Tests your understanding of Python data structures and appropriate selection for maintainability and performance.

basicspythonoopTTT
More Coding 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
Behavioral & Leadership8 questions · ~72 min
Resolving a Difficult StakeholderMedium

Tests how you handle a difficult stakeholder through direct communication, influence, and ownership while preserving the relationship.

Conflict ResolutionStakeholder ManagementCommunicationTTT
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 16 questions plus 2 hands-on drills to finish this plan.