Twitch Interview Questions
Practice the exact questions companies are asking right now.
Analyze Streaming Data with SQL for Monthly Trends
minute_streamed +---------------------+------------------+------------+--------------------+ | time_minute | streamer_username| category | c...
Solve four design-leaning coding problems
You are given four independent interview-style coding tasks. For each task, implement the requested function/class with clear inputs/outputs and reaso...
Design real-time live-stream recommendations
Design a Real-Time Recommendation System for Live Streams Context: You are designing a recommender for a large live-streaming platform. Assume you hav...
Explain motivation and behavioral principles
Behavioral & Leadership — Data Scientist Technical Screen Instructions Provide specific, first-person examples with quantifiable outcomes and the conc...
Design an A/B test for pre-roll ads
A/B Test: Reduce Mobile Live‑Stream Pre‑Roll Ad Frequency by 20% Context: You are designing an experiment on mobile live streams to evaluate reducing ...
Write robust SQL for streaming analytics
Write efficient PostgreSQL SQL for the following streaming analytics tasks. Use the invented schema and sample data below. Handle duplicates, out-of-o...
Solve advanced SQL for streaming analytics
You are given minute-level streaming telemetry. Each row in minute_streamed represents one minute during which a streamer was live; each row in minute...