Interview Questions

Gowtami K. - "select DISTINCT p.product_id, p.product_name , CASE when sale_date is null then 'Not Sold' else 'Sold' END as sale_status from products p left join sales s on p.productid= s.productid `"See full answer

A K. - "Goal of Google: Clarify: What exactly is Google podcast? A place for people who create podcasts to host their podcast? Great with that in mind.... Google's mission is to organize the world's information and make it universally accessible and useful Goal: From a podcast perspective, you can imagine that Google’s wants to organize the world's information and make it universally accessible and useful through a podcast. Actions: Two-sided user base: People who listen"See full answer

R K. - "Some clarifying questions: Is this going to be a part of exciting Meta product or completely new one? you choose Is there a particular sport or range of sports that the product should cater to? all sports, should be agnostic. What is "athletes"? pros? amateurs? fitness enthusiasts? you can decide Is there a specific problems or challenges faced by athletes does he want the product to address? feel free to make assumptions Is there a specific goal that we want to achieve"See full answer

KAI - "Clarified on definition of hyperlocal - Defined it as a community of people in a 2-3 km radius and assumed geography as India Talked about different type of community needs in a hyperlocal space - public services, local grocery delivery, food delivery, parcel delivery, making new friends for shared interests like playing badminton (Prioritised public services since it was underserved with respect to things like sewage cleaning, electricity outage in an area, community traffic problems, water"See full answer

Exponent - "We've identified the problem as a Design a Product question. Use the following framework for tackling these types of questions: Ask Clarifying Questions Identify users, behaviors, and pain points State product goal Identify current solutions Brainstorm new solutions Evaluate solutions Measure success Summarize We'll go through each of these step by step. Ask Clarifying Questions The PM interview isn't about your ability to come up w"See full answer

Angela - "Clarifying Qs: What are we building the Google campus for on the moon? We are the Google X team and always want to move people forward and want to be the first private entity on the moon Are we trying to build for astronauts or our employees or someone else? This will be for employees Do we already have a location on the moon and we're expanding or will this be the first one ever? This is the first one ever. For us to answer this question, we'll want to discuss Google's mission, us"See full answer

Anonymous Pelican - "Just to preface - I've actually worked in the non-profit space previously, so I have some experience in this problem area. Clarifying questions: Is this within the Facebook app itself/integrations across the FoA’s ? Or is this going to be a standalone product? Assume: Charity function built within Facebook. Clarifying Question: Are we okay to constrain this to the US region? There may be tax implications outside of the US we aren’t strongly familiar with and so easier to focus on U"See full answer

Surekha G. - "In one of the projects I managed, one team member was slipping each of his task's ETAs several times, citing different reasons, and communicating the delay after it already happened. The delay seemed disproportional to the reasons thereof. I first collected sufficient historical data to confirm that this was a pattern, and similar circumstances were faced by other team members, but they were managing to still keep their ETAs. Then I had a talk with the person, and showed him the data. I also ex"See full answer

Dessalew A. - "R² → goodness of fit (but can mislead) Adjusted R² → better for model comparison Multicollinearity → hurts interpretability, not always prediction T-test vs F-test → individual vs overall significance Weird case (F not significant, T significant) → likely multicollinearity or instability"See full answer

Tanu M. - "When it comes to Metrics, I always think of one thing " What cannot be measured cannot be done". The product that I am managing goal is on enabling the products for our partners so that our partners can have a seamless experience of doing business with us which in turn will increase the revenue. The user segment for my product is mainly resellers who can resell the product to another customer so that the reach of the customers is more. The metrics which I am tracking are revenue, referrals, an"See full answer

Kiley S. - "Improve facebook’s feed. Clarifying questions: Do we want to look at desktop or mobile specifically? – Mobile Is there a specific goal we have in mind that we are trying to meet or just general improvements? — General improvements, innovation Clarify Product: The Facebook newsfeed is the content feed that users see when landing on the app. The feed shows content posted by people users follow Within the feed the user is offered updates on people they follow - friends, family, celebrities"See full answer