Interview Questions

Karthik R. - "This is yet another classic case of evolution of data landscape to account for diversities in the data formats sacrificing restrictive but key components at first and added later to make the solution more effective. Data warehouse -> Data Lake -> Data Lakehouse (Data Lake + Data Warehouse) Data warehouse - A solution to store data in central place (analytics (read) heavy) with stringent schema (structured). Very useful for historical queries and analytics. Schema on write check. Only used for"See full answer

Roopesh N. - "Goal: What product would I build next Who am I? I am Disney's head of technology Focus: Theme parks Geolocation: Pilot in the US and then roll out across the globe Eco-system>>>User>>>Pain points are>>>Solution>>>MVP>>>Launch metrics> Guardrails Eco System Customers Direct Suppliers, vendors to DIS In-Direct suppliers (Hotels, restaurants, etc.) DIS- Service User ( TAM, underserved, Frequency) Customers Families, including Children ( L, L, L) Couples(S,L, M) Si"See full answer

Kim L. - "Explore expanding beyond just two small roooms-- bigger rooms or a third room? Get insights from those who are teleporting about what the experience is like"See full answer

Upasana S. - "Clarifying questions: What is a roofer? A: A person who constructs and repairs roofs. Should this include construction companies or the actual people who construct it, like masons, labourers? A. you can define the segment Any specific geography to operate in? No, any geography or worldwide can be chosen Does the company have a goal in mind? New product creation to capture a market. Can the product be a physical product? Yes. In terms of constructing roofs, there is generally no separate company"See full answer

Jeff H. - "Interesting question. I believe they now do this. Couple clarifying questions: Are we talking about the FSD feature specifically, or older legacy models as well? Is there any hardware needed in order to enable this feature, or is it purely a software update? Would people still be able to pay a set fee for FSD upfront, or is it up to me? Up to you. Goals: Let's think about Tesla's goals in this change. One could be adoption. The cost of 10k could be prohibitive for the feature up"See full answer

Vivan B. - "Feedback would much appreciated as I have not practiced many product strategy questions Clarifying questions Can we assume this is the first time Google has entered the elevator market? Or are there prior elevators to this one? Let's assume first time Is this a large elevator for industrial use like heavy goods/freight etc. or is it an elevator for apartment blocks and commercial premises? Let's assume passenger elevator Is there a geography for this launch? Let's assume the US"See full answer

Debajyoti B. - "Museums are multi-revenue organizations. They dont have much or any profits in the process but thats becuase they dont want to either. All the money pretty much goes to operational costs required to be a well maintained place of exhibit. Lets consider the sources they currently "make" the money from- governments(national and/or state) private donors and trustees heritage organizations with their lottery fundings self channels like admission/entry fees, tickets for exhibitions, gift s"See full answer

Aekagra S. - "Clarified whether this drop is observed in a particular geography or with a particular demography or devices. Then moved to the analysis of any bugs or flow broken or any defects. If not then talk about any competitor launching a product or feature in a similar category. If yes then double down on that or else speak about any political or marketing campaign that's been launched or any negative news about Facebook. What-Why analysis and concluded with a possible cause."See full answer

Googlepm 1. - "Since there is ample amount of data, there are various options to use them : Track travellers : Using traffic data coupled with user's GPS, in consent with the user, find the user's exact spot, this can be valuable in case of emergencies or tracking a school bus. Better ticketing : I understand that the notion is to NOT build anything with navigation, however if we have all data on the traffic, data analytics can predict if particular routes are used most, say if three connection routes a"See full answer

Anna H. - "Great. I’d like to break down this by discussing impacts of post investment decisions for the Pixel handset lines at two levels of micro and macro evaluation, which will be able to lead us to an evidence-based answer of what I think Google should continue to invest and ramp up their investment to hit their target ROI. First, closely looking at micro aspects, Google’s business model is a so-called multisided platform, generating either free search engines and monetizing contents for Internet use"See full answer

Praful B. - "Using a join: This is the most common way to do a lookup."See full answer

Frank A. - "Evaluate product performance metrics against projections, rationalize performance, and identify opportunities to optimize performance"See full answer

UoP - "What goals would you set for Reels recommendation engine? Clarification: Is this Reels on Instagram, FB? Which ones do you mean? -Instagram What does this feature cover- Reels recommendation engine- showcases a new video to the user when tapped User can Like, comment , add reel to the story, remix this reel, save, report, not interested Why is this done? Competition from Tiktok : Make Reels appealing to Meta userbase so that Meta doesn't lose users, creators, brands to TikTok Mission "See full answer

Anonymous Dove - "One possible product idea is to create a Layover Buddy app that connects travelers who have layovers at the same airport and helps them make the most of their time. The app would use Facebook’s data and features to match users based on their preferences, interests, and flight schedules. For example, the app could suggest users who are traveling to the same destination, who have similar hobbies or tastes, or who are looking for the same type of activity during their layover. The app would als"See full answer

Preetham m P. - "1. Clarify the problem Are we building a digital or physical product?- We are offering it as an application on mobile. Are we building a complete new product or as a new feature for existing airline booking apps (Goibibo/Makemytrip, etc.)? - New feature for existing booking apps. We can consider Goibibo as an example. What do you mean by improving experience?- Reduce wait times or optimize the time spent. What is the goal? Engagement or Revenue? - Engagement. Which is t"See full answer

Evgeniy K. - "agile kanban"See full answer