Technical Interview Questions

Srini K. - "performance issues and sudden spikes on input requests by scaling techniques and optimization."See full answer

Chris C. - "Here are the key entities to design a relational schema for a calendar application: User - userid, email, firstname, lastname Calendar - calendarID, calendarName, caledanUserID, defaultUIView, created, updated, status Event - eventID, eventName, eventUserID, isRecurrence, startDateTime, endDatetime EventReminder - eventID, reminderMethod(email, notification), reminderTime, reminderTimeUnit(min, hr, day) Event guest - eventID, userID, isRequired, acceptStatus"See full answer

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

Praful B. - "The customer's business needs and requirements. The technical aspects of their legacy system. The budget and timeline constraints. The risks and mitigation strategies. The customer's specific concerns. Assess the feasibility of migrating their legacy system to the cloud - This will involve evaluating the technical aspects of their legacy system, as well as the business impact of the migration. Develop a migration plan -This plan should outline the steps involved in migrat"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

Daniel M. - "Should be able to charge the airpod case when pluged into energy. Should be able to charge when the airpod case has battery. Should be able to alert if the airpod case is out of battery. Should be able to sync with non-paired devices. Should be able to sync automatically with paired devices. Should be able to sync automatically with paired devices that are closer to the airpod. Should be able to switch the connection to a device answering a call. Should be able to pause during us"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

Dinesh K. - "i dont know"See full answer

Manas M. - "I'd ask Clarification questions here before proceeding with designing a CDN. The questions would be. What is the Use Case with multiple questions in it What sort of Content do you want to serve - Static files or Streaming Media or trending content? How many regions do you want to cover Do you want to prioritize speed and the Latest file availability or do you want to prioritize time-based caching per region? Budget constraints(push cdn's can be cheaper). Whether"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

Bhuvan D. - "DFD, data flow diagram or Information flow diagram helps a business user clearly understand technical concepts as it links use cases with technical concepts. While feature document along with user stories (with acceptance criteria) works best for technical user to understand business concepts."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

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

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