Let's say you have a customer with 100 servers, with each server sending 10k metrics with a timestamp and a value every 10 seconds. We want a system in our datacenter to store the data and to be able to retrieve it for reads. Each metric consists of: a timestamp (unix timestamp 64 bits) , can be second resolution, separate year, a floating point value 64 bits, an identifier string that is 85 bytes. How would you approach and think about this problem? Let’s discuss.
Most of the questions are based on trees.
array manipulation problem- online test
How many type of indexes can be use in MySQL?
- 1/0 knapsack problem - How to debug a slow SQL query? What could be causing slow queries if the query structure is not a problem? - process vs thread - what are good practices when integrating an external API? What would you do to improve user experience if an external API has inconsistent latency, when used to display live data (non-financial, ~1s granularity)?
Tiling a Rectangle with the Fewest Squares
Given a list of restaurants find the k nearest restaurants to the user
How does connection pools work in Ruby On Rails with PostgreSQL?
HR call, then live coding interview, question is easy but I forgot it
Sorting using different algorithm, analyse the speed and performance
Viewing 8311 - 8320 interview questions