高频题（0）
1. Predict DAU Curve from MAU Data
If the Monthly Active Users (MAU) curve has a bump period for 28 days, what would you expect the corresponding Daily Active Users (DAU) curve to look like?
2. SQL Query for DAU and MAU
Write a SQL query to calculate Daily Active Users (DAU) and Monthly Active Users (MAU) from an 'events' table.
3. Design a Data Refresh Strategy for DAU/MAU Calculation
How would you design a data refresh strategy for Daily Active Users (DAU) and Monthly Active Users (MAU) calculations?
4. Retrieve Users' Last Client ID with Accept Suggestion Action
Given two tables, one named 'events' with columns user_id, time_stamp, entry_point, activity_type, and another named 'client' with columns entry_point, client_id, device, write a SQL query to retrieve the last client_id for each user that performed an 'accept suggestion' action. Ensure to use a window function and join the tables appropriately to include the client information.
5. Practical ML Coding for POS Tagging
Implement a part-of-speech tagging model in Colab. This includes feature engineering, training the model, creating an inference function, and evaluating the model. Also, discuss what model you would use if you had ample time and were not constrained by the interview setting.
