Interview Questions

Kartikeya N. - "Clarifying questions: What level of retention are we targeting?: 30/60/90 day?: 30 days retention Do we have any user geography in mind?: No, lets talk global How do we define 30 day retained user? : Any user who comes to the app once in 30 days to do something meaningful How much is the current retention and how much do we want to increase it to?: Lets aim to 2X the current retention in an year Lets start with the Goal of the Adobe Scan app. Its goal is to allow users to capture im"See full answer

Chelsey V. - "Suppliers have an interest in the purchase of inputs by the company. They want companies to pay on time"See full answer

Robert H. - "I use ChatGPT a lot to either refine my own answers or stories and make them better, or to answer questions which I would then refine to be more personal to me. Here's what ChatGPT says about this question: This question is testing your analytical thinking, data-driven decision-making, and product sense—especially in the context of Meta’s focus on engagement and content ranking. The best approach is to **define key engagement metrics, outline an experiment design, and consider trade-of"See full answer

Brandon C. - "We can start by considering the key components: waiters, tables and customers. We'll need a database to store information about waiters, tables and customers, each waiter can have a unique ID and we can track the. number of tables they are servicng. Tables can have attributes like table number, capacity, and current status. Customers can be tracked by their arrival time and party size. we can calculat ethe expected waiting time bu considering the average time a table is occupied and the number o"See full answer

Ekta M. - " Why do we want to increase the price? How much do we need to increase? Is it tied to some kind of revenue target? What is the region in which price needs to be increased? - Say India Who are the major players in that region who offer similar services and how are they priced? Will the users switch to those competitors? What is our unique proposition for retention? Do we have any leverage against them which will stop the users from churning? Any change in pricing or anything major like terms an"See full answer

Greg Y. - "Thanks for interviewing me!"See full answer

Jaime A. - "I might be missing something but the solution, seems to be incorrect. ... , post_pairings AS ( SELECT ps.user_id, ps.postseqid AS failpostid, ps.postseqid + 1 AS nextpostid FROM post_seq AS ps WHERE ps.issuccessfulpost IS TRUE ) -- here ps.issuccessfulpost IS TRUE the condition should be FALSE -- in that way ps.postseqid is the actual failed post(failpostid) -- Additionally, at the end the join is assumming that the sequence id is going to match the post_id, wh"See full answer

Mark G. - "Situation: At my previous company, we had more than 200 different data sources across 15 business units. These included CRM systems, marketing platforms, HR databases, and even third-party data feeds. The problem was that each team was managing data in its own way. This created inconsistent privacy controls, data quality issues, and compliance gaps, all of which were becoming urgent ahead of a major regulatory audit. Task: I was given the responsibility of implementing a unified data governance"See full answer

Zelda M. - "Yes, acted as relieving Training and Development Officer on numerous occasions. I then was responsible to oversee the admin department's duties and responsibilities."See full answer

Anubhav A. - "Clarifying question: Do we want to judge need of an existing product or an idea that can be converted into a product Let me solve for both the cases. Q: Determine if there is a need for a platform that is already live and has some users. While thinking about need, I am finding it resonating with "Does this product have a pmf". Few ways to do that: Take a look at the retention number (D1, D3, D7 and D15). Basis on the product the time range can be different but if the retention number is"See full answer

Hl M. - "Clarifying Slack is a mature product in markets with millions of users B2B platform Expand customer base to school boards SWOT Technology is mature and well reputed Good privacy practices Threats Google school Microsoft learning education Zoom Journeys User Users for slack - for - school School boards 12 school boards Primary Secondary High Universities - Remote learning / Distant educations - Incumbents MooCs - Existing platform End Users: Students Teachers Administrators Ed"See full answer

John F. - "First, I would like to establish some assumptions about the problem to determine if this is possible. For this scenario, I will assume that “accepted” does not mean a student is enrolled at the university (most students apply to multiple universities and can only attend one university). For simplicity, I will also assume that each student is applies to a single department and that every student is associated with a single department. Based on this information, I see a scenario that this would"See full answer

Ban N. - "Follow news and resources via conferences or top companies' blogs, such as NeurIPS 2023 or Google Research Blog to get updates about the machine learning landscape. Research the papers on the new technology or approach that was mentioned or introduced via the subscribed sources, such as listed above. Following media channels, podcasts, or influencers on social media who were recently active in the industry to catch up with the trending and valuable insights, research, thoughts... Scan Github"See full answer

VictorSage - "The critical data to forecast projects with greater accuracy are Remaining Estimated work, Customer needed date, Cost of Delay."See full answer

Praful B. - "It could make Gmail less accessible to people who cannot afford to pay for it. It could lead to users switching to other email providers. It could damage Google's reputation as a company that provides free services."See full answer