a*******5 发帖数: 3 | 1 我对用户数据库model设计方面的面试题一点准备都没有。当时就跳过没做。分享这些
问题。并且向各位讨教这些题该如何抓住切入点解答? 非常感谢!
- Design a database schema http://en.wikipedia.org/wiki/Database_schema to be used internally for user analytics (ad hoc analysis and automated reporting) of its mobile applications.
- For a typical social network product, describe the logical data model for
related fact and dimension tables, the aggregation tables you'd want to
build for analytics, and the dashboard you'd build to monitor the product.
- How would you build a state transition model to track the state of our
advertiser?
- How would you build a model to determine 1yr and lifetime value per user?
- What KPIs would you define to measure the engagement of a cohort of our
users? What levers would you build to help improve the KPIs? |
|