Top 50
Company roadmap
Updated weekly · Last refresh Oct 18

Artefact Interview Questions

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

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. 4 questions · ~42 min
2
SQL & Data Manipulation4 questions · ~42 min
7-Day Rolling Active UsersMedium
Practice
Recently asked

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

Window FunctionsDate FunctionsRunning TotalsArtefact
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
Pipelines4 questions · ~42 min
Data Quality in ETL PipelinesEasy
Recently asked

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityArtefact
More Pipelines questions with a free account
4
A/B Testing & Experimentation3 questions · ~31 min
Common Pitfalls in Experiment ResultsHard
Recently asked

Identify the main pitfalls that can distort A/B test interpretation and explain how to guard against them.

PeekingNovelty EffectSample Ratio MismatchArtefact
More A/B Testing & Experimentation questions with a free account
5
System Design3 questions · ~31 min
Design an LLM Serving PlatformHard

Design an LLM serving system that balances latency, cost, scalability, and safety for production traffic.

Cold StartFeature StoreModel ServingArtefact
More System Design questions with a free account
6
Generative AI & LLMs3 questions · ~31 min
Evaluate an LLM SystemMedium

Explain how to evaluate a generative model using offline and online methods, with attention to hallucination, product metrics, and experiment design.

HallucinationPrompt EngineeringLLM EvaluationArtefact
More Generative AI & LLMs questions with a free account
7
More topics29 questions · ~302 min
Analyze User Engagement Drop After Feature ReleaseMedium
Recently asked

Assess the 15% drop in user engagement after a new app feature release and propose metric decomposition strategies.

Artefact
Sample Size and Power PlanningMedium
Recently asked

Reason about sample size, power, and minimum detectable effect before launching an experiment.

Hypothesis TestingPower AnalysisSample SizeArtefact
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.