Question bank

Interview questions, with guidance on how to answer

834 questions across 64 roles. Open one to see what a strong answer includes and common slips, then drill it out loud with Ava. New to answer structure? Start with the learning hub.

834 questions.

TechnicalSeniorExecutive Assistant
How do you protect an executive's time when everyone believes their request is the most urgent?
Tests: Calendar & priority management
BehaviouralSeniorExecutive Assistant
Your executive's flight is cancelled the night before a major client presentation in another city. Walk me through what you do.
Tests: Composure under pressure
BehaviouralAny levelExecutive Assistant
How do you handle it when a senior person pressures you for information your executive asked you to keep private?
Tests: Discretion & judgement
BehaviouralAny levelExecutive Assistant
Tell me about a day when everything seemed to go wrong at once. How did you stay on top of it?
Tests: Composure under pressure
TechnicalEntry levelManagement Consultant
A regional gym chain's profits have fallen for two years. How would you start breaking down why?
Tests: Problem structuring
BehaviouralEntry levelManagement Consultant
Tell me about a time you used data to change someone's mind. What was the analysis and how did you present it?
Tests: Quantitative analysis & modelling
BehaviouralEntry levelManagement Consultant
Tell me about a time you had to get up to speed on an unfamiliar subject quickly. How did you do it?
Tests: Coachability & learning agility
TechnicalMid levelManagement Consultant
You have a week and twenty sets of interview notes from a client's staff. How do you turn them into clear insights?
Tests: Research & synthesis
TechnicalMid levelManagement Consultant
How do you structure a presentation so a busy executive gets your recommendation in the first minute?
Tests: Recommendation & storytelling
BehaviouralMid levelManagement Consultant
Tell me about a time you disagreed with a teammate on a project's direction under a tight deadline. How did you resolve it?
Tests: Teamwork & collaboration
TechnicalMid levelManagement Consultant
Walk me through how you would build a simple model to test whether a client should open a new location.
Tests: Quantitative analysis & modelling
TechnicalSeniorManagement Consultant
A client executive rejects your findings in a steering meeting because they reflect badly on their team. What do you do?
Tests: Client management & stakeholder influence
CaseSeniorManagement Consultant
Your recommendations were accepted but six months later little has changed. How would you approach the next phase?
Tests: Implementation & change management
TechnicalSeniorManagement Consultant
How do you handle a client who keeps adding work beyond the agreed scope?
Tests: Client management & stakeholder influence
TechnicalAny levelManagement Consultant
How do you decide what not to analyse when time is short?
Tests: Problem structuring
BehaviouralAny levelManagement Consultant
Tell me about a recommendation you made that turned out to be wrong. What did you learn?
Tests: Coachability & learning agility
TechnicalEntry levelData Engineer
Can you explain the difference between a fact table and a dimension table, and when you would use each?
Tests: SQL & data modelling
TechnicalEntry levelData Engineer
If you had to load a daily file from a partner into a warehouse, how would you make sure running the job twice doesn't create duplicate rows?
Tests: Pipeline design & orchestration
TechnicalEntry levelData Engineer
What checks would you put on a new data source before analysts start relying on it?
Tests: Data quality & testing
BehaviouralMid levelData Engineer
Tell me about a time a Spark or similar distributed job was slow or failing. How did you find the cause and what did you change?
Tests: Distributed processing