Top 17
Company roadmap
Updated weekly · Last refresh Oct 17

TTT Interview Questions

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

17questions
~3htotal time
Track your progressSign up free to work through all 17 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 1 drill · ~63 min
Second Highest Without AggregatesHard
Practice

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

SubqueriesRankingSelf-JoinsTTT
Window Functions for RankingHard
Practice

Rank Whova attendees by total engagement and calculate each user's chronological running engagement total.

Window FunctionsRankingRunning TotalsTTT
SQL Join Types With ExamplesEasy

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

null handlingJoinsmany-to-oneTTT
SQL Window Functions for Campaign RankingMedium
Practice
Practice drill

Rank campaigns by advertiser performance and calculate campaign-level running conversions over time with PostgreSQL window functions.

Window FunctionsJoinsData ManipulationStackadaptLiveRampAmazon Advertising
More SQL & Data Manipulation questions with a free account
2
Coding4 questions · ~43 min
Python String UtilitiesEasy
Practice

Implement a string reversal or palindrome check using direct character processing.

Basic AlgorithmsStringsloopsTTT
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
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 & Leadership7 questions · ~75 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
4
More topics1 question · ~11 min
Exception Handling Best PracticesEasy

Tests your ability to write robust Python code with clear error handling and maintainable structure.

basicsTestingpythonTTT
The finish line: interview-readyComplete all 17 questions plus 1 hands-on drill to finish this plan.