I made it as far as the Online Assessment. There were only two questions, so it was pretty fair in that regard. However, this meant that 50% of my assessment was contingent on my knowing a lot of SQL queries, which I don't really use past DDL, since everything is usually done through the ORM apart from sanity checks. This SQL question was much more involved than that. I'll also add that SQL wasn't mentioned in the job description I applied for.

In the coding question, I couldn't figure out what they actually wanted. I keep reading how other people had questions that were easy or at least straightforward, but the one I had didn't make sense, even with the examples they gave, and was written rather obtusely. I was left trying to figure things out from the context of the input arguments and tests. I think I would have figured it out given more time, but 50 minutes and under pressure...

Anyway, it was HackerRank. Always remember to hit "submit" whenever you make progress. I forgot to do that after making significant progress on the SQL question. Maybe brush up on your SQL as far as filtering and grouping, calculations, and decimal places.

You have several servers that can take in a given number of requests. The server capacity and server requests are given to you in arrays.

Three of the servers can be upgraded to double capacity.

Return the number of servers or capacity left over, or something; it wasn't clear. My best guess is they wanted the minimum capacity of the servers that would cover the entirety of the requests (so assume a cloud scenario where you could have unlimited compute but at a cost), but they didn't say that.

The SQL question involved joining two tables, then adding another column which is the result of a calculation, then filtering and arranging that new column, and reducing it to two decimal places.