Interview Questions

RestlessMonk - "Below data was given in a an excel. Data of 6 weeks, at a weekly level of COVID samples collected and tested Age Group, Population size, # tested, # positive, gender My approach: Tried to understand the trend of positivity rate of each group across weeks and cumulative level There is no variation across weeks, and each cohort exhibited similar pattern in all the weeks. So looked at cumulative data of 6 weeks. No clear goal/objective set by the interviewer for vaccine distributio"See full answer

Derrick M. - "SELECT u.id as user_id, u.name, COUNT(t.product_id) AS orders FROM users u JOIN transactions t ON t.user_id = u.id JOIN products p ON p.id = t.product_id GROUP BY u.id, u.name ORDER BY orders DESC LIMIT 1 `"See full answer

Alvin P. - "SELECT e1.empid AS manageremployee_id, e1.empname AS managername, COUNT(e2.empid) AS numberofdirectreports FROM employees AS e1 INNER JOIN employees AS e2 ON e2.managerid = e1.empid GROUP BY e1.emp_id HAVING COUNT(e2.emp_id) >= 2 ORDER BY numberofdirectreports DESC, managername ASC `"See full answer

Anonymous Owl - "def flatten_dictionary(dictionary): \# return a flattened dictionary - int/string/another dictionary values \# if the key is empty, exclude from the output \# concat using a "." btwn them \# add to res which is { "key.a.b.etc": "value" } \# iterate through the key value pairs \# while there is a key value pair in the value \# continue going through that, until the value is an int/string flatDic = {} flatDicHelper("", dictionary, flatDic) print(flatDic) return flatDic def flatDicHelper(initialKey"See full answer

Poha - "Design the cache, set policy like LRU or other custom policies."See full answer

Anzhe M. - "It's a 2Sum question with duplicate array elements."See full answer

Anonymous Muskox - "Web server request HTTPS://WWW.GOOGLE.COM (HTTPS)Protocol -> HTTPS/HTTP (HTTPS more secured, encrypted data send by browser) WWW. that is just a term (GOOGLE.COM)DNS -> Every website that is hosted on the internet resides in some data server having an IP address. Due to the complexity of the IP address, ISP mapped the IP address to some readable or English term that is called DNS. Browser does DNS lookup. The FIrst bRowser sees the DNS mapping in the browser cache, if not found then it looks"See full answer

Exponent - "This is another Strategy question, which means finding good reasons for strategic decisions. A few reasons for the GitHub acquisition are listed here. Competition > With the GitHub acquisition comes a lot of data on which companies are getting huge, or which technologies are cutting edge. Microsoft can adopt these technologies faster than others by having a pulse on this. It's also a defensive acquisition, since GitHub belonging to Microsoft means it can't be bought by Facebook or Google"See full answer

Anonymous Cat - "Slack -- it keeps all of my team's communications nicely organized, it let's us easily go back to previous messages. It makes interactions more casual with our team, which I think creates a more collaborative culture, especially since we all work remotely."See full answer