Requirements Analysis & Problem Decomposition Questions
Break down complex business requirements into smaller technical components. Identify ambiguities and ask clarifying questions. Prioritize requirements logically. Plan implementation approach step by step. Create technical specifications from business requirements.
MediumTechnical
0 practiced
Given this table schema: orders(order_id PK, user_id INT, sku TEXT, price DECIMAL, status TEXT, created_at TIMESTAMP), write SQL queries to: 1) compute weekly active users (WAU), 2) compute weekly revenue per cohort where cohort is week of first purchase, and 3) write a data-quality query to detect duplicate orders (same user_id, sku, created_at within 1 minute). Include assumptions and brief explanation for each query. Use standard ANSI SQL.
MediumTechnical
0 practiced
You have five possible initiatives for next quarter: A) lead scoring ML model, B) automated ETL for marketing data, C) retention dashboard, D) full data quality audit, E) pricing experiment. Using an impact vs effort matrix, prioritize them and explain trade-offs, dependencies, and what metrics you used to estimate impact and effort.
EasyTechnical
0 practiced
A stakeholder asks: 'We care about conversion lift — which model metric should we optimize: precision, recall, F1, AUC, or uplift score?' Explain how you would translate the business KPI 'conversion lift' into an appropriate evaluation metric and describe scenarios where each metric might be preferred.
HardTechnical
0 practiced
Estimate cost, latency, and operational complexity for three serving strategies for a scoring model at scale: 1) nightly batch scoring, 2) micro-batch scoring every minute, 3) per-request real-time scoring. For each option provide resource estimates, failure modes, monitoring needs, and decision criteria to recommend one given business constraints (SLA, cost budget, accuracy needs).
EasyTechnical
0 practiced
Given this high-level user story: 'Build a recommendation engine to increase conversions,' identify at least 10 specific ambiguities or missing details. For each ambiguity, write a clarifying question you would ask the product manager and explain why it matters for scoping the project.
Unlock Full Question Bank
Get access to hundreds of Requirements Analysis & Problem Decomposition interview questions and detailed answers.
Sign in to ContinueJoin thousands of developers preparing for their dream job.