Lifesight Interview Questions
The questions to prepare for Lifesight interviews, across all roles. Questions from real interview reports rank first. Updated daily.
Calculate the monthly spending trends for customers using window functions and joins.
LifesightBuild an efficient PostgreSQL report that aggregates partitioned project events and costs without join multiplication.
McKinsey &Detect a heavily skewed join key and produce a deterministically salted join result for more balanced large-scale processing.
DatabricksIdentify the main pitfalls that can distort A/B test interpretation and explain how to guard against them.
LifesightSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Outline the first checks to diagnose a sudden drop in a core product metric, starting with data quality, scope, and decomposition.
LifesightDefine a success metric for a new feature that captures real user value, not just raw usage.
LifesightExplain how to evaluate whether an A/B test result is statistically significant and how to interpret the result.
LifesightCompare star and snowflake schemas in a warehouse pipeline, including structure and transformation trade-offs.
LifesightExplain how MTA and MMM differ, what each is good for, and when to use each for marketing measurement and budget decisions.
LifesightTests production readiness for LLM serving including monitoring, scaling, and safety.
Lifesight