TTL Key-Value Store with Efficient Expiry Cleanup

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

Problem Overview

Snowflake phone-screen question, reconstructed from 1 candidate report (June 2025). Tests: in-memory database or key-value store; time-based state (expiry, TTL, snapshots). Candidates reported 4 follow-ups. The write-up includes a Python solution that passes 8 test cases.

  • 4 candidate-reported follow-ups — 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?