Interview Questions

Bradley E. - "Here's a simpler solution: select u.username , count(p.postid) as countposts from posts as p join users as u on p.userid = u.userid where p.likes >= 100 group by 1 order by 2 desc, 1 asc limit 3 `"See full answer

Harshit G. - "Great question. My favourite product is YouTube Music. Let's see on what its strategy should be for next year. Clarifying questions No clarifying questions on this as I will be working with my favourite products. I will have few assumptions which I will state out before we proceed. Assumptions Assuming that we need to come up with strategy for YouTube Music app - not considering YouTube as a whole as part of this. I am considering overall audio streaming as the space to come up with the s"See full answer

Tamil selvan R. - "May I know which tool is being used to draw flow diagram?"See full answer

Qusai B. - "Assumption: I’m estimating the minimum number of trains required to fulfil maximum demand I’m including all trains that’s serving NYC Formula: Before I state my formula, I would like to mention a few things I will be calculating the number of trains required to fulfill all demand at the peak time during a workday. I assume peak time lasts for 2 hours I’m assuming that a train takes 2 hours to complete one roundtrip on its route, which means any given train can service rider"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

Talles S. - "Me: First, let's design our product and then we will calculate the estimated amount of units sold. Before we begin, is there anything specific about this refrigerator, is this a 'smart refrigerator'? Interviewer: Yes, you can consider this is a smart refrigerator but the overall design is up to you. Me: Thank you, one more question, do we have a specific user in mind? Younger people? Retirees? Interviewer: No, you can select the user base based on your prioritization, but theoretically it cou"See full answer

BePostive - "For me the answer looks very broad and general. It would be good the reply is relevant and focus good examples using STAR format. Please let me know your views."See full answer

Eshan P. - "Background A. Objective Lyft has a presence in Toledo, Ohio. At our current revenue per ride of $6, we can match 60% consumers requesting a ride with a driver. Our goal is to maximize net revenues in the next 12 months by figuring out the optimal revenue per ride. B. TLDR Summary · With a target market of (~100K-138K) consumers, on a $25 charge to consumers, Lyft should pay $20.75 to drivers and fix its share at $4.25 to maximize its net revenues over a 12-mont"See full answer

Shashikant A. - "I followed STAR format"See full answer

Anonymous Cat - "Good practice video; however, at minute 6:40 in this video, the interviewer confirmed the app version causes no issue! While the final answer was the app version!"See full answer

Vysali K. - "Limit and rank() only works if there are no 2 employees with same salary ( which is okay for this use case) For the query to pass all the test results, we need to use dense_rank with ranked_employees as ( select id, firstname, lastname, salary, denserank() over(order by salary desc) as salaryrank from employees ) select id, firstname, lastname, salary from ranked_employees where salary_rank <= 3 `"See full answer

Christopher K. - "Clarifying/Requirements House hunting is something I'm familiar with as someone who has rented, owned, and invested in the past. When I was looking for a place to live, the stage of where my life plays an important factor in determining how I look for a place. Before I start, I would like to ask some clarifying questions for better context and understanding. Did FB release any app related to house hunting - No, this would be a completely new feature. Will this be a stand-alone or"See full answer

Ben G. - "Situation - A situation where I used creative / innovative thinking to eliminate frustration with a product was while I was working on Point of Sale and Polaris for Retail Design System for Shopify. Upon seeing our vision for the future of this design system, it lacked a lot of the visual polish and necessary components that would make the product much more competitive in the market - this included having a lack of an interaction model for what is tappable vs. not tappable as well as containmen"See full answer

Anonymous Hummingbird - "Clarifying questions: Q: So FB locals is a standalone app that has reviews of local businesses? What is the current state of the product? A: Yes. It recently relaunched and branded. Facebooks mission is to connect people and help them build community, FB local fits into this by using the power of the large social network to surface businesses and events and uses signals such as reviews to build trust and provide value. So its of the utmost importance that the reviews are authentic. Goal: I"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

Harsh W. - "Me: That's an interesting challenge. I would like to get some clarifications before jumping into potential solutions. Are we talking about the global search market irrespective of device or are we talking about a specific geography / device type? Interviewer: Lets go ahead with all possible searches. Me: Ok. Is there a specific reason we want to capture a significant market share from Google (e.g. higher search revenue, cross-selling MSFT services etc.) and are there any timelines we should k"See full answer

Rustam - "There are number of ways where an app could lose users. I would try and speak with the following teams to figure out the issue. Data Team - I'd ask data team to see if there are any drops in the existing game funnels. There could have been an issue in game design. Potentially players could have gotten stuck on a super hard level and left or flew through a puzzle that was too easy, and also left. Essentially, figuring out the progression curve of the game, which often times can lead to play"See full answer

Anonymous Panda - " Communication between Mars and Earth is facilitated through various methods and technologies. The primary means of communication is through the use of space probes, particularly those equipped with powerful transmitters and receivers. Here's a general overview of how communication between Mars and Earth works: Deep Space Network (DSN): NASA operates the Deep Space Network, a global system of radio antennas located in California, Spain, and Australia. These antennas are responsible for sending"See full answer

Takashi M. - "Me: First of all, I’d like to have some clarification about this project. Me: What is the current product line design of the vending machine? Is this a traditional vending machine? Customers pay money cash or credit card, and select products and receive the product. Interviewer: Yes, that is the correct assumption. We make vending machines for canned drinks and bottled drinks. Another product line is for selling small packaged snacks. Me: What is the goal of this project? Is"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