Top 50
Company roadmap
Updated weekly · Last refresh Aug 30

Alpaca Interview Questions

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

50questions
~9htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 6 questions · ~63 min
2
SQL & Data Manipulation6 questions · ~63 min
Rank Users by Cohort ActivityHard
Practice

Rank Alpaca users within signup cohorts by Q1 activity using LEFT JOIN, aggregation, and RANK().

Window FunctionsRankingGroup ByAlpaca
More SQL & Data Manipulation questions with a free account

Sign up to see every question

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

Get my prep plan
3
Pipelines6 questions · ~63 min
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityAlpaca
More Pipelines questions with a free account
4
Metrics6 questions · ~63 min
Using Metrics to Drive DecisionsEasy

Explain how you used a KPI and supporting metrics to diagnose a product issue and make a concrete product decision.

Funnel AnalysisKPIsLeading IndicatorsAlpaca
More Metrics questions with a free account
5
Execution6 questions · ~63 min
Balancing Speed Quality and ScopeHard

Describe a time you had to choose between speed, quality, and scope, and how you aligned stakeholders around the trade-off.

Trade-offsRisk AssessmentScope ManagementAlpaca
More Execution questions with a free account
6
System Design6 questions · ~63 min
Design Feature Drift Monitoring SystemHard

Design a production ranking system with robust feature drift monitoring across batch and real-time features at high QPS.

Feature StoreFeature DriftModel ServingAlpaca
More System Design questions with a free account
7
More topics14 questions · ~146 min
Develop a New Market GTM StrategyEasy

Approach for building a go-to-market strategy for a new market or solution.

Competitive AnalysisGo-to-MarketGrowth StrategyAlpaca
Prioritize User Problems with DataMedium

Framework for using product data to identify and prioritize the user problem that should be solved first.

Feature PrioritizationUser NeedsPain PointsAlpaca
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.