Interview Questions

- Z. - "with base as ( select viewerid, year, month, watchhours, lag(watchhours, 2) over (partition by viewerid order by year, month) as p3, lag(watchhours, 1) over (partition by viewerid order by year, month) as p2 from watch_time ) select viewer_id from base where p3 < p2 and p2 < watch_hours group by 1 `"See full answer

Rahul S. - "I have a 10 years experience"See full answer

Tracy M. - "I defaulted to a dictionary-style definition of autonomy, then loosely tied it to users and systems. But I missed the interviewer’s signal that this was really a design/strategy probe. Stopping at a generic level made it sound like I couldn’t translate agency into what matters for product — user trust, trade-offs, risk, and roadmap implications."See full answer

José N. - "My clarifying questions : what's the impact of the bug ? / responses : intermittent, no platform stability at risk, but a feature, many customer rely on this buggy feature what's the estimation of the user impacted ? / responses : 65% of the users how long to figure out a solution ? / reponses : 1 week My action plan : delay the publish of the release in order to protect the brand identity and customer trust talk to the big customer to explain the situation with transparency and nego"See full answer

Upasana S. - "Clarifying questions: What is a roofer? A: A person who constructs and repairs roofs. Should this include construction companies or the actual people who construct it, like masons, labourers? A. you can define the segment Any specific geography to operate in? No, any geography or worldwide can be chosen Does the company have a goal in mind? New product creation to capture a market. Can the product be a physical product? Yes. In terms of constructing roofs, there is generally no separate company"See full answer

L B. - "For data distribution drift: DL Divergence or PSI (Population Stability Index) performance: two categories: 1st operational metrics: runtime. 2nd model performance: loss function, MAE (regression), business metrics: overall watch time, DAU, revenue lift etc Outlier: data distribution"See full answer

Bipin G. - "Identify the best platform to reach millennials (Youtube, Instagram). Run a survey/ research on pain points millennials are facing in the smart home products sector Identify a product that gives the most value with optimal effort Build and Launch The marketing team should use the same platform to identify key influencers on social platforms and use an emotional connection to millennials with an ad campaign"See full answer

Kartikeya N. - "Clarifying questions: What level of retention are we targeting?: 30/60/90 day?: 30 days retention Do we have any user geography in mind?: No, lets talk global How do we define 30 day retained user? : Any user who comes to the app once in 30 days to do something meaningful How much is the current retention and how much do we want to increase it to?: Lets aim to 2X the current retention in an year Lets start with the Goal of the Adobe Scan app. Its goal is to allow users to capture im"See full answer

Anonymous Jaguar - "Code reviews, automated linting, unit tests, integration tests, validation tests"See full answer

Ananya M. - "Assumption: question is about people in the US, and we define frequent bar visitor as someone who visits a bar twice a week. we are defining bars as places that people go for alcoholic beverage , not for the snacks , non alcoholic beverage or sports TV population of use 330M , 80m per age group 0-20 (eliminate because drinking age is 21 and above) 60-80 (eliminate because they prefer drinks at home or sit down restaurants or are very health conscious to go drinking) 20-30 : 40m 80%"See full answer

Frank A. - "Evaluate product performance metrics against projections, rationalize performance, and identify opportunities to optimize performance"See full answer

Greg W. - "Equation = (# of phones sold in Africa every month * % pixel market share) Africa population = 1.5 billion Smartphone penetration = assume 50% Assume smartphone penetrations grows 1% per year Assume 2 year smartphone renewal cycle Current smartphone population = 1.5B x 50% = 750M Each year 50% of this populations gets a new phone = 375M 375M / 12 = ~31M per month New smartphone population each year = 1.5B x 1% = 15M 15M / 12 = ~1 per month 31M + 1M = 32M smartphones sold per month US mar"See full answer

Praveen V. - "House buy is time-consuming and complex. (too many steps involved, from selecting a house, to agent, loan, closing, moving, knowing the place and people to settling down). Lets leverage power of fb and socialness to simplify house buying. we will create product for that users for home buying buyer ( for sake of simplicity - assume employed family with kids. local buyer) seller agent user flow for buying: Market research: understand the market, research area (friends, family ta"See full answer

Kim L. - "Explore expanding beyond just two small roooms-- bigger rooms or a third room? Get insights from those who are teleporting about what the experience is like"See full answer