GoComet | SDE-2 | Technical Interview

Round 1

Questions:

1. Questions were from the Resume and from the projects/features I have worked. Scalability, Design Patterns were involved.
2. LeetCode Problem: Restore IP Addresses

Round 2

Questions:

1. A backend API that retrieves records from a database is becoming increasingly slow as the database grows. How to mitigate this? Expected answer in terms of query optimisation.
2. Your API is being hit by a high volume of requests from a single client, impacting other users. How to mitigate this? Expected answer in terms of best fit Rate limiting algo.
3. A system with multiple threads occasionally hangs due to deadlocks, and some operations fail due to race conditions. How to mitigate this? How to deduct the deadlock first?
4. A backend system occasionally fails in production, but the logs don't provide enough information to debug the issue. How to redesign the logging mechanism? How many types of logs?
5. Your service allows users to upload large files, but users report failed uploads when the file size exceeds a certain threshold. How to design a service which accepts large files (say 10GB) from multiple users(say 1 million users)?