Interview Questions

Lucas G. - "I would conduct a sample z-test because we have enough samples and the population variance is known. H1: average monthly spending per user is $50 H0: average monthly spending per user is greater $50 One-sample z-test x_bar = $85 mu = $50 s = $20 n = 100 x_bar - mu / (s / sqrt(n) = 17.5 17.5 is the z-score that we will need to associate with its corresponding p-value. However, the z-score is very high, so the p-value will be very close to zero, which is much less than the standa"See full answer

Davide P. - "Microsoft's mission is to empower every person and every organisation on the planet to achieve more. I am always inspired by helping others to achieve more by participating to different volunteer and mentorship experiences like Microsoft Student Ambassador, and GeeksForGeeks student ambassador, and I have also created and shared a free competitive-programming guide which once reached more than 700 stars on github, that enables students and professionals to join Microsoft like Microsoft, that hav"See full answer

Chantal C. - "Understand gaps team by interviewing on 1:1, reading past performance reviews and talking to old managers/cross functional Identify Goals and use the SMART framework to set those goals (Specific, Measurable, Attainable, relevant, time related) Share with team and make sure they understand them. Clarify questions if needed. Explain WHY these goals matter. Tie to company goals/mission/culture. Put together an action plan TOGETHER- give often feedback: "pinches no punches"See full answer

Nayla D. - "Instagram is social media app where you can share photo and video to others. Impressions is an important metrics to track because it shows how many contents that users see. Clarify Questions: Is this drop happen suddenly or gradually? - Gradually How long has it been happening? - Last 3 months Is it happen globally or in certain region? - Globally Is the drop happen to all user segments (age, new/existing, active/less active users)? - all user segments When calculating an impressions,"See full answer

B. T. - "You are given a string S and a number K as input, and your task is to print S to console output considering that, at most, you can print K characters per line. Example: S = "abracadabra sample" K = 11 Output: abracadabra sample Note that this problem requires the interviewee gather extra requirements from the interviewer (e.g. do we care about multiple white spaces? what if the length of a word is greater than K, ...)"See full answer

Mahesh L. - "Preparing for a significant security compliance change can be overwhelming. The most efficient way to achieve GDPR compliance is through interdepartmental collaboration and the use of technology solutions that automate and validate business needs such as policy compliance, data security and required reporting. As the deadline looms, most organizations should already have started assessing the business impact, devising a company-wide implementation plan and addressing additional resource needs. E"See full answer

Gaurav C. - "Clarifying Questions: Do we have any specific goal in mind for this new product, for example targeting new audience, expansion to new places , catering to new need etc. · I am going to assume targeting new audience Do we have any constraints? · No constraints When you say restaurants does it mean casual restaurants, pubs, food joints 5 star hotels etc. · I am going to assume all kind of restaurants who have already registered there establishments on Swiggy Structure User Segme"See full answer

Ankit J. - "Clarifying questions: What is the motivation for Airbnb to consider entering furniture space? Assumption: Data suggests the quality & type of furniture has a direct impact on guests’ Airbnb experience. Many hosts are also converting their Airbnb’s into full-time businesses, so there is a revenue opportunity here while improving the experience. Is Airbnb looking to feature furniture listings on Airbnb.com? It’s still TBD. We want to know if it’s a good idea first. Are there any other g"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

Alina G. - "-- Write your query here WITH high_value AS( SELECT user_id FROM user_sessions JOIN attribution ON usersessions.sessionid = attribution.session_id GROUP BY user_id HAVING SUM(purchase_value) > 100 ORDER BY SUM(purchase_value) DESC ) SELECT usersessions.userid, marketing_channel FROM user_sessions JOIN high_value ON usersessions.userid = highvalue.userid JOIN attribution ON usersessions.sessionid = attribution.session_id GROUP BY usersessions.userid H"See full answer

Jack F. - "The project manager must take care of the risks associated with the particular project. Scrum Master is a team facilitator and serves as a servant leader. The product manager serves as a team leader and is responsible for project performance and ensuring that everything goes according to plan."See full answer

Raymond W. - "Clarifications/assumptions - we're only interested in opening and closing hours, not serving times e.g. breakfast or lunch time format etc will be local only interested in regular hours not special holiday hours Potential users/data providers (ranked by order of authority) Businesses/Advertisers Consumers Google Goal Coverage Prioritising the most popular restaurants, or those who are willing to invest in advertising Accurate, but conservative - better be wrong to"See full answer

Ben G. - "Ask Follow up Questions Is this for specific type of user or open? Do we have any past research that has been done? Do we have an idea of company and user goals? Do we have metrics of success? Are there any existing constraints? Why  |  5 min Why is this product or feature important? How does this product benefit customers? What business opportunities does it create? What is our hypothesis? What are our company goals? Who  |  3 min Who are the different types"See full answer