Interview Questions

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

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

Tracy M. - "I defaulted to a dictionary-style definition of autonomy, then loosely tied it to users and systems. But I missed the interviewer’s signal that this was really a design/strategy probe. Stopping at a generic level made it sound like I couldn’t translate agency into what matters for product — user trust, trade-offs, risk, and roadmap implications."See full answer

Nagasowjanya V. - "Click- through rate (CTR) should not be analyzed in isolation. Combining it with watch time, bounce rate, and retention metrics ensures a comprehensive understanding of user engagement and content effectiveness. Hypothetically, addressing the 10% CTR decline on Netflix Understand & Identify where the CTR drop is: Compare CTR trends over the past few weeks / months / years to identify if this a seasonal fluctuations or a major issue. Is the 10% drop a platform-wide issue or specific to a"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

Ashish G. - "Rate Limiter is to limit the number of request from a particular IP Address. Rate limiter will block the IP address to reduce the load on server. It should be highly available and handle concurrent requests. Blocked IP addresses should be kept in a pool which is present in shared cache. We need to keep threshold value after it reaches threshold value it should start blocking IP address. All these ip address to be kept in No SQL DB. Batch will run that will clear the cache and delete all the bloc"See full answer

Aashka C. - "Sorted the array and stored the minimum difference in a variable and then traversed the array for the pairs having minimum difference"See full answer

Sandhya P. - "What is Meta Quest, Horizon world VR game? Horizons worlds is a platform that lets creators build worlds where real people can come and interact. This could be a gaming world, a socializing world, a marketplace, immersive experience, etc. Why would people want to use Horizon worlds: Because it isn’t possible to always visit all places in person I know that Meta has been encouraging creators at this time because the Horizon’s worlds needs a lot of worlds for it to be interesting for customers Cus"See full answer

Sreeram reddy B. - "select employeename, employeeid, salary, department, DR from ( select employeename, employeeid, salary, dense_rank() over (partition by department order by salary desc) DR, department from employee ) where DR <=3 order by department, DR"See full answer

P D. - "My Least Favorite Product: Amazon Kindle I have both: amazon kindle 8th generation (with backlight) and without backlight for many years now and also part of kindle unlimited program. And would be having more than 200-300 books on it already ranging across various topics What i don't like about kindle is that, its operating system has not evolved since many years. It's as difficult to operate as it was when it was launched. Infact now i don't prefer to browse the books on kindle, instead buy t"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

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

Natalia N. - "Clarifying questions: How much is the decline? Since when have sales been declining? Make sure that it has correlation with competition and not a premature assumption that can come from something internal (not external competition). Is it all the stores? What is the variation in the dicline? If you have stores that have 20% less sales vs some that are steady, it might be something related to the store experience specifically. How does the decrease in sales compare to cities that ha"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

Aniket A. - "Clarifications: Where are we launching? -- US first 1:1 or n:n video conferencing? -- you assume Consumers or Business? -- consumers Part of FB or standalone product? -- part of messenger app Is it MVP launch or a full feature product? -- MVP What capabilities exist in the video conference product? -- you assume what capabilities will be > Trends and Markets Competitors: Consumer Zoom Google Meet Business: Slack MS Teams Trends: More and more people are usi"See full answer

Saleel P. - "This is my first attempt at an estimation question, any feedback is appreciated. I'd like to clarify if AirBNB's core services would include user reservations on its web/mobile platform on a per night basis. I'd also assume if we would to estimate the topline revenue (or gross merchandise sales) without factoring operational expenses and taxes. I'd also clarify if basing my estimation on revenue from its largest marketplace, US, is reasonable. Population of US - 350 MM Avg Household size - 2.5"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

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

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