Interview Questions

Anonymous Roadrunner - "-- Write your query here select id, (case when p_id is null then 'Root' when pid in (select id from treenode_table) and id in (select pid from treenode_table) then 'Inner' else 'Leaf' end) as node_types from treenodetable order by 1; `"See full answer

Ani T. - "User Need Not Being Met by the Market: Instant, Seamless Cross-Border Refunds Identifying the Gap- One major gap in the digital payments industry is the lack of instant, seamless cross-border refunds for consumers. Currently, international refunds take days or even weeks due to exchange rate fluctuations, banking delays, and compliance checks. This creates frustration for users, especially in e-commerce, where consumers expect instant refunds like they receive for domestic transactions. Pain Poi"See full answer

Harshit J. - "In my organization, I was given a initiative to improve the time spent by users on web application so that we can improve the quality of engagement on the website. Overview of a business model: We are a research organization that delivers where users (B2B clients) consume research content in form of research reports. Clients has specifically subscription for a year and if clients engage continuously and they spend more time on research they will retain. Success metrics: Improve time spe"See full answer

Mark H. - "Clarification: workplace is a communication messaging tool for employee to send and receive messages. Why: meta's mission current landscape market trends meta's unique value strength & weakness Workplace Mission: build a communication tool for employees to better collaborate and engage with each other Goal: focus on engagement, not revenue Product ecosystem: Meta Company sourcing department IT department User: sender/receiver #of people log in #of people"See full answer

Utkarsh G. - "Clarify: Map means -> coordinates Places -> any location visitable by humans software/hardware? -> up to you unmapped by anyone or in Gmaps? -> not in Gmaps Goal: to widen coverage constraints -> none market - US Time to market -> 3-6 months Why Aligns with Google mission Drive more engagement Users Company Users who drop locations Big City dwellers Country side areas Remote areas with limited internet End users Advertisers Prioritise: siz"See full answer

Bradley E. - "Here's a simpler solution: select u.username , count(p.postid) as countposts from posts as p join users as u on p.userid = u.userid where p.likes >= 100 group by 1 order by 2 desc, 1 asc limit 3 `"See full answer

Ahmed A. - "He was really all over the place ? couldnt detect a structure to his answer felt like he was talking out of experience ."See full answer

Siddharth P. - "I believe these are the traits of a great PM. I see PM to be somone who is a great manager of customer problems and for that he/she has to be: Be an expert at the one domain and know the customer of the product in that domain and curate experiences for them better than the competition. Be persuasive - Get things done by convincing rather than commanding. Learn how great products are by being an engineer. Be a fearless leader by championing teams ideas all the way to the management la"See full answer

Bk - "Clarification: By Improvement we could delve into either improving Monetization, User Engagement, Experience or Retention. Project Goal: In particular letz focus on improving User Engagement/Experience which may also pave way into monetizing - cuz the way I see it is to put out multiple configurations /packages in the market, and allow users to choose and pay for the services. Its as simple as hiring a full time assistant vs part time. U pay for the service rendered. **Product Vision"See full answer

Gadi R. - "So first, I have some clarifying questions, what is Facebook lite? If I understand correctly this is a version of the Facebook application for Android, with the same functionality but lighter in terms of size. It is aimed to be used in emerging markets where the bandwidth is limited What are the tradeoffs for the size of the app? I guess that some visual elements are stripped down from the app and reduced its size Is this application exist or I am launching it The timeframe of the product?"See full answer

Amy M. - "Clarifying questions: Do we want to focus on front end or backend? Front end Do we want to focus on any particular platform? For ex: Site, mobile, apps Interviewer: Desktop Is there anything tools on gmail that you'd like me to focus on? For ex: Meet, Hangouts, Notes Interviewer: Just the main product Are there any specific product buckets that you'd like me to go through? For ex: Sign up flows, login flows, security, product experience, sign out flow, recommend"See full answer

Hayatu H. - "Best practices for prioritizing customer service requests Prioritizing support requests is a key part of creating a customer journey optimized for maximum revenue. If you want to start using a ticket prioritization process that will boost both customer satisfaction and your bottom line, we've got nine proven best practices below: Respond to your most loyal customers first Tag repeat customers as high-priority tickets Automate simple requests wherever possible Mark tickets with urg"See full answer

Alibi M. - "I would answer this question using MECE framework: Profit = Revenue - Costs. Revenue = # customers * price In case of the trading platform, this could be translated into avg. trading activity per user * avg. commission rate . Ask if there has been any recent change to Active users or their trading activities. Similarly, ask if the commission rate has been changed recently. Based on this information, you can then identify the problem and get to the root cause of this. Similarly with Costs. "See full answer

Pramod V. - "Referring to https://www.forbes.com/sites/forbesbusinesscouncil/2022/03/23/15-strategies-for-balancing-competing-stakeholder-priorities/?sh=7c82aa68262f Understand the conflicting priorities and align it with the goal/ objectives and the company mission. Start with the Least Common Denominator between the conflicting priorities to come to a commonality and start from there to objectively approach the next imp priority Always keep communication on and be transparent with 'equality' an"See full answer

Adib M. - "Notes from the Video. 1-1s are two way feedback. Important tool to discuss things that are not possible in group setting feedback to employee by manager feedback to manager by employee Feedback to employee can vary by the type of performer the employee is (a) high performer (b) meets expectations (c) under performing Dos and Don't Avoid project discussion as they can be obtained else where. Focus on feedback to employee. Unless there is a critical project item to be d"See full answer

Karthik T. - "In our product portfolio there were many teams and we were almost 12 product managers interacting closely to deliver the entire product feature area. Situation was that we were frequently had defects come in which will result in defects pushed back and forth. Goal was to avoid this as SLA of defects was getting impacted immensely there were priority 2 defects which we were sitting for couple of weeks before being looked at. There was a need to establish a triaging process. Along with my leaders"See full answer

Dania L. - "Was this asked as a part of the mini case?"See full answer

R K. - "As a Product Manager for Instagram Reels, understanding Meta's investment in this product requires considering the broader competitive landscape, primarily TikTok, and Instagram's monetization strategy through ads. The focus on Reels is a strategic move to capture a share of the short-form video market, increase user engagement, and drive ad revenue. Lets start with why Meta invested in Instagram reels 1. Competing with TikTok: TikTok's explosive growth in the short-form video space pose"See full answer

S V. - "I think, robots.txt file is provided by websites which web-crawler is crawling. Am I wrong somewhere or missing some context?"See full answer