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.

TechnicalSeniorAutomation Engineer
How do you design automations so that a change in a vendor's website or system doesn't silently break things for weeks?
Tests: Error handling & resilience
TechnicalAny levelAutomation Engineer
How do you deal with an API that has rate limits and occasionally times out?
Tests: APIs & system integration
TechnicalAny levelAutomation Engineer
How are you using AI features, like document understanding or language models, in your automations today?
Tests: RPA & workflow tool development
TechnicalEntry levelBusiness Intelligence Developer
What is a star schema, and why do BI tools tend to work well with it?
Tests: Data modelling for analytics
TechnicalEntry levelBusiness Intelligence Developer
How would you write a query to find each customer's most recent order?
Tests: SQL development
TechnicalMid levelBusiness Intelligence Developer
Tell me about a report you built in Power BI, Tableau or a similar tool that you're proud of. What made it work for its users?
Tests: BI tool development
TechnicalMid levelBusiness Intelligence Developer
Two dashboards show different revenue numbers for the same month. How do you track down why and fix it for good?
Tests: Semantic layer & metric definitions
TechnicalMid levelBusiness Intelligence Developer
A dashboard takes forty seconds to load. Walk me through how you'd speed it up.
Tests: Report performance optimisation
TechnicalMid levelBusiness Intelligence Developer
How would you set up a report so that regional managers only see data for their own region?
Tests: Data governance & security
TechnicalSeniorBusiness Intelligence Developer
How do you handle a salesperson moving to a new territory so that historical reports still show their past sales correctly?
Tests: Data modelling for analytics
TechnicalSeniorBusiness Intelligence Developer
How would you bring order to a BI environment where hundreds of reports have grown up with no standards?
Tests: Semantic layer & metric definitions
TechnicalEntry levelIT Support Specialist
A user says their computer is really slow. What steps would you go through to find out what's going on?
Tests: Troubleshooting methodology
TechnicalEntry levelIT Support Specialist
Someone can't get on the internet, but the coworker sitting next to them can. What would you check?
Tests: Networking basics
TechnicalEntry levelIT Support Specialist
A user calls saying they're locked out and asks you to reset their password. How do you make sure it's really them?
Tests: Identity & account management
TechnicalMid levelIT Support Specialist
How would you set up a new laptop for an employee starting next week so it's ready on their first day?
Tests: Operating systems & devices
TechnicalMid levelIT Support Specialist
What makes a good ticket note, and why does it matter to the next person who picks it up?
Tests: Ticketing & documentation
TechnicalMid levelIT Support Specialist
A user forwards you an email asking them to confirm their login details, and they've already clicked the link. What do you do?
Tests: Security awareness
TechnicalSeniorIT Support Specialist
Several users across the office report that a shared application keeps disconnecting. How would you lead the investigation and keep people informed?
Tests: Troubleshooting methodology
TechnicalSeniorIT Support Specialist
If you noticed the same issue coming up in dozens of tickets every week, what would you do about it?
Tests: Ticketing & documentation
TechnicalAny levelIT Support Specialist
What tools do you use to support people remotely, and how do you make sure the user is comfortable with you connecting to their machine?
Tests: Operating systems & devices