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

Snowflake phone-screen question, reconstructed from 2 candidate reports (April 2026 to August 2026). Tests: rate limiting and time-window counts; time-based state (expiry, TTL, snapshots). Candidates reported 1 follow-up. The write-up includes a Python solution that passes 11 test cases.

  • 1 candidate-reported follow-up — the probes candidates report being asked, with the trigger for each
  • The full 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. Follow-ups candidates reported, not invented ones.
Codex Fact-Checked
Technical claims, formulas, and scale numbers are reviewed against primary sources.
Interviewer Follow-ups
The follow-ups candidates reported, with the trigger that prompts each one — plus the mistakes that sink people.
Is this helpful?