Event Timestamp Tracking with Time-Range Counting

Phone ScreenSnowflakeLast reported August 2026Low Frequency
Reported
2× across candidate reports
First seen
April 2026
Last reported
August 2026
Reported outcome
unknown

Problem Overview

Design a system to process a stream of events. In the base version, implement two functions: (1) Receive(event_type, timestamp) — ingests an event of a given type at a given timestamp; timestamps are guaranteed to be non-decreasing. (2) Count(event_type, start_time, end_time) — returns the count of events of the given…

  • 3 candidate-reported follow-ups — the exact probes interviewers asked, with the trigger for each
  • The rest of the problem statement — full requirements, constraints, and edge cases
  • Approach and trade-offs — what passing candidates did, and the mistakes that sink people
Unlock the full Snowflake catalog
Full problem statements, candidate-reported follow-ups, and walkthroughs — for every Snowflake question.
Unlock with Pro
Already a member? Sign in
Verified Source
Every question is reconstructed from multiple independent candidate reports. Verbatim follow-ups, not invented ones.
Codex Fact-Checked
Technical claims, formulas, and scale numbers are reviewed against primary sources.
Interviewer Follow-ups
The exact follow-ups reported by candidates, with the trigger that prompts each one — plus the mistakes that sink people.
Is this helpful?