Interview Questions

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

Jessica C. - "select customer_id, order_date, orderid as earliestorder_id from ( select customer_id, order_date, order_id, rownumber() over (partition by customerid, orderdate order by orderdate) as orderrankper_customer from orders ) sub_table where orderrankper_customer=1 order by orderdate, customerid; Standard solution assumed that the orderid indicates which order comes in first. However this is not always the case, and sometime orderid can be random number withou"See full answer

Alex S. - "One of the better videos!"See full answer

Ananya M. - "US population = 330M , 80M across 4 generations population that is physically able to travel, can afford travel, travels for business ranges between 20-60 year olds = 160M calculating maximum demand: long weekends in summer are peak travel times, lets assume 60% of population who are able and can afford travel, do so during long weekend = 0.6x160M lets say 60% of this population choses prefers domestic travel while 40% go international (consider Mexico, Canada, London are international"See full answer

Vidur K. - "Clarifying Questions First, let me try to clarify what kind of self-driving car are we talking about here. Let' say, we have the following top-level assumptions: Fully autonomous Family Sedan Car US Market This technology is only available with Google In a real face-to-face interview would pause to ask the interviewer to correct assumptions or ask for other features. Consumer Family - uses the autonomous ability of the car to spend time with kids while dropping them off to"See full answer

A B. - "Followed Clarifying questions - why this product - competition - Meta's mission - product vision - user segments - prioritize and Why - pain points for prioritized segment - prioritize pain points - list solutions - tradeoff - North star - summerize "See full answer

Nishant S. - "The obvious thing would be explain to them the reason for saying no. But that will not help you in building strong relationships with your stakeholder. First step would be to listen - understand the reason behind their request. Their opinion should be heard. Once you have done that, only then steer the conversation in the direction of logical reasoning for your stance. Also, you could talk to them about some of the competing priorities which would be more impactful, so that they unders"See full answer

Bg - "Questions: Can the toothbrush be a smart toothbrush, different from typical toothbrushes? Ans: Yes Children's age group? Ans: Pick your choice Cost? Ans: Not a concern Country? Ans: Ignore Personas: Parents typically help kids in brushing up to 5 years. Let us assume 5-10year olds as our focus. That is a decent 5%+ of global population. Pain Points: Brushing teeth for kids is a pain. They simply do not like it sometimes. Dental checkup is always a hassle. Some ki"See full answer

Anonymous Salmon - "clarify: paid users, annual subscription user segmentation: levels; active vs dormant; age; regions use cases & pain points solution brainstorm: retention = activation + engagement + resurrection; prioritization of solutions execution"See full answer

realkimchi - "Objective: Proposal for expanding the service offerings for small restaurants and local cafes. The objective is to enhance the Instacart Business platform by integrating local vendors (Speciality Food & Beverage Business Units) to increase product selection and improve supply chain efficiencies for business customers. Market Focus: The target market includes food service establishments characterized by their need for distinct, locally sourced ingredients and their struggles wi"See full answer

Danyal R. - "Clarify the Issue: Begin by asking for more context about the specific issue they're referring to. This demonstrates your ability to gather information and make sure you have a clear understanding of the problem at hand. Assumption: biggest issue is decrease in north start metric: # of bookings Prioritize and Define Goals: Once you have a clear understanding of the issue, outline the goals you'd like to achieve in solving it. Increasing booking conversions, reducing friction in the bo"See full answer

Varun S. - "Question: You'e a PM at Meta. Design a product for users to find a handyman. Clarifying questions: Why does Meta want to build this? A: Up to you to decide that, hoping to here you say why. When: No fixed duration for release. Market: I'd like to focus on a developed market, where technology reach is wider and people are more at ease with using online platforms for tasks. Maybe focus on the US market to start with. Standalone app - We will need to distinguish ourselves and create an identity"See full answer

Sergio C. - "There are many places where you can gather feedback. We can divide the feedback from external and internal sources External sources: facebook twitter reddit G2. Internal sources: on-app surveys or chats support Support engineers Sellers Recordings or notes from other PMs However, you always have to talk with the customers so customer interviews are very important. "See full answer

Ram - "Clarification: Are we talking about creating an experience or product as part of another product or from 0→1? Encourage - the goal is to increase % of citizen vote. Or want to vote? Vote - are we talking about national elections? Am I a product manager for the government? Any focus on geo, segment, or platform? Context - why do we want to do it? Did we experience a recent decline? Could it be hardware or software only? Digital or physical? Structure: Context "See full answer