Interview Questions

Kartikeya N. - "Clarifying questions Are we referring to the credit card users of a particular card company or the overall number of users? : Overall number And we are referring to the number of unique users right, as in a person may have more than 1 card? : yes Can I assume the time setting of the question to be 2024? : Yes Thanks. Here's how I would approach this. India's total population = 1.4 Bn I know for a fact that in India only 2.5% of population pays income tax. A salaried employee who doe"See full answer

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

Tanu M. - "Clarifying Questions : Am I the PM at google ? Yes, For which country Airport are we designing this? Lets assume its a new product so we will design it for the US airports and later expand to other countries. GTM : When do we need to launch this product? Do we have any time constraints ? Lets assume one year I am assuming why google wants to enter in this space is because it is an untapped market and google can revolutionize the market with some of the most emerging tehnologies by e"See full answer

Sachin R. - "If 0's aren't a concern, couldn't we just multiply all numbers. and then divide product by each number in the list ? if there's more than one zero, then we just return an array of 0s if there's one zero, then we just replace 0 with product and rest 0s. what am i missing?"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

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

Push S. - "STAR story weaved around the project 0 to 1 execution with all the technical tradeoffs, issues, and success metrics involved."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

Aswath B. - "basic drew the diagram"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

Akshay D. - "SELECT SUM(orderquantity) AS totalunitsorderedyesterday FROM orders WHERE order_date = DATE('now', '-1 DAY') `"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

Preetham m P. - "1. Clarify the problem Are we building a digital or physical product?- We are offering it as an application on mobile. Are we building a complete new product or as a new feature for existing airline booking apps (Goibibo/Makemytrip, etc.)? - New feature for existing booking apps. We can consider Goibibo as an example. What do you mean by improving experience?- Reduce wait times or optimize the time spent. What is the goal? Engagement or Revenue? - Engagement. Which is t"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

Elle Z. - " why do we want to improve the DMV? we’re a startup and we want to improve the experience at the DMV what is the DMV? my assumption is that this is for the US only, and is the department of motor vehicles. and this is where folks go to get IDs, register their cars, etc. is that correct or am I missing anything about what the DMV is? is there a timeframe to launch? are there any other constraints that I should be aware of? context: what is the DMV - the DMV is a something of a"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