← All questions
HardCodingData
The public task uses local dbt/DuckDB subscription models and a capped retained-revenue cohort report. Follow the source for its complete task and rules; we do not reproduce its datasets or submission instructions.
Asked at
Tracksuit
Tracksuit1Give yourself 5 minutes
2Answer out loud, not in your head
3Then compare with the answer below
0
Reference answer
Then expect these follow-ups
How do late refunds restate a cohort?
Which uniqueness and relationship tests protect the model?
Free to read · better with Enzo
Practice this out loud with Enzo
Enzo runs it as a mock interview, pushes back with follow-ups, and grades you on the rubric.
Next question
- The employer publishes a reproducible data-ingestion and analysis exercise using public city datasets, with an emphasis on code, documentation and results. Consult the opened source for current scope rather than stale search snippets.
- Teleport publishes a Go service exercise that reads and changes Kubernetes Deployment replica counts, with design, delivery and testing requirements. This is a public sample, not evidence that our exact prompt was asked in a past interview.