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.

572 questions match your filters.

TechnicalEntry levelExecutive Assistant
The office printer is broken, supplies are low and a visitor has just arrived. What do you handle first?
Tests: Office operations
TechnicalMid levelExecutive Assistant
Walk me through how you would plan a three-day offsite for twenty people with a month's notice.
Tests: Travel & event coordination
TechnicalMid levelExecutive Assistant
How do you draft emails on your executive's behalf so they sound like them and need few edits?
Tests: Written correspondence
TechnicalMid levelExecutive Assistant
Which tools do you rely on to stay organised, and how have you used AI assistants or automation to save time?
Tests: Productivity tools
TechnicalSeniorExecutive Assistant
How would you help an executive run their leadership meetings so decisions and follow-ups actually happen?
Tests: Meeting & project support
TechnicalSeniorExecutive Assistant
How do you protect an executive's time when everyone believes their request is the most urgent?
Tests: Calendar & priority management
TechnicalEntry levelManagement Consultant
A regional gym chain's profits have fallen for two years. How would you start breaking down why?
Tests: Problem structuring
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
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
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
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
TechnicalMid levelData Engineer
How do you structure dependencies and retries in an orchestration tool like Airflow or Dagster so that one failure doesn't cascade into a mess?
Tests: Pipeline design & orchestration
TechnicalMid levelData Engineer
Walk me through how you would choose between a cloud warehouse like Snowflake or BigQuery and a lakehouse setup for a new analytics platform.
Tests: Cloud data platforms
TechnicalSeniorData Engineer
Imagine our warehouse bill doubled in six months. How would you investigate and bring it down without breaking what people depend on?
Tests: Performance & cost optimisation
TechnicalSeniorData Engineer
How do you approach designing a data model that several teams will share, when each team defines a key metric like active customer differently?
Tests: SQL & data modelling