Interview Questions

Dhruv M. - "During my internship at Datavibe Insights, I was initially brought on to assist with routine data cleaning and Excel reporting for the procurement team. My main task was to support weekly report generation, but I noticed inefficiencies in how data from multiple vendors was being manually compiled and formatted each week. Without being asked, I took the initiative to build an automated reporting tool using Excel Power Query and macros. It cleaned, merged, and visualized the data with a few clicks"See full answer

Catherine Z. - "Clarifying Questions Have we confirmed this was a server side issue and not client side or network related? Interviewer confirms this was a server side issue Do we have additional information on whether this was region specific, user specific? Interviewer says you can make some assumptions Introduction I am going to focus on a few potential factors and describe how they could lead to system downtime: Data Center Power Outage Software Deployment Software Bug P"See full answer

Rick E. - " from typing import Dict, List, Optional def max_profit(prices: Dict[str, int]) -> Optional[List[str]]: pass # your code goes here max = [None, 0] min = [None, float("inf")] for city, price in prices.items(): if price > max[1]: max[0], max[1] = city, price if price 0: return [min[0], max[0]] return None debug your code below prices = {'"See full answer

Sharad K. - "If I had a fitness product that saw a significant drop-off in users after 3 months, I would focus on several key strategies to improve user retention: 1. Optimize the Onboarding Experience Ensure that new users are guided through a simple, intuitive onboarding flow that helps them quickly experience the core value of the product. Provide personalized recommendations based on their goals and fitness levels. Celebrate milestones and encourage users to make their first few visits. 2."See full answer

Anonymous Flamingo - "As a YouTube PM, there are several factors that I would consider when evaluating the idea of developing a tool for content creators to generate ideas with scripts automatically added. First, I would assess the potential demand for such a tool among YouTube content creators. This would involve researching the needs and challenges of content creators, as well as gathering feedback from content creators on the value and usefulness of the tool. This would help me understand whether there is a strong"See full answer

Riku H. - "Great question - this is similiar to the "should uber go into rides for kids?" type of question so it's mostly strategy but also part design the way the question is phrased. Purely design would be " Tell me how you would build uber for kids" Assumption here is Uber in India functions the same as anywhere else in the world, is that correct? Yes, but in India they also take cash payments OK, what about safety regulations like car seats? (needs clarificaitons) What about driver licensing in Ind"See full answer

Kanishkan V. - "I responded with a project that I was a part of during my capstone class. I described how I used HTML, Python, and PostGRESQL in conjunction to create a functioning website using SCRUM."See full answer

dungeonMaster - "Objective: Migrate from subscription base business revenue model to ads based revenue model. Continue with subscription base revenue model, showcase ads on platform only. (Not in between the content). Continue with subscription base revenue model, showcase ads on platform and in between content. Provide different monthly plans based on with ads or without ads Increase revenue by X% - Decide based on this object what revenue model to accept. Assumption: Netflix wants to continue"See full answer

Rohan S. - "Honestly, I would’ve loved something like this when I was younger. I couldn’t wait till the day I was 18 so I could start investing and would read personal finance books on random topics. Clarification Questions Kids is a very broad term, is there a specific age range you had in mind or would you want me to determine that myself? > I will assume that this will start off as an application, and then later can be integrated on a"See full answer

Bhavna S. - " with youngsuccrate as( select strftime('%m', postdate) AS postmonth, round(sum(issuccessfulpost)*1.0/count(issuccessfulpost),2)as yascrate from post where userid in (select userid from post_user where age between 0 and 18) group by post_month ), nonyoungsucc_rate as( select strftime('%m', postdate) AS postmonth, round(sum(issuccessfulpost)*1.0/count(issuccessfulpost),2)as nonyasc_rate from post where user_id in (select"See full answer

Anonymous Giraffe - "this is not a helpful interview, she seems so unprepared, confusing, unable to netting it out :("See full answer

Anonymous Jellyfish - "Thank you for the question! Normally, I would want to ask some clarifying questions to try to better understand the scope of the problem. Below are some of those questions & assumptions I am going to make because I need to submit an answer without getting a response. Question 1: What is Facebook’s north star metric for this exercise? Growth? Engagement? I’m also keeping in mind that because we are talking about building a birthday feature in the earlier stages of Facebook, their north s"See full answer

Greg W. - "Clarifying Questions: Is this for business travel, personal travel, or both? Are there any particular objectives that we want to focus on? Think about why Facebook would want to do this is it because they are thinking about building an external-facing travel product, and want to test it on Facebook employees first? Facebook employees work hard, so they want to make sure that their employees are taking the vacations they need to optimize performance List user types employees trav"See full answer

Kim L. - "Explore expanding beyond just two small roooms-- bigger rooms or a third room? Get insights from those who are teleporting about what the experience is like"See full answer

Kartikeya N. - "Clarifying questions We are referring to Facebook here within Meta products, correct?: Yes Can we base the CAC as of 2025?: yes Facebook acquires users through multiple channels, are we focussed on any particular channel? : We are looking at an overall CAC for Facebook What all do we want to include in CAC? Can we limit it to the marketing and advertising costs and leave aside technical, infrastructure or people costs?: yes Here’s how I will calculate this. **Customer acquisition c"See full answer

Sean L. - " import pandas as pd def findaveragedistance(gps_data: pd.DataFrame) -> pd.DataFrame: #0. IMPORTANT: get the unordered pairs gpsdata['city1']=gpsdata[['origin','destination']].min(axis=1) gpsdata['city2']=gpsdata[['origin','destination']].max(axis=1) #1. get the mean distance by cities avgdistance=gpsdata.groupby(['city1','city2'], as_index=False)['distance'].mean().round(2) avgdistance.rename(columns={'distance':"averagedistance"}, inplace=True) "See full answer

Shawn S. - "Context: As a people manager, my biggest thing is to foster psychological safety for my team members and the way I do that: building rapport between me and my direct reports, weekly team meetings I ensure all voices are heard, have people share about themselves and encourage them to get to know one another. Team members had a good understanding of each other’s working style. One of the recent projects my team was responsible for building out the espresso test framework on android. This was"See full answer