Yesterday I just took the students to brush the latest set of Point72 Quant OA, the actual situation of this student is: all three questions were AC in 25 minutes, and the remaining time was mainly spent on boundary checking and code optimization. So if you are still wondering whether to prepare, we can say it clearly here - this set of OA is more like "screening basic coding skills", not hardcore quant difficulty.
Point72 Quant OA Basic Information
- Platform: Generally HackerRank/CodeSignal
- Duration: 120 minutes
- Number of questions: 3 questions
- Difficulty: Mainly Medium
Question 1: SQL Query Students and Departments
Question requirements:
Query the name of each department and the number of students in that department, including departments without students. The query results are sorted in descending order by the number of students. If the number of students is the same, they are sorted in ascending order by the name of the department.
Problem-solving ideas
Use the DEPARTMENT table as the main table to perform LEFT JOIN to connect the STUDENT table, so that even if there are no students in a certain department, they will not be lost; after the connection, they are grouped according to the department, use COUNT(student.id) to count the number of students in each department, and finally sort according to the number of students in descending order. If the number of students is the same, then sort by the name of the department in ascending alphabetical order.
Question 2: Python object-oriented library items
Question requirements:
Create a base class Item,Include Title,Author,Year Properties, implementation __str__,__repr__,Display_info().
Create subclass Book(Increase Genre,Isbn),DVD(Increase Duration).
Problem-solving ideas
Define the base class Item, including title, author, and year attributes, and implement __str__, __repr__, and display_info. Book and DVD inherit and extend attributes (genre, ISBN, duration), and rewrite display_info to add unique fields. The magic method is used for console-friendly output and debugging representation, with a constraint of ≤50 items. The overall class inheritance structure is clear and information is displayed polymorphically.
Question 3: Python Mixin class
Question requirements:
Create DictMixin Supply To_dict(),create JSONMixin Supply To_json(), only includes attributes that do not begin with an underscore.
Problem-solving ideas
DictMixin traverses self.__dict__, filters out attributes starting with _, and constructs a dictionary to return. JSONMixin reuses to_dict and calls json.dumps. If the serialization fails, an exception is caught and a TypeError is thrown. The mix-in class is independent, has a single responsibility, does not rely on specific subclasses, improves code reusability, and handles universal conversion of objects to dictionary/JSON.
Question 4: SQL Cryptocurrency Portfolio
Question requirements:
Calculate the total value of each currency, and select the top 5 highest value Coin and Token respectively. Results are sorted by ascending type and descending value.
Problem-solving ideas
Joint table query: associate cryptocurrencies from holdings, and use case statements to generate "Coin/Token" based on the type field. Calculate unit_value * quantity as total_value, keep two decimal places and add $ prefix. Sort by crypto_type in ascending order and total_value in descending order, and take the top 5 respectively to implement window function or subquery filtering.
Some thoughts and recommendations
The main time of this set of Point72 Quant OA is spent on boundary condition checking and code structure optimization, especially the two questions of OOD class design and Mixin, which need to be written clearly. When helping many students sprint for similar OA projects, I found that many people easily lose points in platform operation and code specifications. If you are preparing for OA in Point72 or other Quant positions, welcome to come to ProgramHelp. We provide HackerRank, CodeSignal and other platforms OA professional writing service , all test cases strive to pass 100%, no fee will be charged if they fail; there are also real-time VO assists, and senior students with a North American CS background will give online ideas.
Students who need OA assistance, ghostwriting or interview support are welcome to contact us at any time and let’s sprint to the next goal together!
