Affirm数据相关面经_Affirm数据相关面试真题及高频题

1.Design a product

2.Checking Account for High school students

3.SQL Proficiency Assessment

4.Character Appearance Count

5.Design a Hit Counter

6.Shortest Substring

7.Most Letter

8.Find the Company with the Highest Occurrence in Lists

9.Implement Incremental Decision Tree Growth

10.ML System Design for Real-Time Loan Approval/Rejection

11.Data Preprocessing Exercise

12.Merge Database Logs

13.CSV File Filtering and Optimization

14.Decision Tree Problem

15.Implement Decision Tree Methods

16.Most Frequent Word

17.XGBoost Hyperparameter Tuning

18.Handling Imbalanced Data

19.Define F1 Score

20.Explain ROC Curve

21.Unique Substring Identification

22.Find the Highest Frequency Word

23.Settling Out of Sync Balances

24.Calculating End of Day Balances

1. Design a product

Design a product to find doctors for people who are moving to a new city; assume you are a brand new startup

2. Checking Account for High school students

Checking Account for High school students

3. SQL Proficiency Assessment

Discuss your experience with SQL and rate your SQL skills. Be prepared to provide simple examples of daily SQL use cases that can be understood by non-technical people.

4. Character Appearance Count

How can you find the characters that appear the most times in a given text?

5. Design a Hit Counter

Design a hit counter which counts the number of hits received in the past 5 minutes. The counter should support two functions: hit(int timestamp), which records a hit at the given timestamp, and getHits(int timestamp), which returns the number of hits in the past 5 minutes. Discuss how to handle concurrent requests and optimize space and time complexity.