Dataford
Top 18
Prep plan
Updated weekly · Last refresh Aug 30

Affine Consultant Interview Questions

The questions to prepare for a Affine Consultant interview. Questions from real interview reports rank first. Updated weekly.

18questions
~3htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 2 drills · ~46 min
Second Highest Trader SalaryEasy
Practice

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingAffine
Design a Retail Star SchemaHard

Tests your ability to model dimensional data for analytics use cases in a consulting context.

fact tablesstar schemadimensionsAffine
SQL Window FunctionsMedium

Evaluates your ability to use advanced SQL features for analytics and data transformations.

Window FunctionssqlAffine
7-Day Rolling Active UsersMedium
Practice
Practice drill

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsMetaSpotifyMeta IT
Rank Candidates by Technical DomainEasy
Practice
Practice drill

Use a CTE, joins, and window functions to rank candidates by assessment score within each technical domain.

Window FunctionsRankingsqlMicro1
2
Behavioral & Leadership10 questions · ~87 min
More Behavioral & Leadership questions with a free account
3
More topics5 questions · ~43 min
Investigate Profit DropHard

Tests structured problem solving and analytical thinking to diagnose business performance issues.

Business AcumenprofitabilityDiagnosisAffine
Optimize Slow Power BI DashboardsHard

Tests performance tuning skills for Power BI and large-scale data modeling.

Performance Tuningpower biData ModelingAffine
R, Statistics, and SQLMedium

Tests your practical foundations in statistical analysis and querying for consulting work.

statisticssqlAffine
Estimate EV Charging MarketHard

Tests market sizing frameworks and quantitative reasoning for business strategy work.

EstimationBusiness AcumenMarket SizingAffine
Handle Messy Historical DataMedium

Tests data quality triage, pragmatic delivery, and stakeholder-focused analytics execution.

deliveryData QualityProblem SolvingAffine

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 18 questions plus 2 hands-on drills to finish this plan.