Interview Questions

Lucas G. - "To speed up A/B tests results with limited sample sizes, we can apply advanced techniques like CUPED to reduce variance for faster statistical significance, interleaving to gather more comparative data per user (e.g., ranking), MAB to dynamically allocate traffic to winning variations for quicker optimization (e.g., campaigns), and Bayesian A/B testing which offers probabilistic conclusions that can be reached earlier. Each method, when appropriately applied, allows you to gain m"See full answer

Alexey T. - "-- The text of the task is a bit confusing. If the status is repeated several -- times, then in the end you should show as start_date the date of the first -- occurrence, and in end_date the date of the last occurrence of this status, -- and not the date of the beginning of the next status with t1 as (select order_id, status, orderdate as startdate, lead(orderdate) over (partition by orderid order by orderdate) as enddate, ifnull(lag(status) over (partition by order_id order by or"See full answer

Anonymous Sparrow - "Clarifying question: board meetings have varying degrees of formality, usually dependent on the size of the company and whether it's publicly-listed or still private. Is there a particular type of board meetings you'd like me to focus on? (Assume interviewer responds with: why don't you design something that's flexible to be used for any type of board meeting and any type of company) Sounds good, I'll leverage my own experience and understandings on how board meetings are run and problems to so"See full answer

Anonymous Angelfish - "Not at all impressed. Very simple problem he is solved"See full answer

A B. - "i would follow engage/ listen/understand/collaborate/engage/resolve- approach to manage conflicts. I would explain each phase in a project where I face conflict and how I used above approach to resolve the conflict"See full answer

Lucas G. - "select sub.name subreddit_name, count(distinct us.userid) totalusers from user_subreddit as us left join subreddit as sub on us.subredditid = sub.subredditid group by us.subreddit_id having count(distinct us.user_id) > 3"See full answer

Ash I. - "Refer https://www.linkedin.com/pulse/good-product-managers-great-shreyas-doshi/"See full answer

onering2ruleall - "Total volume of the swimming pool, let's say it's a standard 50m x 25 m x 2m =2500 m3 = 2.5 million litter standard water horse water flow rate is 17 liter per min. So, 2.5 m / 17 =147,059 min"See full answer

Pree M. - "What is shopper demand? Let's say the ability to predict whether x number of shoppers are available during a certain time of day based on a some factors Variables: \# number of orders /per hour /per day /per week Shopping Time: time taken for a shopper to prep an order (how many orders can a shopper prep) $ average order value geographic factors since demand will vary by city number of stores or any other multiplying factor which help us predict order volume (which is dire"See full answer

Niaz - "Assumption about the teleportation machine: Teleportation is instantaneous like Star Trek The product does not take too much space maybe 6 ft by 6 ft and 10ft high is good enough Teleportation works vertically both above ground and underground as well as going 100 meters horizontally If possible you can combine multiple teleportation machine to repeat teleportation Users groups A product like this can be leveraged for almost everyone but I think I want to focus on users who ha"See full answer

Howard H. - "We have to work with the c-suite to understood the direct quartly outcomes or goals. This could be our epic and then we try to break that down into business value and complexity . This will allow us to prioritize whats next. From there we can structure a mvp to cover maybe some of these areas to understand the estimation of this work. After the first couple weeks we can structure a roadmap and then define when"See full answer

Himanshu V. - "Video engagement: time spent, frequency, recency Video completion rate Time spent on Facebook vs Time spent on watching FB videos Video recommendation: Switching from 1st to 2nd and so on "See full answer

Sagrika S. - "The biggest factor that excites me about technology is its ever changing and dynamic trend. In my life, I have seen the transition from landlines to simple mobile to smartphones, from Cathode tube desktop screen to super slim TFT and many more. I think technology has now (with time) become integral part of human life and getting in-sync with it is like a normal and very cool phenomena."See full answer

Anonymous Roadrunner - "-- Write your query here select marketing_channel, avg(purchasevalue) as avgpurchase_value from attribution group by 1 order by 2 desc; `"See full answer

Charu S. - "Engineering efficiency - dev time per launch developer SAT"See full answer

Yulia D. - "First, I would like to ask some clarifying questions. Are we talking about the business metrics dashboard or health metrics(like response time)? - it is up to you Do I understand right that Netflix is a subscription-based video streaming service for watchers? So I know that they create original content for Netflix, but it is out of the scope of this question. - right My approach will be to: Define the business goal from Netflix’s mission Break down the actions taken by users at each stage of the"See full answer