Interview Questions

Koko A. - "Minimum living standards support for all humans"See full answer

Bryan L. - "with var1 as (select *, rank() over(order by score desc) as srank from players) select player_name, score, srank as ranking from var1 where srank in (4, 6, 11) `"See full answer

Bill P. - "benefit to the project Probability of intended outcome Affect on resources needed to complete project"See full answer

Diamonde H. - "I'm assuming we're negotiating because we want the vendor to do something unique for us that's possible but they've never done it before or that they do often but we want some sort of preferential treatment or pricing deal. I'm also assuming we're not desperate and have the upper hand. Pre-Call with vendors Define our ideal state Define our BATNA Vet and speak to at least 3-5 vendors (depending on market concentration) Objectively know what is possible within industry and with the vendo"See full answer

Nehal B. - "Who uses translation API Consumer apps Enterprise SaaS Content Platforms Gaming Companies Govt Global internet users - 5B out of which 20% need translation as they encounter foreign content = 1B users Average translation triggering event per use per day - 0.3 (review, website…) Total translation demand = 0.3 * 1B = 300M Translation can happen in-house or via Third-party APIs Assume 60% served by APIs for enterprise 180M API translation calls/day Assume 1000 characters should be abo"See full answer

Dan D. - "Used CIRCLES framework, and broke it into 3 age groups."See full answer

Preethi B. - "How would you improve LinkedIn's homepage? Firstly I would like to think about: 1) Goals and Constraints 2) User and the user personas 3) Prioritize the Use cases / Painpoints 4) Brainstorm on possible solutions for the chosen use case If that's fine by you! In terms of Goal: 1) Revenue 2) Active Users/Engagement - MAU These are three goals I can think of for improving the LinkedIn homepage. We are looking to generate more revenue, increase the number of monthly active users. I would"See full answer

Anonymous Crab - "Clarification questions : What do we mean by International - not home country(or US) , 1st International launch ? What is the product, physical / digital / service ? - Assuming Linkedin Can we test it - what is the cost of testing it - Assuming Linkedin , so we can test the market with a soft launch , ads before a full blown launch other parameters to consider - Target market & customers Attractiveness of market Underserved needs - early mass/ signs of demand gen - are there local pr"See full answer

Rohit K. - "Clarifying scope : This is a feature on top of existing swiggy app to deliver prepared food for health-conscious people Clarify the term health conscious : Calory counters Macro trackers : Need balance of carb, protein, fat etc. Fresh Eaters :Need fresh ingredients Allergic due to some ingredient Ill people There can be various user personas along with respective pain points are: 1) Gym goers : No way to count the calories or track macro intakes in a swiggy order 2) Fresh eaters : Lack"See full answer

Ragupathy V. - "Started with clarifications, listed out assumptions, created stories with user pain points in existing business, how we can eliminate in our design and strategy, metrics for the success of business initial 90 days, 6 months and a year. What i missed to present is the north star metrics Overall i thought i did well, still didnt get through Hope it will help me for other interviews in Amazon/Meta/Cisco"See full answer

Judy W. - "Clarifying questions What do you mean by “mattress”? All types and sizes of mattress? Are we only looking at mattress in the household or includes the service industry? Assumption Assume that we are looking at mattress in the household only. Assume that the number of people who own more than one mattress is negligibly small relative to the total US population. Figure that 20% of people are couple and are sharing beds, and 5% are newborns sleeping with their parents. **Appro"See full answer