Dataford
Top 42
Company roadmap
Updated weekly · Last refresh Aug 30

Optimal Interview Questions

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

42questions
~6htotal time
Track your progressSign up free to work through all 42 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 6 questions · ~48 min
Calculate CAC From Campaign InputsMedium

Calculate customer acquisition cost from campaign budget, impression cost, and conversion rate.

CACConversion Ratecampaign performanceOptimal
SEO vs Paid Search MetricsMedium

Tests your ability to define success criteria aligned to channel intent and time horizons.

campaign performanceOptimal
Attribution Window SelectionHard

Tests your ability to choose attribution windows that reflect customer journeys and improve decisioning.

attributionOptimal
CTR Up, CVR Down DiagnosisMedium

Tests your diagnostic reasoning to connect funnel changes to campaign and audience factors.

DiagnosisOptimal
More Metrics questions with a free account
2
Behavioral & Leadership33 questions · ~264 min
Prioritizing Conflicting High-Stakes WorkEasy

Tests prioritization under pressure, stakeholder management, and ownership when multiple urgent requests compete for limited time.

Stakeholder ManagementOwnershipDealing With AmbiguityOptimal
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~24 min
A/B Test Statistical SignificanceMedium

Tests your experimental design and analysis skills for confident marketing decisions.

experiment designStatistical SignificanceOptimal
Handling Nulls in Power BIMedium

Tests your data quality practices for reliable dashboards in Optimal client reporting.

null handlingpower bidata validationOptimal
Joining Ads and CRM DataMedium

Tests your ability to model and join marketing datasets for accurate performance measurement.

data integrationcrmJoinsOptimal

Sign up to see every question

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

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Pivot Lucid Campaign Performance by MonthMedium
Practice
Practice drill

Use joins, a CTE, CASE expressions, and monthly pivoting to compare Lucid campaign performance across channels.

pivot tablesnull handlingData WranglingLucid Motors
Analyzing Operations Bottlenecks with SQLHard
Practice
Practice drill

Use multi-level CTEs, joins, and LAG to identify Samsung regional inventory shortages and late deliveries.

JoinsperformanceAggregationsSamsung ElectronicsApeel Sciences
Identify Funnel Bottlenecks in OnboardingHard
Practice
Practice drill

Use joins, CTEs, and aggregations to find the weakest step in an onboarding funnel and estimate lost conversions.

Funnel AnalysissqlDiagnosisAtlassianRevolut
The finish line: interview-readyComplete all 42 questions plus 3 hands-on drills to finish this plan.