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

Aniket A. - "Clarifications: Where are we launching? -- US first 1:1 or n:n video conferencing? -- you assume Consumers or Business? -- consumers Part of FB or standalone product? -- part of messenger app Is it MVP launch or a full feature product? -- MVP What capabilities exist in the video conference product? -- you assume what capabilities will be > Trends and Markets Competitors: Consumer Zoom Google Meet Business: Slack MS Teams Trends: More and more people are usi"See full answer

Will P. - "There are several categories of ads that users may encounter on YouTube content pages, depending on the user's device and browser. To narrow the scope of my answer, I am going to assume this is a non-skippable, midroll video ad that is 15 seconds long, and shown to a non-premium desktop user in the US. The next step is to clarify the motivations behind the proposed feature. Are non-relevant ads harmful to the overall user satisfaction? Do users engage more with relevant ads? Are advertisers mak"See full answer

Rajesh V. - "As a PM i received a feedback from my program manager on my style of verbal communication. It is about me speaking faster when i wanted to get away with a topic that i wasn't confident (may be not backed up with data, or still in process of getting detailed insight of a problem etc.). Whereas when I'm confident I tend to speak slowly or more assertively that made people to follow easily. I welcomed that feedback so from then on when I'm not confident in a topic I became more assertive to let pe"See full answer

Daniel P. - "Okay, so I understand the question: "how does Google Maps compute estimated time of arrival"... There are a couple scenarios when ETA is calculated: planning a future journey, planning current journey. Can we assume scope to the current journey? The learnings will likely be transferable. User inputs to ETA include origin, destination, and route chosen. Let's assume first that the user has chosen an origin, destination, and a route chosen. We can come back to these assumptions later. The way I'"See full answer

Andrew B. - "Assumptions: We're looking only at a single large dealership in San Jose, per the question, not all large car dealerships New cars already come with tires; the dealer does not have to purchase them separately A couple of different ways I might approach this: Approach 1: Estimate based on # cars serviced per day Dealer intakes 10 cars for servicing per hour (based on anecdotal observation) 100 cars serviced per day (assuming service dept. open 10 hours per day) Cars that need onl"See full answer

P R. - "First I'd like to clarify the definition of reactions and confirm that it's same as what exists today. Definition: Reactions provides users the ability to provide richer expression beyond 'like' Business goal: Since this is a mature product, the business goal is to improve user engagement Product goal: Bring people closer together by letting people provide more accurate sentiment to the community based on the content Personas: 1. Content creator 2. user using reactions **Li"See full answer

Abhinav M. - "Always assume good intentions on the part of both parties when resolving conflicts. Then proceed with a STAR example."See full answer

Kapil D. - "Overall a very good summary of ranking problems. I wish there are more details in the post on depth of modeling. One can talk more about advance ML architectures like DCN, BertRec etc"See full answer

David I. - "WITH filtered_posts AS ( SELECT p.user_id, p.issuccessfulpost FROM post p WHERE p.postdate >= '2023-11-01' AND p.postdate < '2023-12-01' ), post_summary AS ( SELECT pu.user_type, COUNT(*) AS post_attempt, SUM(CASE WHEN fp.issuccessfulpost = 1 THEN 1 ELSE 0 END) AS post_success FROM filtered_posts fp JOIN postuser pu ON fp.userid = pu.user_id GROUP BY pu.user_type ) SELECT user_type, post_success, post_attempt, CAST(postsuccess AS FLOAT) / postattempt AS postsuccessrate FROM po"See full answer

Anonymous Sparrow - "Clarifying question: may I assume that this would be for all new units that Roku would be selling? Ie. they wouldn't be sending new remotes to existing Roku customers? (assume interviewer agrees) Here's how I would approach this analysis: Identify purpose and value of this button for customers Identify the purpose and value for HBO/Max and Roku Posit: HBO should be willing to pay up to the value that HBO/Max gets minus potential discount by Roku for the value that Roku would get Pre"See full answer

Prabhav G. - "Assumptions and Clarifications! 1 . What is the aim? increase monetization or to just provide easy accessible food for customers 2.What are the supposed items to be available in the vending machines? 3.How many Vending Machines per hotel if more than 1 Can we add different items in the machines or are they supposed to be similar? 4.Which company is looking to Design this machine?Is it google? Or some other company? 5.These machines should they be available to paying guests or visitors or bot"See full answer

Mike Z. - "Clarifying questions Scope: Just Reels in Facebook, or Instagram too? Mobile and desktop? Goal: Any specific goal we know of or up to me to decide? Framework/Overview Strategy Metric options with pros/cons North Star Metric (NSM) Risks & countermetrics Strategy / The Why: we want to give people … Meta: the power to build community + Bring people closer together Reels: new form of self-expression / entertainment with short form video and pro editing tools Ads in Re"See full answer

Anonymous Minnow - "First, lets dive deeper into the question. I would ask - What are the top challenges facedtoday? What user segments work well, and what do we want to focus on? What do we know about competitors, and what can we learn from them? What user flows have the highest engagement in VR today? Are we focusing on consumer use cases or enterprise? Are we tackling activation or retention, or do we want to increase engagement? To build a strategy here I would target this from four differe"See full answer

Shraddha D. - "I like chatgpt for the following users Getting industry references are easy and time saving Getting recommendations is very easy Responses are accurate I use chatgpt to get feedback on content and identify gaps in my documentation or thought process I use chatgpt as a search engine and to get conscise situation based information. Chatgpt offers varierty of other tools in the explore version where similar users can create different content PRD template Chatgpt users 1."See full answer

Manohar A. - "Some follow-up questions to correctly understand what "improve" means here? Is it to have: more riders, better user experience, monetization, more/new market penetration. Let's assume interviewer requested to choose whatever I prefer. I choose better user experience which might trigger other areas of improvement as well. Some more probing questions: To I need to consider USA only or any other country/region or global? Can I consider only popular on demand taxi service for this question? One wa"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

Tara J. - "I would like to speak loud to narrow the scope of this question so I can be effective in identifying a solution to the problem on hand. Hope that is OK. You mentioned, “Re-design the airport experience”. Is there a goal for this re-design exercise? Some top goals that come to my mind are the following. Please guide me so I can set it and we can proceed from there. “Increase the number of passengers who travel to and from this airport” “Improve customer satisfaction” **“Get in"See full answer