Interview Questions

Umang S. - "Context - I joined a large public-facing service as a PM midway through its development. Situation - Due to the SOPs of the company the team already had a metrics framework. That included your standard DAUs, Retention and Acquisition Metrics Concern - As SOP metrics were publicly accepted, the team did not internalise what success actually means to the product they are developing, as the actual value was not being encapsulated in the framework This was evident in the show and tells as the"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

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

William D. - "Clarify: I'm assuming that a workplace chat app is similar to something like Slack or Teams, which is a web app/mobile platform for employees to securely message each other directly or in a grouping (i.e. a channel). I'm also assuming that this workplace app is for a generic company, and not Microsoft or Salesforce. Goals: Workplace apps serve a vital connective tissue within enterprises to allow employees to freely message one another and collaborate on projects. These services a"See full answer

Shiv C. - "Clarifying Questions What is meant by art-related product? Is it a product where art can be shared by creators and viewed by viewers? Yes What is art? It can be painting, song, video creators etc. Meta Mission: To form a worldwide community Goals: Brings creators and viewers worldwide To strengthen the Meta community Strengths Social network Users Creators (L, L, L) Viewers (L, L, L) User Journey 1."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

Ash J. - "Clarify: I will assume that misinformation includes posts, videos and pictures and that sources could be Groups/ Pages and Individuals. High level structure: Mission, Information funnel and drop-off points, Metrics & Trade-offs, Mitigations Mission/ Strategy: Facebook's mission is to bring the world closer together and empower people to build community. Reliable information is key to fostering a healthy community. In light of recent world events and public sentiment, it is important f"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

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

Hashmina H. - "Clarifying Questions: Do we want to target a particular geography or location or should it be done globally? Assume global Is there any particular platform and device we are targeting (App/web) or should it be cross platforms? Cross platforms Can I think about it as Product led solutions or do you want to consider marketing alternatives as well? Let's start with Product led solutions & later if time permits, we can touch on the marketing side as well Are there any constra"See full answer

Rohit K. - "First, clarify the scope of question: 1) what is the goal of the feature , engagement or monetization? : I assume this is user engagement as the google maps is a mature product and this feature can solve pain of the users driving vehicles and may be later extend this to a premium offering 2) do we have any geographical location to target ? : I assume India as I am familiar with the location and later if required, we can extend the solution to other geographies let me summarize my understanding o"See full answer

Hari priya K. - "Netflix is a OTT platform that streams content , TV shows, movies documentaries, to the subscriber's of Netflix. Netflix has approximately 90 million subscribers in USA alone and Netflix's revenue is generated based on their subscriptions. The user buys Netflix subscription, logs in , opens profile and opens the home page of Netflix. 1. Confirmation of the Assumptions Homepage Definition: The homepage is the screen users see after logging into their profile, showing tailored recom"See full answer

A R. - "I liked the role of a TPM due to the opportunity to contribute to the multiple dimensions of software product development. As a TPM I need to collaborate with multiple teams like Engineering, Product, and other business functions, but I also get the opportunity to contribute to the technical aspects of the program/project. I can use my sharp analytical skills to identify/anticipate problems, and leverage my problem solving skills to unblock the teams. I orchestrate multiple teams effort to del"See full answer

Robert H. - "The addition of an intermediate "sanitization" ML is something Neeraj used in the Uber Eats design and again seems kind of outside the scope here and redundant. This can simply be built into the AI response model to save a step. It's not clear what benefit this step provides, and he basically said we should have it "just because it would be good" and there's no concrete reasoning why to include it. Adding a Kafka queue to handle the thumbs-down ratings? For what purpose do you need a queue othe"See full answer

Jay K. - "First, let’s discuss why this is important for any platform business Think of platform businesses like Amazon or YouTube as matchmakers. They connect people who want something with those who provide it, whether it's products or content. But here's the catch: users trust these platforms to make sure they're getting good stuff. They want genuine products, safe content, and no scams. So, platforms need to be like guardians. They check suppliers and content creators to make sure they're not"See full answer

Will P. - "There are several categories of ads that users may encounter on YouTube content pages, depending on the user's device and browser. To narrow the scope of my answer, I am going to assume this is a non-skippable, midroll video ad that is 15 seconds long, and shown to a non-premium desktop user in the US. The next step is to clarify the motivations behind the proposed feature. Are non-relevant ads harmful to the overall user satisfaction? Do users engage more with relevant ads? Are advertisers mak"See full answer

Kartikeya N. - "Clarifying questions: What city/ country are we talking about? Indian metro. What all counts as a grocery store? Do have to cover dark stores as well which are not open to public? Only consider all grocery stores where public pick up is allowed. Do we have to include hyper markets/ super markets as well or only smaller stores? Include both. Okay, so I would be considering the Indian metro of Bangalore here. The overall equation is , **total number of grocery stores = Number of small grocer"See full answer