Technical Interview Questions

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

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

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

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

Takashi M. - "My approach is try to narrow down by 4W1H. When - When this happened? Still continuously happen the problem? Where - Is this happen specific region or entire customers? What - What kind of problem? One time big error or any data show the curve? Who - Is it all platform or specific platform (Web, iOS, Android) How - How serious problem? How many customer affected? Next step is to narrow down the causes is from internal factors or external factors. For internal factors: Any recent up"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

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

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

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

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

Ankit kumar S. - " logo Contact Interview Preparation Application Process Career Advancement Onboarding and Orientation Common Interview Questions Dashboard Creation Interview Questions and Answers Dashboard Creation Interview Questions and Answers What is a dashboard? Answer: A dashboard is a visual representation of key performance indicators (KPIs) and other important data, designed to provide a high-level overview of a specific area or business process. It typically uses charts, graphs, and other da"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

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