Interview Questions

Anonymous Roadrunner - "-- Write your query here select id, (case when p_id is null then 'Root' when pid in (select id from treenode_table) and id in (select pid from treenode_table) then 'Inner' else 'Leaf' end) as node_types from treenodetable order by 1; `"See full answer

Anonymous Bee - "Which structure would you suggest for such a question?"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

Anonymous Crayfish - "Clarify Read more what & where? -> Books. Where -> upto candidate Who are we? -> A big tech company Goal -> to help people read more books Assumptions Books which aren't education/work related. Basically books that you read in your free time Read doesn't necessarily mean read text, it means looking at and making sense of what is displayed. and display can be in any form -> text or image or video Customers Kids in age of 5-12 years Teens Adults Elderly We pick kids in age of 5-1"See full answer

Robert H. - "The addition of an intermediate "sanitization" ML is something Neeraj used in the Uber Eats design and again seems kind of outside the scope here and redundant. This can simply be built into the AI response model to save a step. It's not clear what benefit this step provides, and he basically said we should have it "just because it would be good" and there's no concrete reasoning why to include it. Adding a Kafka queue to handle the thumbs-down ratings? For what purpose do you need a queue othe"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

LateArriver - "A mature manager. Great conversational answer. I wish more sessions with him"See full answer

Hl M. - "Would love to have transcripts posted below videos with timestamps to help us browse the video when video lengths are typically longer"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

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

Jonathan S. - "To clarify the question, we need to know What portion of “food” are we discussing? All groceries, cold ready-to-heat meals, meal kits, hot meals, or something else? Finding “something else” presents the opportunity to invent a new sector of the business that leverages Amazon’s unique strengths. That’s more likely to be a winner idea, from Amazon’s perspective and the interviewer’s opinion of you, than copying some other company’s existing approach. But it’s also possible the interviewer has a"See full answer

Darren L. - "First I will set up the formula, second I will calculate each of the components then adding them up. Finally, I will talk about corner cases if any. 1, To begin with, I want to think broadly what could go into the equation. Bandwidth depends on number of devices at a time, so if a student use both laptop and phone at the same time then we have 2. Beside, grad students need internet for various reasons, such as checking email, searching on Google for information, watching lectures... Different a"See full answer

Rahul G. - "50% of users spending money on play store at a global level sounds off I would factor this to maybe 20% of play store users I'd go about solving for it as follows: Play store revenue has multiple revenue sources and in my view all are significant contributors, they are as follows: Ads Subscription revenue from app In app purchases I'll start with TAM(user count) for google play store = (population x internet penetration rate x smart phone share of internet users MINUS china user ba"See full answer

Shivastuti K. - "For somebody who needs accessibility accommodation, this doesn't have a transcript so it is not useful to me."See full answer

Vikas T. - "Too much talk nothing concrete to know about the person that I am interviewing."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

Soledad A. - "Where is the second part of the video?"See full answer

Izzy K. - "Clarifying questions (since there is no interviewer to clarify, I will state and make my assumptions below): Is this an app for park-goers, Six Flags employees, or some other stakeholder? Assumption: this is an app for park-goers Is there an age-limit on the app? Assumption: There is no specific age-limit, but it should be family friendly Will this app be standardized across all Six Flags locations? Assumption: yes To design this product, I will explain my thought proces"See full answer

Veronica S. - "How about this one... Situation: In my previous Organization, I was PM of Financial services- Business Loans. I was building the user journey and end to end process. We were in middle of development and I got one more product to work on - BNPL (Buy Now Pay Later). Tasks: I was asked to provide the roadmap , rough wireframes, guess estimates (No of engineers required) and by when we can ship the MVP. Need not to mention but as startups always have resource constrains and tight deadli"See full answer

Nesru M. - "Good to you The addition of an intermediate "sanitization" ML is something Neeraj used in the Uber Eats design and again seems kind of outside the scope here and redundant. This can simply be built into the AI response model to save a step. It's not clear what benefit this step provides,"See full answer