vConstruct Interview Questions
The questions to prepare for vConstruct interviews, across all roles. Questions from real interview reports rank first. Updated daily.
Calculate five-day rolling service averages using daily aggregation, a calendar join, and PostgreSQL window functions.
Explain how RANK() and DENSE_RANK() handle ties differently in ordered SQL results such as leaderboards.
Calculate a three-day moving average of active-client revenue using aggregation and SQL window functions.
AAreteSShyena Tech YarnsEEvalueserveCalculate each Hinge user's 30-day rolling average of daily interactions using CTEs and window functions.
HingeCCatalyst Operations & AnalyticsAAlight SolutionsIdentify the main pitfalls that can distort A/B test interpretation and explain how to guard against them.
Design an A/B test for a new platform feature, including success metrics, power, guardrails, and a clear ship decision.
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.
Investigate a 15% engagement decline by decomposing the metric, isolating root causes, and proposing actions.
Evaluates end-to-end investigation from raw events to pinpointing drivers of change.
Define a success metric for a new feature that captures real user value, not just raw usage.
Tests your approach to achieving reliable inference in experiments.