Phase 2 (API Design/System Design) 5. We have a table with two columns: driver_id and phone_no. The table contains 1-10 Lakhs of data(by that he meant a huge deal). Given the driver_id as a parameter, design an API to send text messages to drivers. The api gets 5 calls/sec (which is huge according to him). Ans: i. As the driver_id is the primary key here, we can fetch the respective row from the database using that. ii. But the database is huge. So, is it good to call the DB everytime we get an API call? (Followup Question) iii. Okay in that case we can use caching to cache frequently called driver_ids. iv. How can we do that? (Followup Question) v. Well, maybe we can use a dictionary to save the frequently called driver_id, phone_no. vi. So, you mean in memory DB? (Followup Question) vii. Yes. viii. But maybe our service is running on three different servers. How would you handle that? (Followup Question) ix. Well, in that case maybe we can use a caching DB like Redis. So, we may be able to call it from any server. x. But the API gets a hit of 5/sec. It’ll still perform poorly. How can we solve this issue? (Followup Question) xi. After thinking for a moment I said, sorry, no idea. xii. Haven’t you used async programming? We can use async to handle multiple requests at a time! (Answered himself as I got stuck)

Phase 3 (SQL Query) i. Given two tables: Write an SQL query to show total salaries of each department along with the department name. Employee Id salary dept_id 1 100 2 2 200 1 3 300 2 4 100 3 Department Id Name 1 A 2 B 3 C

Phase 4a (Problem Solving) i. Given an n x n array. Write a function to return the diagonal sum. 1 2 3 4 5 6 7 8 9

Phase 4b (Problem Solving) ii. Given an array of integers, find the longest subarray where the absolute difference between any two elements is less than or equal to 1. Example There are two subarrays meeting the criterion: and . The maximum length subarray has elements. Function Description Complete the pickingNumbers function in the editor below. pickingNumbers has the following parameter(s): int a[n]: an array of integers Returns int: the length of the longest subarray that meets the criterion Input Format A = [1,1,2,2,4,4,5,5,5] The first line contains a single integer , the size of the array . The second line contains space-separated integers, each an . Ans: [4,4,5,5,5] Constraints 2<=n<=100 0< a[i]<100 The answer will be >=2 6 4 6 5 3 3 1 Answer: 3 {4,3,3} 6 1 2 2 3 1 2 Answer: 5 {1,2,2,1,2}

Phase 5 (OOP Concepts) i. Explain the Dependency Inversion principle of SOLID design. ii. Why do we use interfaces? Iii. What’s the difference between interface and abstract class?