Interview Questions

Salome L. - "SELECT MIN(id) AS id, TRIM(LOWER(email)) AS cleaned_email FROM users GROUP BY cleaned_email ORDER BY id `"See full answer

Helen Z. - "Two clarification questions first! When we say quarters, are we assuming the quarters are stacked on top of each other, or are we measuring across the diameter? let's say they are stacked. And second question, is the height of the building just from the ground floor to the top of the building? yes. Okay, the key numbers we need to find then are the height of the building in feet, and the # of quarters that fit into a foot. First for the height of the building, the key numbers are heigh"See full answer

Anonymous Muskox - "Interviewer : How would you reduce ride cancellation on Uber ? Shailesh : Okay before I jump onto the solution, I would like to clarify some points for better understanding. So ride can be cancelled from the both the parties rider and the driver ? So which side are we talking about ? Interviewer : we are seeing more cancellation from diver side. Shailesh : From how long we are seeing this trend ? Interviewer : you can say from an year. Shailesh : Okay, also are we seeing these cancellations from"See full answer

Anonymous Bee - "Which structure would you suggest for such a question?"See full answer

Sameer A. - "Google’s Mission: Organize the world’s information and make it universally accessible. Google offers perhaps the most consequential set services available on the internet today - Search, Maps, Gmail, Drive, Docs, etc. These services reach billions of users across the world and they are all available for free. Google is able to give away these services for free because of how their business model works. Google’s Business Model: Google makes money from Ads. They offer perhaps the most"See full answer

Sahil A. - "Clarify: A new company that is coming up with a solution for garage door openers The door opener will be installed in houses. Confirm if offices, service centers etc are in the scope At this point, we are looking a specific demographic/market - India Users: People who own a car and a personal parking space. The distinction here : They have hired a watchman for the house They didnt hire a watch for the house For this problem, I will focus on those people who didnt hire a watchman"See full answer

Rishabh P. - "Step 1 — Clarifying questions (always start here) Before jumping to solutions, ask these three things: What type of product is it? Open-ended chatbot vs. task-oriented assistant? An open chatbot has the lowest risk appetite because the user can input anything. Assuming: it's a shopping assistant (like Rufus on Amazon). Is it stateful or stateless? A stateful chatbot stores memory across sessions, which makes PII handling critical. Assuming: Stateful What kind of safety are we"See full answer

Ross B. - "I most want to communicate a few principals of conflict resolution that I believe were integral in this situation, which are mutual respect, a results orientation, an unwavering focus on the user. To that end, here’s how I’d like to structure this answer: First, I’ll tell you about the project we were working on, to provide some background for you. Second, I’ll describe the disagreement. Third, I’ll describe how we arrived at a solution, and finally, I’ll discuss how those 3 conflict resolu"See full answer

Justin G. - "Observation This is an interesting question. The solution has two heads, meaning that the user must feel less guilty AND the solution must also increase revenue towards the platform. Structure The way I would approach this involves splitting the question into sequential steps. Why are users feeling guilty about using Instagram? What are some ways to make them feel less guilty? How can we monetize this? Clarification How do we define guilt? Is there a relevant subsector of"See full answer

Bk - "To bring any product to market here are the below steps that I would (did) take: 1.Understand the problem stmt / stakeholder need and asses depth of the problem (qualitatively and then gather metrics to quantify it) 2.Do market study on understanding relatable solutions if any 3.Carve out viable solution/ideation that aligns with overall Business Vision/Goal 4.Get stakeholders buy in on the idea 5.Guesstimate and prioritize high level features, Cost and ROI. 6.Build Business case for Project Le"See full answer

Ahmed A. - "He was really all over the place ? couldnt detect a structure to his answer felt like he was talking out of experience ."See full answer

Shubh - "Defining the product Spotify is a music & podcast streaming application and by podcast, we are talking about the audio podcasts which creators upload on the app. Clarifying Questions & respective assumptions Context Who are we improving the product for? Creators or Consumers? What are the current features for consumers in brief? Each podcast has episodes, about(audio trailer), more like this Why are we doing this? Where are we planning to l"See full answer

Rachita D. - "I will start with making sure that I have a clear understanding of Medium and how it works. I will ask the interviewer to fill in any gaps in my knowledge of Medium. Medium is a platform for novice, and professional writers to express/share their opinions readers to read about subjects that matter to them the platform has been running for some time (6-7 years), so it is relatively mature (this confirms that Medium has found a product-market fit) Here is my high-level structure for answeri"See full answer

Zakery K. - "Conflict is a GREAT opportunity to really demonstrate that you care about someone and, through effective conflict resolution, build stronger authentic relationships with the people you work with. When faced with conflict, I prioritize understanding all perspectives involved. I start by actively listening to the other parties: asking clarifying questions to pinpoint the source of the conflict, reflecting back what I'm hearing to make sure I understand them correctly, and ultimately identify"See full answer

Michelle D. - "I'd approach this first with a clarifying questions geared towards fraud prevention as these are going to be important to actually finding a root solution. I'd want to take cues from the interviewer in order to then identify potential hypotheses. Clarifying questions: How is fraud calculated? It's important to clarify the metric used to know that fraud is increasing. For example, is this a percent of all customers or transactions? Is the fraud that the merchant reported confirmed fraud"See full answer

Adib M. - "Notes from the Video. 1-1s are two way feedback. Important tool to discuss things that are not possible in group setting feedback to employee by manager feedback to manager by employee Feedback to employee can vary by the type of performer the employee is (a) high performer (b) meets expectations (c) under performing Dos and Don't Avoid project discussion as they can be obtained else where. Focus on feedback to employee. Unless there is a critical project item to be d"See full answer

Jacob C. - "Clarifying Qns: Did the watch time went down and comments went up for the same videos or are we saying total watch time and total comments on Youtube? (Total) I am assuming we are not including Youtube Live videos because those are typically live chat 1000’s of comments for a single video. (Correct) Do we know if these two could be independent problems not correlated with each other (No) Here is my approach to diagnose the root cause: Will look at some general trends first Intern"See full answer

Manish M. - "Here is the sample answer from the Assistant at https://chat.openai.com/g/g-Z8yp2xrzt-fang-pm-interview-assistant As a Product Manager at Google, designing a product for air travelers involves leveraging Google's technological prowess and vast data resources. Here's a comprehensive approach: 1. \\Understanding Goals and Objectives\\ \\Primary Goal:\\ Enhance the travel experience for air travelers through seamless information access, personalized s"See full answer

Umang S. - "Situation- I was leading a product through a complete overhaul to a new replacement product, and at the same time had to maintain the old product. Concern - In the old product, the team was usually stuck 40-50% of the time in bug fixing This could have hampered the velocity and GTM of the new product Action Localised the problem to one major component - Export and Import Function- had 90% contribution to the issues Worked with the engineering team to diagnose the issue, the issue was i"See full answer

Karthik M. - "Assumptions & Clarifications This is a platform based on YouTube, and it can use associated Google Products like Gmail, GDocs, GSheets etc along with Youtube as a base platform. Do you have any specific goals with the platform? For instance, should this be the de facto platform for Universities K12 schools etc? Assumption is that it can be used by anyone. Let us first discuss the target users, and then arrive at appropriate goals that we can use to measure the adoption of the produc"See full answer