Glassdoor 脸书 ds 近期汇总

Glassdoor:
1. Creation of Facebook user groups has gone down by 20%, what will you do?
The SQL questions were easy and I did answer them correctly- what kind of joins to get only common rows, what the natural sorting order etc
2. SQL - joins, group by, date manipulation
Business case - a mix of open ended questions framed like "how would you see if xyz is a good idea" and more specific questions about metric movements and experimentation
3. How would you create a model to find bad sellers on marketplace? How can you tell if your model is working? What metrics would you track to measure product success?
4. What is the difference between a left join vs. a union vs. right join?
5. I was first asked a SQL question followed by a strategy question regarding pricing.
6. how to predict samsong phone sales(not mentioned monthly or weekly)? how to predict churn rate? what is Recall metric, can you explain from scratch?
7. How to use data to confirm users’ high school data is real?
8. Tech assessment covered SQL, theoretical, and probability/stats.
9. On the functionalities that would be helpful in the creation of reactions on facebook.
10. How to define meaningful social interaction?
11. How can you prove your assumption?
12. Given a list of people with things that they own, find the people who have common items and what they are?
13. SQL related medium level questions
14. How to analyze the network on Facebook, how would you prepare the data, analyze it, and then questions followed
15. Perform a SQL join, AB test, case study, resume deep dive
16. How many orders of Fries does McDonald's sell in a year?
17. What's your favorite FB product and how we can improve it?
18. Given a table in SQL how would you do JOIN, COUNT DISTINCT etc
19. one is about product design: Facebook want to design a local refer page, how to use data. Another is about AB TESTING
20. Complex binary search question
21. Very very open-ended metric questions about Search and Events; - Easy SQL questions: Work on joins, count-case statements and basic functions
22. Describe a data and analytics project from past. Evaluate ML model. What is R squared, can it take negative values. Why do you remove highly correlated elements when they do not contribute or harm the model?
23. Make sure to define the steps and the metric you are interested in. How would you you solve the problem. AB Testing is one of the most importnat topic if you are interviewing in the Analytics area. SQL Questions on leetcode medium level
24. we discussed a facebook product about how to investigate the decreasing user problem and coding the simple SQL question. if you want to post the job through ins, how do you increase the conversion rate?
25. Facebook newsfeed product case (how would you measure of change X of newsfeed)
26. Did you ever do A/B testing?
27. But he ask me about some statistical formula, and I was not prepared for that (what is the t-test equation).
28. Our teams have developed an algorithm to detect spams and classify them at the bottom of the newsfeed. How to check if it works? If it's profitable?
29. I was asked a very open-ended question about how I would broadly analyze the drop of key performance metrics and 5 simple questions on SQL.
30. The last round was a quant round that revolved around Bayes' theorem, Power of tests, Type 1 error/type-2 error, and imbalanced classification. Intuitive explanations of the math were just as important as being able to solve the problems.
31. Provided a table with user_id and dates they visited platform, find the top 100 users with the longest continuous streak of visiting the platform as of yesterday.
32. Provided a table with page_id, event timestamp and a flag for a state (which is on/off), find the number of pages that are currently on.
33. If 10% decreasing in the post(FB, Instagram), as DS, what would you do? how would you improve notifications? how would you get Facebook users to download Instagram?
34. ML algorithms questions
35. How to evaluate the impact for teenagers parents join Facebook
36. How would you setup an experiment to understand feature change in instagram stories. How would decide to launch or not if engagement within a specific cohort decreased if all

您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

bout the data without clarifying.
89. Given a scenario X - figure out the probability of A, probability of A given B, etc. Draw out the distribution of users in scenario Y - figure out what the mean, median, and xth percentile is.
90. Given a table containing date, post_id, relationship (e.g. Friend, Group, Page), interaction (like, share etc.) and a table containing poster id and post id, calculate: how many likes were made on friend posts yesterday
91. If I am user xyz, calculate the average number of likes on my posts.
92. What would you consider to be a metric for meaningful social interactions for posts on the news feed? A metric better than just time spent/likes given
93. How would you do an A/B test on your new metric to see if it truly captures meaningful social interactions better?
94. A case study about email and phone confirmation
95. What would be a good click rate to aim for
96. 1- 3 to 4 SQL question from the employee department with join, and conditional selecting
2- Stat question(OLS, assumptions, t-test, F-test in OLS? Are they both necessary or redunt? what metrics can you use, R squared and probability, what are the problems with R2? How does maximum likelihood relate to ols? Under what condition they are the same? If it possible by adding a feature r2 to decreased?
3- Machine learning: logistic regression vs linear regression, what is decision tree, how does it select feature? How does it decide to which feature to select? random forest what is the 2 element of randomness? What is the kernel trick in SVM?
4- Given a list and a target value, how to find the 2 element that the sum of them is equal to target? Space and time complexity? How to improve it? How the dictionary works?
97. How would you explain a confidence interval to a business-person?
98. analytical (questions about AB testing and the properties of the binomial distribution)
99. what's the variance of the binomial distribution
100. Product questions - determine if something if a product is successful - ask probing questions, define success, define metrics, evaluate impact on metrics systematically. Stats questions - what do you expect the distribution of __ to look like - binomial distribution (expectation and variance), central limit theorem, repeated sampling.

太强大了，收藏了

谢谢楼主！！！！！！这个真的太强了 感谢整理！！！

太感谢了楼主

非常感谢 特别有帮助