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
unknown

Problem Overview

Design a backend in-memory database to store temperature readings from a thermostat device. Each reading is a pair of [timestamp (format: YYYY-MM-DD HH:MM:SS), temperature (float, e.g. 24.6)]. The database must support two query types efficiently: 1. Point query: return the temperature at an exact timestamp t1. 2. Range query: return…

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