Technical Interview Questions

Soraya B. - "A load balancer, web application servers and a large database. Database is the core of the application containing the songs and tags related to each song. Application server will provide the search interface to find songs, play them and search them in specific categories or channels."See full answer

DM - "Clarifying my assumptions first, i.e. "Technical contributions are not just writing or reviewing code". Answer : My contributions to any program I lead as a TPM are as follows : Inputs towards design, architecture review, mapping requirements to the proposed design, reviewing the implementation strategy w.r.t scalable solution, Writing core user-centric test scenarios, Validating proposed design vs implementation estimates vs initial planning. etc... Example : Situation: We are a"See full answer

Yashasvi V. - "WITH RECURSIVE fibonacci_series AS ( SELECT 1 AS n, 0 AS fib1, 1 AS fib2 UNION ALL SELECT n + 1 AS n, fib2 AS fib1, fib1 + fib2 AS fib2 FROM fibonacci_series WHERE n < 20 -- Limit the series to 20 numbers ) SELECT n, fib1 AS fib FROM fibonacci_series ORDER BY n; `"See full answer

Anonymous Crab - "Clarify: IG shops is the marketplace on IG, where users can view items listed for sale by creators/businesses and also search for specific items or categories. Users can actually buy through shops instead of getting navigated to the original business website. Correct? Clarify: Can only sellers/businesses which own their inventory have a "shop"? Or can a social media influencer (different IG account) sell on behalf of a business? Structure: In order to figure out what success looks like, I'd fi"See full answer

Ankita S. - "let's say I'm working on a social media platform and considering implementing a new feature: "Reactions" to posts, similar to Facebook's reactions (like, love, haha, wow, sad, angry). Here's how I would conduct an A/B test for this feature: Define goals and Identify the feature: Goal is to increase user engagement and provide more nuanced ways for users to express their reactions to posts.The feature I want to test is the introduction of "Reactions" buttons alongside the traditional "Lik"See full answer

Uttam R. - "Clarifications ( Assuming this a technical question ) What is the purpose of this News feed ? Do we have a specific platform in mind ( Assumed Android phones ) Focus user group - People who use News feed a lot Business goal - Provide fresh and engaging content. Basic functionalities of news feed: News feed - A space where articles is collated and presented to the user Organise content. Customise news feed based on reading patterns. Push down older content. Keep the reader"See full answer

Taheia S. - "at first I want to know number of cluster I will put random number if I don't know and I will use method called Elbow method or Silhouette Score ,Gap Statistic and Davies–Bouldin Index to know the best number of cluster and I will use scikit-learn library to import kmeans from sklearn.cluster import KMeans kmeans = KMeans(nclusters=2, randomstate=0) kmeans.fit(X) and X this my data "See full answer

Esha - "Clarifying Questions What do we mean by ‘improve’? Is there a certain goal that we are trying to attain? Is there a target user that we are going for? Any constraints or things to keep in mind when building this? Assumptions Only focused on google docs and not collaboration on other G-suite products such as PPT or sheets What is Google Docs? Web-based productivity tool that allows you to access your files from any computer through your gmail account. You can also share and"See full answer

Anonymous Panda - " Communication between Mars and Earth is facilitated through various methods and technologies. The primary means of communication is through the use of space probes, particularly those equipped with powerful transmitters and receivers. Here's a general overview of how communication between Mars and Earth works: Deep Space Network (DSN): NASA operates the Deep Space Network, a global system of radio antennas located in California, Spain, and Australia. These antennas are responsible for sending"See full answer

Darpan D. - "Clarifying and assumption When we say financial security, are we talking about authentication, fraud detection or money laundering? Assumption: Fraud detection. Focusing specifically on transaction-level fraud. Is this an internal AI implementation or an external third-party service we provide to multiple financial businesses? Assumption: External Third-party AI financial security product. Requirements Need to detect when fraudulent transactions happen. **Detection stra"See full answer

Rishabh L. - "Pizza Ordering System orderdetail - orderdetailid (PK), orderid (FK), itemid (FK), itemqty, itemized_price order - orderid (PK), customerid (FK), orderdate, locationid (FK), ordertype (DINEIN, PICKUP, DELIVERY), refid (dineinid, pickupid, deliveryid), subtotal, tax, tip, totalamount, payment_method (CASH, CARD) location - locationid (PK), locationdesc, city, state, startdate, enddate customer - customer_id (PK), name, address (nullable), phone (nullable), dob (d"See full answer

Manik K. - "Agile methodologies are chosen by organizations to enhance delivery speed, integrate shorter feedback loops, and provide incremental value to customers. However, the suitability of Agile depends on several factors, including the nature of the work, team structure, and organizational objectives. From my experience, for teams focused on new feature development, Scrum tends to be more effective. Scrum’s structured cadence—emphasizing backlog grooming, sprint planning, and regular retrospective"See full answer

Anirudh G. - "Initial Questions: 1.How many patients do you think you will have in the next 5 years? Interviewer: Max 1000 In that case we don't have to build a highly scalable system. 2.Will you be carrying out some procedures like xrays, ct scans or will only be doing consultations? Interviewer: We will be doing minor procedures. Will refer to hospitals for anything major. 3.I see that you mentioned 2 locations. Are there any special billing requirements for each of them? Interviewer: No Users: Fo"See full answer

Pathworks P. - "I would begin by asking the following clarifying questions: Are there any special use cases such as VIP Penthouse access, restricted floors etc? Do we need to consider safety requirements or other technical constraints such as maximum load/capacity? If the lobby for the entire hotel located on the ground floor? Can we assume that the majority of the guest amenities are located near the lobby and lower floors? Can we assume that the passenger controls on the floors are purely directional"See full answer

Anonymous Capybara - "using a relational database isn't a good choice for this system! we need more availability here than consistency (CAP theorem)"See full answer

Kk - "Clarifying Questions : By reducing bandwidth , do you mean reducing the total size of video transfer reduction ? Ans Yes Is it ok to reduce the resolution by reducing the bandwidth : Ans May be yes and no Any app in particular you are looking forward which could help talking from its standpoint : Ans : Youtube Assumptions : Youtube has a compression algorithm which can still be made better with the evolution of technologies Solutions ( prioritised list ) Improve the compressio"See full answer