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

Farhan I. - "What software is being used to draw the design?"See full answer

Shiva K. - "Increasing a development team's productivity by 25% requires a multifaceted approach that addresses various aspects of team dynamics, processes, and individual performance. Here's a structured approach to tackle this challenge: Assess Current Productivity Levels: Before implementing any changes, it's crucial to understand the current productivity levels of the team. This can be measured through metrics such as velocity (for Agile teams), time-to-market, defect rates, etc. **Identify Bo"See full answer

Puneet A. - "I recently had an experience with the Chipotle mobile app where I accidentally placed an extra order. Realizing my mistake within seconds, I tried to edit or cancel the order but found no option to do so in the app. Despite searching FAQs and attempting to contact the local store, I couldn't resolve the issue in time. This experience highlighted the importance of user-friendly design and clear communication in apps. If I were managing such a product, I would advocate for features like a grace pe"See full answer

Teddy Y. - "class Node: def init(self, value): self.value = value self.children = [] def inorder_traversal(root): if not root: return [] result = [] n = len(root.children) for i in range(n): result.extend(inorder_traversal(root.children[i])) if i == n // 2: result.append(root.value) if n == 0: result.append(root.value) return result Example usage: root = Node(1) child1 = Node(2) chil"See full answer

Personal W. - "Payment system requirement assumption: Need to be ACID Amount limitation - some validation for max input size can be done at client level/ API level. Need to store historic info - GDPR The information to be stored for database assumed can be structured so RDBMS like mysql or Postgres Notification requirement - if fail or success need to be text or email to user and or caller Scalable - Assumption that it deals with critical transaction so Availability and Scalability requirement i"See full answer

David E. - "Its enough that I shared the question. Im not going to tell you how I answered. If you dont know how to answer, then this isn't the job or company for you. Sorry."See full answer

Kritarth L. - "i would understand if this is role specific, team specific, geography specific, at a specific time of the year maybe after appraisals i would also understand the goal - how much reduction in attrition in what time frame then we can look at reasons reasons why someone quits - personal or work related - ill probably try to have a constructive session for the personal ones while for work related il split it into - pay/payhike, impact created, growth stagnation, bad team culture, flexibility in"See full answer

Brit L. - "Question #1 Imagine you were in charge of Facebook Watch, what metric would you want to measure? Clarify: Facebook Watch offers users video content including news, sports, live stream shopping and gaming, etc. it works on both desktops and mobiles. It's a fairly recent feature. Mission: Facebook's overall mission is to connect people and help them build communities, and Facebook Watch can help Facebook achieve this by keeping users up to date with local news, or conn"See full answer

Sandhya N. - "Clarifying Questions: Discover events, purchase/resell via app Post booking: After ticket purchase to event completion Motivation for Ticketmaster: Strengths: 70-80% of ticketing business, tie ups with venues Competition: meetup Low frequency product - so every experience matters Positive wom: Reduced marketing Retention of users, organizers Users: Ecosystem Attendees: Discover, buy and attend events - {chose this} Event Organizers: marketing/demand, s"See full answer

Rjj - "I tried solving this question and here is the recorded video for the entire solution - https://youtu.be/G_LIbTp58XA Feel free to comment here or on the video for further discussion."See full answer

Chris R. - "It was like say we have a library A which has a library B as a dependency and so on, how would we determine in the dependency chain that whether there is a circular depedency?"See full answer

Aakanksha R. - "My answer- A. Clarifying questions- External factors- Timelines, Geography, Competition Internal factors- Meta's goals for entering into fitness space, full-fledged app or part of any existing Meta app Goals- Will go after engagement, since it is a new app. B. Identifying users- Heavily/ Professionally into fitness Casual fitness enthusiasts Not interested in fitness C. Prioritizing user segments- I will prioritize #2. Segment #1 does not really need external motivati"See full answer

Anonymous Aardvark - "in simple words, linear regression helps in predicting the value whereas logistics regression helps in predicting the binary classification. But lets talk through some example Linear regression model: E-commerce website pricing recommendation engine is built on linear regression model where we do have some variables such as competitor price, internal economics and consumer demand etc when we put this in a supervised learning model, it helps in predicting prices Logistics regression model"See full answer

Sarah K. - "I once had to change a decision i had previously made when I got stakeholder feedback that seemed to contradict what was already designed or already even built - such as the way a page was architected or the designs or colors used on a page. I had a justification for all decisions made, but sometimes the stakeholder feedback brings a perspective, such as a part of the user experience, that I had not thought of before. So I then went back to the original design or product and made an adjustment o"See full answer

Daniel C. - "select name, stock from products p left join transactions t on p.id = t.product_id order by date desc limit 1"See full answer

Praveen D. - "Let me try to explain it with simple life analogy You're cooking dinner in the kitchen. Multithreading is when you've got a bunch of friends helping out. Each friend does a different job—like one chops veggies while another stirs a sauce. Everyone focuses on their task, and together, you all make the meal faster. In a computer, it's like different jobs happening all at once, making stuff happen quicker, just like having lots of friends helping makes dinner ready faster."See full answer

Srilaxmi C. - "Step 1: Clarify Before delving into the metrics, should I consider the current state of Google or when it just launched? Here, I am assuming the current state of Google. Google is currently a company that makes approx $15) billion in Revenue and 90 % of the revenue comes from Ads. Ads are core for Google's business and Google is the major player in the market Step 2: Goals: The main goal is to maximize revenue through effective Google Ads campaigns. This means ensuring that the campaign"See full answer

John F. - "(i) helped others success Over the years, I’ve had a few non-technical friends who wanted to start companies. Around two years ago, one of these friends reached out to ask for some guidance on how to start. This individual wanted to take the Airbnb model and apply it to outdoor recreational activities, mainly hunting and fishing. His problem was he had no frame of reference for where to start of what kind of effort and investment it would take. Over the course of a couple of conversations I help"See full answer