Interview Questions

Mc L. - "I believe human emotions can't be judged by number and hence I have always made mistakes while judging the outcome of a reaction by data."See full answer

Shivam B. - "To address this question, I'll assume that Horizon Worlds is a virtual reality platform offering immersive experiences and content to users. As a Product Manager at HW, my approach would be to focus on metrics that align with the growth stages of the product. I'll use the AARRR framework (Acquisition, Activation, Retention, Revenue, Referral) to guide our analysis. Assumptions: Horizon Worlds is primarily a content-driven virtual reality platform. The business model includes both free"See full answer

Farhan I. - "What software is being used to draw the design?"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

Hayatu H. - "How do you find consecutive days for login (MySQL, SQL, date, subquery, MySQL 5.7, development)? 1 Follow Request Answer More All related (34) Recommended 📷 Trausti Thor Johannsson · Follow Been using MySQL for more than 16 yearsDec 27 There are functions like DATEDIFF but there are also BETWE"See full answer

Satish murthy D. - "The audio is bad, and the answer is not helpful. The answer addresses deprecating a product/Sunset a product instead of sunsetting a project. I would request the exponent to kindly re-address the question. My take on the question is based on past experience. Successful project closing: Investigate to make sure the project is over : ( Check List)- Review scope statement & Objective SMART metrics fulfilled? All tasks finished? Any defects"See full answer

Brajendra S. - "Clarifying Questions and Assumption: It is a Online store or a offline store ? Assuming it is an online store There would be multiple processes, for which process the CSAT score needs to be increased ? Assuming the CSAT score needs to be increased for product search & checkout process. Does this required for Mobile App or Website ? assuming mobile app Mission & goal: CSAT score of online search process for Costco needs to be increased. User personas: Working profession"See full answer

Mitchell K. - "How important are referrals? Do you need multiple vs. just one? Does it matter who refers you?"See full answer

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

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

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

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

Rani Y. - "I would start with clarifying questions : Are we building this feature on existing meta apps like Facebook / Instagram ? Yes AM I building this in Meta suite of products or a standalone app ? Inbuilt app with in Meta product like Fb/Instagram Timeline - 1 year Geography - USA Structure : Why -> Meta Mission -> Business objective -> User segmentation -Need ( Prioritization) -> Painpoints ( Prioritization)-> Solutions ( RICE prioritization) -> Metrics / NSM -> Risks - Summary Why : WIth multiple"See full answer