Just finished it in February Point72 Online Assessment, the overall feeling is: the question itself is not particularly difficult, but the format and implementation details are very time-consuming. The whole session only lasted 40 minutes, but I had to complete 4 questions. The pace was quite fast. Fortunately, I finished writing and submitting them successfully in the last few minutes. Spring recruitment has heated up significantly recently, and many quantitative and financial companies have successively released OA at a faster pace than in previous years. If you plan to invest in this type of company, it is really important to familiarize yourself with the question types in advance. Let’s review this new set of questions in full while the memory is still fresh.
Question 1
Build a library catalog management system by implementing base classes Item And its subcategories Book And DVD, to practice inheritance, method overriding and __str__,__repr__ And the use of magical methods.
Idea for the first question: The auction query question needs to count the number of bids and the current price of each product. Use a left join to associate the product table and the bid table. After grouping, calculate the total number of bids. The current price is equal to the starting price plus the bid step multiplied by the number of bids. At the same time, a subquery is used to obtain the username of the buyer who made the last bid as the current winner. Pay attention to processing products without bids, and the results are sorted in ascending order by product name.
Question 2
Implement two Mixin classes DictMixin And JSONMixin, provided separately To_dict And To_json Methods for converting an object's non-private properties to dictionaries and JSON strings, and handling serialization exceptions.
Idea for the second question: The cryptocurrency question requires calculating the total value of coins and tokens respectively. The total value is equal to the unit price multiplied by the quantity, and then the top five with the highest total value are selected, and the two results are combined. The result needs to be formatted with total value as a dollar sign plus two decimal places, and sorted by type in ascending order and total value in descending order.
Question 3
Write SQL queries to generate cryptocurrency portfolio reports, calculate the total value of each currency (distinguishing Coin/Token), filter out the top 5 high-value currencies in each category, and sort and format as required.
Idea for the third question: The library class needs to implement a basic item class and two sub-classes, books and DVDs. The basic class must have title author and year attributes and a method of displaying information. The book class must add genre and ISBN attributes and override the display method. The DVD class must add a duration attribute and override the display method. At the same time, implement the __str__ and __repr__ magic methods.
Question 4
Write a SQL query to generate an item status report for the auction website, count the number of bids for each item, calculate the current price, determine the current highest bidder, and handle boundary conditions such as no bids.
Idea for the fourth question: For the mix-in class question, two mix-in classes must be implemented. DictMixin must provide the to_dict method to convert the object into a dictionary, which only contains attributes that do not start with _. JSONMixin should provide the to_json method to convert the object into a JSON string. If it encounters an object that cannot be serialized, a TypeError exception will be thrown.
Winning the interview starts with passing OA
If you have recently received an OA but are not sure about the time pressure or the topic, you can prepare a more secure plan in advance. Supports HackerRank, CodeSignal, Niuke and other platforms Remote OA assistance , the process is traceless, safe and stable, focusing on helping you complete the code and pass the test cases within the limited time. SQL, Python, algorithm or engineering implementation questions are all supported by practical experience. Try to make as few mistakes as possible in the key written test and get more opportunities to enter the interview. You can find out in advance if necessary.
