In-Memory Database for Thermostat Device with Range Queries

CodingSnowflakeLast reported January 2025Low Frequency

Reported: 1× across candidate reports
First seen: January 2025
Last reported: January 2025
Reported outcome: pass

Problem Overview

Snowflake coding question, reconstructed from 1 candidate report (January 2025). Tests: in-memory database or key-value store; binary search. Candidates reported 6 follow-ups. The write-up includes a Python solution that passes 5 test cases.

6 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.