Interview Questions

Brett a M. - "problem clarification how is FB Messenger measured right now?engagement DAU, WAU sessions duration & frequency feature adoption rates cross platform usage with other Meta apps are we talking about feature additions, performance optimization, UI/UX, integrations (on platform or off)? also is there a primary goal or business objective driving this improvement: engagement, retention, monetization, competitive positioning? are we thinking about all 1BB+ users? or a segment? timeframe? looking for"See full answer

Vicky X. - "4000"See full answer

Roshan K. - "1. Understand Your Audience\: 2. App Quality and Relevance\: 3. Educational Content\: 4. User Reviews and Ratings\: 5. Integration Partnerships\: 6. Community Engagement\: 7. In-App Promotion\: 8. User Training and Workshops\: 9. Email Campaigns\: 10. Feedback Loop\: 11. Incentives and Rewards\: 12. Analytics and Iteration\: 13. Partnerships and Collaborations\: 14. Measurement and KPIs\:"See full answer

Anzhe M. - "It's a 2Sum question with duplicate array elements."See full answer

Exponent - "This is another Strategy question, which means finding good reasons for strategic decisions. A few reasons for the GitHub acquisition are listed here. Competition > With the GitHub acquisition comes a lot of data on which companies are getting huge, or which technologies are cutting edge. Microsoft can adopt these technologies faster than others by having a pulse on this. It's also a defensive acquisition, since GitHub belonging to Microsoft means it can't be bought by Facebook or Google"See full answer

Alvin P. - "SELECT e1.empid AS manageremployee_id, e1.empname AS managername, COUNT(e2.empid) AS numberofdirectreports FROM employees AS e1 INNER JOIN employees AS e2 ON e2.managerid = e1.empid GROUP BY e1.emp_id HAVING COUNT(e2.emp_id) >= 2 ORDER BY numberofdirectreports DESC, managername ASC `"See full answer

Catherine T. - "We want sales to grow, in order to have a growth in revenue. And customer usage as well as it allows to see if our product lead more engagement from our users. So to be able to see this overall evolution I would make a line chart for both : Sales : with month on x-axis and sales revenue on y-axis Customer Usage : with month on x-axis and a KPI allowing to measure customer usage (nblogins or nbsessions or nbgamesplayed, ... depending on the industry) on y-axis Moreover, after knowing th"See full answer

Poha - "Design the cache, set policy like LRU or other custom policies."See full answer

Derrick M. - "SELECT u.id as user_id, u.name, COUNT(t.product_id) AS orders FROM users u JOIN transactions t ON t.user_id = u.id JOIN products p ON p.id = t.product_id GROUP BY u.id, u.name ORDER BY orders DESC LIMIT 1 `"See full answer

RestlessMonk - "Below data was given in a an excel. Data of 6 weeks, at a weekly level of COVID samples collected and tested Age Group, Population size, # tested, # positive, gender My approach: Tried to understand the trend of positivity rate of each group across weeks and cumulative level There is no variation across weeks, and each cohort exhibited similar pattern in all the weeks. So looked at cumulative data of 6 weeks. No clear goal/objective set by the interviewer for vaccine distributio"See full answer