Interview Questions

Bala G. - "WITH ActiveUsersYesterday AS ( SELECT DISTINCT user_id FROM user_activity WHERE activity_date = CAST(GETDATE() - 1 AS DATE) ), VideoCallUsersYesterday AS ( SELECT DISTINCT user_id FROM video_calls WHERE call_date = CAST(GETDATE() - 1 AS DATE) ) SELECT (CAST(COUNT(DISTINCT v.userid) AS FLOAT) / NULLIF(COUNT(DISTINCT a.userid), 0)) * 100 AS percentagevideocall_users FROM ActiveUsersYesterday a LEFT JOIN VideoCallUsersYesterday v ON a.userid = v.userid;"See full answer

KAI - "Answer: select fromcaller, count(DISTINCT tocallee) as num_calls from calls group by fromcaller having count(DISTINCT tocallee) >= 3 Setup: CREATE TABLE calls ( from_caller VARCHAR(20), to_callee VARCHAR(20) ); INSERT INTO calls (fromcaller, tocallee) VALUES ('Alice', 'Bob'), ('Charlie', 'Dave'), ('Alice', 'Frank'), ('Charlie', 'Heidi'), ('Charlie', 'Judy'); "See full answer

Abhi - "Thank you for the question - before I can begin, I would like to understand the question further. A. Clarification: I am the PM for overall Insta reels or any specific platform > Reels I am assuming we are evaluating the performance of the reels globally > Yes I will also assume that we are defining the current metrics / performance of reels and not specific to a new roll out. > yes B. Funnel - understanding the product To make sure I understand the product correctly, Re"See full answer

Bharat D. - "Went through scenarios where a user Interviewer asked me to select a scenario, mostly outside of the control of the app. The interviewer saw me rattled and suggested the need to get to a venue as an experience. I designed a solution and suggested an MVP. The goal was to select a scenario, design MVP and suggest user journey/cohort selection and demonstrate measurement."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

Anni P. - "I firstly discuss the brute force approach in O(n^2) time complexity , than i moved to O(nlogn) tine complexity than i discussed the O(n) time complexity and O(n) space complexity . But interviewer want more optimised solution , in O(n) time complexity without using extra space , The solution wants O(1) space complexity i have to do changes in same array without using any space . This method is something like i have to place positive values to its original position by swapping and rest negativ"See full answer

Alice S. - "Clarify understanding of the problem space. What does success look like? How is it measured? Platform specific? Market specific? Time period? Business goals? Then perform a funnel analysis to understand user journey and look for problems or opportunities. Choose a user segment to focus on. Identify different user segments and prioritise one. Summarise the goal of the user and the friction point. Brainstorm solutions. Come up with a number of rough solutions. Balance the business n"See full answer

Alice S. - "Clarify the problem. Ask lots of questions to uncover the root cause of the problem. This could be related to internal factors like releasing buggy updates or external factors like market trends, infrastructure, regulation etc etc. Establish where in the user journey the problem might be happening, if it's happening for a subset of users or for everyone e.g. on iOS platform etc etc, what time period has the problem occurred? Gradually or suddenly? How is the metric (in this case revenue)"See full answer

Vipan K. - "As a postgraduate student of computer science, one of my weaknesses might be that I sometimes focus too much on theoretical concepts, which can lead to delays in practical implementation. I also find that while I’m strong in certain areas like algorithms and data structures, I need to spend more time refining my skills in newer technologies or languages that aren't part of the core curriculum. Additionally, balancing research, coursework, and any side projects can be challenging, occasionally le"See full answer

Aviran H. - "Product Overview: Instagram, a social network owned by Meta, allows users to create and share various types of content, including photos, videos, and Reels, which are short, TikTok-style videos. The platform serves different user segments, including content creators, viewers, and the platform itself as an ecosystem. User Segmentation: I segmented users into three primary categories: Content Creators: This includes businesses, public figures, influencers, and regular users who crea"See full answer

Shubham S. - "Introduction UberSenior is a new service offered by Uber that provides safe, reliable, and convenient transportation for senior citizens. This PRD outlines the key features, functionalities, and user experience for both seniors and drivers using UberSenior. Problem Statement Existing transportation options for seniors often have limitations, including: Accessibility: Lack of vehicles equipped for mobility aids or physical limitations Technology barriers: Difficulty using smartphone"See full answer

Rosmary F. - "Hinge is a company that fosters community which I'm passionate about. I'm also excited to work on such an impactful mission to contribute to the safety of its users."See full answer

Shraddha D. - "I like chatgpt for the following users Getting industry references are easy and time saving Getting recommendations is very easy Responses are accurate I use chatgpt to get feedback on content and identify gaps in my documentation or thought process I use chatgpt as a search engine and to get conscise situation based information. Chatgpt offers varierty of other tools in the explore version where similar users can create different content PRD template Chatgpt users 1."See full answer

Bailey O. - "For this answer, I'm assuming that I'm a PM who has just started at this company. I assume this product is a growing start-up and that's why I wasn't familiar prior to taking the role. Understand the business, mission, and product's context: Understand the company mission, values, vision Understand any near-term/long term company goals Meet & listen to key stakeholders & decision makers Build relationship with team members Understand who the first 'sale' or 'bu"See full answer