Interview Questions

Chitapuram N. - "Since there is a need for the data to be accurate and consistent without any latency to allocate a spot, can't the data be synchronously synced to replicas after every write as the number of writes are not many per min, instead of read lock phenomena Let me know if i am on a wrong thought here."See full answer

Scott S. - "Designing a Price Drop Tracker system like CamelCamelCamel involves creating a platform that tracks price changes for products on various e-commerce websites and notifies users when prices drop. Here’s a detailed system design for such a service: Functional Requirements User Registration and Authentication\: Users can register and log in. Support for social media logins (e.g., Google, Facebook). Product Tracking\: Users can add products to their watchlist for"See full answer

Tiffany A. - "SELECT customer_id, order_date, orderid AS secondearliestorderid FROM ( SELECT order_id, customer_id, order_date, ROWNUMBER() OVER (PARTITION BY customerid, orderdate ORDER BY orderid ASC) AS rank FROM orders ) WHERE rank = 2 ORDER BY orderdate, customerid `"See full answer

Rani Y. - "Design a product for gardeners. Assumptions / Clarifying questions -> What ? -> Why ? TAM -> Mission for Meta -> Business Goal -> User segmentation ( P) -> Painpoints (P) -> Solutions ( P -rice) ->NSM -> Risks -> Summarize Assumptions : New Embedded ( **) onto a Blue app Is there a timeline ( 1 Year ) Region ( Pilot small users group ) What : Practice of cultivating food , flowers , decorated plants in controlled environment backyard , greenhouse , front yard etc Why"See full answer

Vihari K. - "Situation: While working at CVS Health, our inventory management system for OTCHS products was facing challenges. We had increasing stock outs, and our existing data was insufficient to fully understand and address the issue since it has been only a year this product line was initiated. Action: Although we do have a forecasting model to predict demand and other algorithms to trigger out of stock flags to warehouses to fill them, lack of data points on seasonality, supplier delays, compliance"See full answer

Anonymous Newt - "CQ: What's the goal - we are just exploring Any specific timeline we are targeting - NA Why specifically podcast - its a growing area and can help engage the customers Any specific geography to be kept on mind - You tell Approach: Understand Netflix’s landscape Understand more about the Podcast space via Porter’s 5 Forces framework Decide mode of entry Tradeoffs & Risk Netflix’s landscape; Product - OTT player Who uses - kids, adults When do they use – leisure"See full answer

Kai H. - "I have 2 product feedbacks. I think it has been mentioned by many users of the platform. Provide a text summary of the videos so that we do not have to watch through the whole interview practice Actually comment if the interview was good or not, currently we do not really know if the answer given is of high quality "See full answer

Michelle D. - "I'd tell the interviewer that I'd start off with clarifying the question to make sure I understand it correctly (see 1 below). Then, I'd tell the interviewer my approach to make sure they know what to expect as I talk through. Approach would start with discussing the mission and connecting a north star metric (NSM) to the mission, then discuss key product metrics that are inputs towards NSM. If there's time at the end and if the interviewer wants to go down this path, we should also talk about t"See full answer

Bala G. - "SELECT s.Sale_Date, SUM(si.Quantity * si.SalePrice) AS TotalRevenue FROM Sales s JOIN SaleItems si ON s.SaleID = si.Sale_ID GROUP BY s.Sale_Date ORDER BY s.Sale_Date; "See full answer

fuzzyicecream14 - "App I Don’t Like: Electrify America What Electrify America Is Supposed to Do Electrify America is an app designed to help electric vehicle (EV) owners locate, access, and pay for fast-charging stations across the U.S. The app provides real-time station availability, allows users to initiate and monitor charging sessions, and offers membership plans for discounted rates. Ideally, it should enable a seamless charging experience, especially for long-distance travelers relying on i"See full answer

Amney M. - "it is really good explanation thanks it is really good explanation thanks"See full answer

Astro S. - "What are they looking for in the answer? "See full answer

Bimal M. - "Clarification questions: What do you mean by online furniture-selling market? Why would google want to do it? Why does google want to do it now? Where does google want to launch it? Let me make the assumptions answering above questions: It is like google flights, say we call it google furnitures, where it organizes, curates furniture information to the users and then refers to the seller website instead of selling furniture directly to the consumer like amazon, walmart, way"See full answer

Mark H. - "Clarification: workplace is a communication messaging tool for employee to send and receive messages. Why: meta's mission current landscape market trends meta's unique value strength & weakness Workplace Mission: build a communication tool for employees to better collaborate and engage with each other Goal: focus on engagement, not revenue Product ecosystem: Meta Company sourcing department IT department User: sender/receiver #of people log in #of people"See full answer

Syed I. - "I use a data driven approach by ensuring there is a deep-dive on all alternatives. My approach to tradeoffs is around how to achieve the customer experience needed. I ensure there is an immediate path to green for a solution and a follow-up solution addressing the problem rightly."See full answer

Saleel P. - "This is my first attempt at an estimation question, any feedback is appreciated. I'd like to clarify if AirBNB's core services would include user reservations on its web/mobile platform on a per night basis. I'd also assume if we would to estimate the topline revenue (or gross merchandise sales) without factoring operational expenses and taxes. I'd also clarify if basing my estimation on revenue from its largest marketplace, US, is reasonable. Population of US - 350 MM Avg Household size - 2.5"See full answer

Mrinalini R. - "A good answer is describing an experience where you either proposed something that was selected after discussion or an alternate approach was taken, or you disagreed with a decision and argued for something else, either successfully or not. A good answer would be you had cogent arguments, the decision went another way for some reason, and you then fully backed the decision (agree to disagree is another way of stating it). You did not take it personally and you fully committed to the deci"See full answer

Logan S. - "Clarify the Goal (What Does Success Look Like?) Asked: Why is DoorDash launching bikes for Dashers? Is it to: Expand Dasher availability in dense urban areas? Lower delivery times or costs? Increase access to work for those without cars? Each possible goal shapes the metrics differently. Broke Metrics into Categories: Operational Metrics Measure how well bikes are functioning as a delivery method. Average delivery time (bike vs car/walk) Order completion rate for bike Dashers On-t"See full answer