Interview Questions

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

Usman B. - "System Components Data Collection Layer Posts with hashtags are asynchronously sent to Kafka topics Each message contains: hashtag, timestamp, userid, postid Multiple Kafka partitions ensure scalability and fault tolerance Processing Layer Apache Flink processes streams in real-time Implements sliding window aggregation (1hr, 24hr, 7d windows) Calculates topic popularity using weighted metrics: Post count User engagement (likes, comments) Unique user"See full answer

Mark - "Questions: Should we consider US or Global? Is there any existing market insights/research around driverless cars adoption? Can we assume that driverless car technology is production / public ready by 2025? Is this focus on commercial or consumer use? Assumption: Let's look at US to start for our estimation since Driverless car regulation and adoption trend will probably differ per country Let's also assume we want to estimate market size for driverless cars in 2025 for consume"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

Jay K. - "First, let’s discuss why this is important for any platform business Think of platform businesses like Amazon or YouTube as matchmakers. They connect people who want something with those who provide it, whether it's products or content. But here's the catch: users trust these platforms to make sure they're getting good stuff. They want genuine products, safe content, and no scams. So, platforms need to be like guardians. They check suppliers and content creators to make sure they're not"See full answer

Bala G. - "WITH ActiveUsersYesterday AS ( SELECT DISTINCT user_id FROM user_activity WHERE activity_date = CAST(GETDATE() - 1 AS DATE) ), VideoCallUsersYesterday AS ( SELECT DISTINCT user_id FROM video_calls WHERE call_date = CAST(GETDATE() - 1 AS DATE) ) SELECT (CAST(COUNT(DISTINCT v.userid) AS FLOAT) / NULLIF(COUNT(DISTINCT a.userid), 0)) * 100 AS percentagevideocall_users FROM ActiveUsersYesterday a LEFT JOIN VideoCallUsersYesterday v ON a.userid = v.userid;"See full answer

Jasmin R. - "Let's imagine you want to open Google Maps, you type maps.google.com and hit Enter. Here is what happens: You type maps.google.com into the address bar of your browser. Browser completes the address, for example, maps.google.com → https://www.maps.google.com [Address decoding] → browser breaks down the URL into parts ‘https://’: protocol → how the browser should connect to the website Default is HTTP (Hypertext Transfer Protocol) which shows up as ‘ http:/"See full answer

fuzzyicecream14 - "1. Sales & Revenue Metrics Total Units Sold – Tracks overall headset sales volume. Revenue Growth (%) – Measures whether revenue is increasing from headset sales over time. Sales by Channel – Identifies how sales are distributed across Google Store, third-party retailers (Amazon, Best Buy), and carrier partnerships. Sales by Region – Helps understand geographic demand and refine regional marketing efforts. Attach Rate – Measures how often the headset is purc"See full answer

Karthik R. - "Good Discussion on the distributed messaging queues (Complex topic with lot of nuances) Liked the mind-map style drawing of requirements and metrics capture Touched on different types of queue styles (point to point, pub-sub, fan-out/fan-in) Storage and WAL usage was interesting Some distributed queue challenges that could be helpful to highlight / expand are: Message guarantee / semantics - Ordering of messages across different servers Replication Master slave architecture or Pe"See full answer

Kartikeya N. - "Clarifying questions: What city/ country are we talking about? Indian metro. What all counts as a grocery store? Do have to cover dark stores as well which are not open to public? Only consider all grocery stores where public pick up is allowed. Do we have to include hyper markets/ super markets as well or only smaller stores? Include both. Okay, so I would be considering the Indian metro of Bangalore here. The overall equation is , **total number of grocery stores = Number of small grocer"See full answer

דניאל ר. - "Implemented a recursive function which returns the length of the list so far. when the returned value equals k + 1 , assign current.next = current.next.next. If I made it back to the head return root.next as the new head of the linked list."See full answer

Umang S. - "Context - I joined a large public-facing service as a PM midway through its development. Situation - Due to the SOPs of the company the team already had a metrics framework. That included your standard DAUs, Retention and Acquisition Metrics Concern - As SOP metrics were publicly accepted, the team did not internalise what success actually means to the product they are developing, as the actual value was not being encapsulated in the framework This was evident in the show and tells as the"See full answer

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

Steven M. - "Clarifying questions: I assume we're focused on the consumer side of this? ** Yes I am assuming post booking begins immediately after booking a ticket and ends when the user leaves the airport at their destination. Does that sound right? ** Yes Goals: United Airlines wants to get its passengers to their destination seamlessly, safely, and on time. Users: I think about user groups in 3 main buckets. 1) 24 hours following booking 2) >24 following booking through 24 hours before boarding "See full answer

Ash J. - "Clarify: I will assume that misinformation includes posts, videos and pictures and that sources could be Groups/ Pages and Individuals. High level structure: Mission, Information funnel and drop-off points, Metrics & Trade-offs, Mitigations Mission/ Strategy: Facebook's mission is to bring the world closer together and empower people to build community. Reliable information is key to fostering a healthy community. In light of recent world events and public sentiment, it is important f"See full answer

Hans - "Described a scenario where I joined an established project as an EM Typical medium sized team - 6 devs, 2 testers, PO, PM (part time) Scrum master (very hands off) The product was well established and already being used by circa 30000 single country based users for the companies own products (personal banking capabilities) We were due to go live with a BIG change about 2 months after I joined - this change meant a user could manage multiple personal banking accounts from the 1 interface. We w"See full answer