Sliding Window: Users with 3+ Accesses within 60 Minutes

Phone ScreenSnowflakeLast reported May 2025Low Frequency
Reported
1× across candidate reports
First seen
May 2025
Last reported
May 2025
Reported outcome
unknown

Problem Overview

Given a list of LogEntry objects, each containing a UserId and a Time, find and return all users who have accessed the system 3 or more times within any…

  • 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?