Interview Questions

Arthur Y. - "Clarifying Questions: By “down”, do we mean creation of messages (activation), engagement, or both? My assumed answer: engagement How are “messages” defined? Is it comments to posts, DMs, or posts themselves? My assumed answer: DMs How is engagement of DMs defined? Is it by number of DMs viewed, created, replied to? My assumed answer: all of that Quick Product Strategy Discussion: Why messaging is important to LinkedIn LinkedIn’s mission is"See full answer

Anonymous Hummingbird - "Q: should this be part of FB or a standalone product? A: no hard requirements, it just has to be something that FB would launch Q: is there a specific region we should be designing for? is it ok that we focus on the US as its the current epiccenter of the pandemic? A: Yes that's fine Q: fighting covid-19 is a very broad goal, what if we translated this into decrease the spread of covid-19 - there's multiple ways we could do that but it makes it a bit more concrete. A: Yes that sounds good "See full answer

Anonymous Sparrow - "To make sure we are on the same page, this is a feature in the current FB app that would make it easier for people to volunteer? Or more broadly, the feature would aim to expand the base of volunteers. To start I want to dive deeper on the objective of the feature. Then we can look at possible users, pick a segment and outline their needs, then look at some solutions. We can then prioritize and see how we might roll something like this out. If I look at FB mission of building community and brin"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

Aldar M. - "/my initial thought was to make an example with program integration project that I led a few years ago Stage 1: Project Planning. The first stage of SDLC is all about “What do we want?” my approach was simply take project life cycle structure(initiation, planning, execution, monitoring and controlling, and closure) and elaborate on each stages did i. I lack a details and Excell skills and I should have taken SDLC structure because I fits better with JD. Stage 2: Gathering Requirements & Ana"See full answer

Pathworks P. - "I would begin by asking the following clarifying questions: Are there any special use cases such as VIP Penthouse access, restricted floors etc? Do we need to consider safety requirements or other technical constraints such as maximum load/capacity? If the lobby for the entire hotel located on the ground floor? Can we assume that the majority of the guest amenities are located near the lobby and lower floors? Can we assume that the passenger controls on the floors are purely directional"See full answer

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

P K. - "Clarifying questions, Before I begin, I want to make sure I understand what the product is. FB fundraiser is a platform for entities (charitable organizations) and individuals to create fundraising campaigns, invite certain users to it, share it with others and ask them to invite potential contributors to it. It is also part of the core facebook product. The approach I want to take about defining goals is as following: Define the mission of FB as a company, goal of fundraiser p"See full answer

Meenakshi sundaram M. - "Structure: 1. Ask Clarifying Questions 2. Look at external factors 3. Look at Internal factors ( Slice the data aross different cuts and plan accordingly) Clarifying Questions: What's an outbound message? Is it something Linkedin users send among each other? Decline trends: Is the decline steep or gradual? From when, are we seeing this decline (Say since a week, fortnight, month, etc) External Factors: Have we seen any competition led changes/ new campaigns etc? Have we see"See full answer

Dan H. - "Assumptions Instacart for Business is core Instacart with additional features and capabilities tailored to businesses. Users Potential user segments: Office managers (Focus here) Entrepreneurs/small business owners Restauranteurs Opportunities (pain points, needs, problems) Many places don’t offer same-day shipping. Inconvenient to physically go out and purchase these items from a store if urgent Hard to predict an"See full answer

Snighdha G. - "By showing results that I have achieved by taking that action because seeing is believing. For example, when we had issues with our child's behavior and wanted to understand what as parents we are doing wrong, we went and sought help from a specialist and similarly advised same to others having some form of mental health issues to seek help since we benefitted with it a lot."See full answer

Pm P. - "Clarification: Are we talking of Amazon as an entity in whole (or) Amazon E-commerce ? I would like to use overlap across following buckets with emphasis on current product & markets, Future adjacencies and expansions, strengths barrier to entry in the markets either way Amazon Intuit Products - Considering Amazon as a whole - Devices - AWS - E-Commerce - Music - Video - E-Books - All other services, currently there is no overlap between the use-cases and services offered"See full answer

Adhitya G. - "Clarifying Questions: Product → It is a online Professional Services platforms where jobs are made much easier for both recruiters and for job-seekers Goal → Increase Number of Users/ Any other Business Goal? Mission → It is to make job-posting/seeking completely hassle free and accessible to everyone. Do we have any timeframe to do this and is there any growth rate that I should be targeting? - 5x in 5 years Students → Are we focusing on Full-time or Part-time students? Any"See full answer

Miguel C. - "Missing launch. Only design is covered."See full answer

Bini T. - "I understand this is more focused on ML. However, I have a system question. If users allow us to access their location, or they send location via text box, could we use CDNs for the search without hitting our database? We only query the database when we have zero information on location. Other questions: does embedding always guarantee information on location? Do we discharge the user images after we return a prediction? I heard the feedback that we should keep it for future learning. What would"See full answer

Scott S. - " A couple of years ago, we were working on a project to integrate a new third-party data feed into our existing data processing pipeline. This data feed was critical for enhancing our trading algorithms with more comprehensive market data. Given the tight timeline and high stakes, I decided to push for a rapid implementation. In my eagerness to meet the deadline, I underestimated the complexity of integrating this new data feed. I did not allocate sufficient time for thorough testing and valida"See full answer

Dan D. - "I love the answer and framework, my summary of the interview: it is a slightly modified version of Porter's 5 Forces: User benefit -> Bargaining Power of Buyers Apple benefit -> Talks about the company mission and culture (esp. on the relatively closed eco-system) It was expanded more in the latter half of the interview (SWOT + a bit of Value Chain) Competitive landscape -> Industry Rivalry + Threat of New Entrants + Threat of Substitutes Partnership Impact -> Bargaining Power of"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

Dhruv M. - "During my internship at Inceptra Analytics, our team was working on improving the monthly reporting process for the operations department. I proposed switching from manual Excel reports to a Power BI dashboard to automate and visualize key metrics. However, some team members were hesitant—they felt the current process, although tedious, was more familiar and controllable. My task was to get buy-in from the team to adopt a more efficient reporting method without causing disruption or resistance."See full answer

Reno S. - "1. Requirements Analysis Functional Requirements Video streaming with multiple quality levels Content browsing and search Continue watching functionality Content recommendations Non-Functional Requirements Low latency video delivery (<2s startup time) High availability (99.99% uptime) Scalability to handle millions of concurrent streams API response time < 100ms 2. Microservices Architecture Core Microservices Content Service Content metadata mana"See full answer