"Population of Bangalore - 1.4 cr
On an average 4 people live in 1 householde=> 1.4cr/4 => ~35L HouseHolds
Out of the 35L Household,
30% household
fall below poverty line
are not interested in ordering online due to their own personal reasons
prefers to visit to the hotel directly and eat instead of ordering online => Thus remaining is ~25L households
out of the 25L households,
assuming at least 20% of the households place one order on average on any given day will lead to 5L orders"
Volderdore - "Population of Bangalore - 1.4 cr
On an average 4 people live in 1 householde=> 1.4cr/4 => ~35L HouseHolds
Out of the 35L Household,
30% household
fall below poverty line
are not interested in ordering online due to their own personal reasons
prefers to visit to the hotel directly and eat instead of ordering online => Thus remaining is ~25L households
out of the 25L households,
assuming at least 20% of the households place one order on average on any given day will lead to 5L orders"See full answer
"\\Situation:\\ As a finance leader, I continuously seek ways to enhance \\strategic financial planning and performance measurement\**.
\Obstacle:\\ Traditional financial metrics often focus on \\historical performance\, but I wanted a methodology that \aligns financial goals with business strategy\\ in a dynamic way.
\\Action:\\ I applied \\OKRs\\ to financial planning by:
Setting \\quantifiable objectives\\ for revenue recognition and compliance.
Alignin"
Mary-ann E. - "\\Situation:\\ As a finance leader, I continuously seek ways to enhance \\strategic financial planning and performance measurement\**.
\Obstacle:\\ Traditional financial metrics often focus on \\historical performance\, but I wanted a methodology that \aligns financial goals with business strategy\\ in a dynamic way.
\\Action:\\ I applied \\OKRs\\ to financial planning by:
Setting \\quantifiable objectives\\ for revenue recognition and compliance.
Alignin"See full answer
"System Components
Data Collection Layer
Posts with hashtags are asynchronously sent to Kafka topics
Each message contains: hashtag, timestamp, userid, postid
Multiple Kafka partitions ensure scalability and fault tolerance
Processing Layer
Apache Flink processes streams in real-time
Implements sliding window aggregation (1hr, 24hr, 7d windows)
Calculates topic popularity using weighted metrics:
Post count
User engagement (likes, comments)
Unique user"
Usman B. - "System Components
Data Collection Layer
Posts with hashtags are asynchronously sent to Kafka topics
Each message contains: hashtag, timestamp, userid, postid
Multiple Kafka partitions ensure scalability and fault tolerance
Processing Layer
Apache Flink processes streams in real-time
Implements sliding window aggregation (1hr, 24hr, 7d windows)
Calculates topic popularity using weighted metrics:
Post count
User engagement (likes, comments)
Unique user"See full answer
"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"
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
"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"
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
Product Manager
Product Strategy
🧠Want an expert answer to a question? Saving questions lets us know what content to make next.
"Clarifying Questions/Statements:
Clarify understanding of Fundraisers:
My answer: product that lets users create fundraisers for a particular cause, and invite/share it with other users to donate to that cause. Usually set for a certain target donation amount to be met, and a timeframe for which a user can donate to the cause
Are we assuming the lifecycle of the Fundraisers product today? If so, then I’d focus on engagement, since we have a meaningful amount of users on FB ap"
Arthur Y. - "Clarifying Questions/Statements:
Clarify understanding of Fundraisers:
My answer: product that lets users create fundraisers for a particular cause, and invite/share it with other users to donate to that cause. Usually set for a certain target donation amount to be met, and a timeframe for which a user can donate to the cause
Are we assuming the lifecycle of the Fundraisers product today? If so, then I’d focus on engagement, since we have a meaningful amount of users on FB ap"See full answer
" Thanks a lot for showing us how a recommender system can be build. I see it was proposed to use Collaborative filtering which is user - item matrix having dimension N * M (where N - number os users and M - number of songs). Though, it was explained how it gonna be built, it is still unclear how all users and songs features are going to be used. In that matrix we have values in cell (lets say i, j) like 1 - a specific user (i) clicked on song (j) when it was recommended or it is 0 when the user"
Dinar M. - " Thanks a lot for showing us how a recommender system can be build. I see it was proposed to use Collaborative filtering which is user - item matrix having dimension N * M (where N - number os users and M - number of songs). Though, it was explained how it gonna be built, it is still unclear how all users and songs features are going to be used. In that matrix we have values in cell (lets say i, j) like 1 - a specific user (i) clicked on song (j) when it was recommended or it is 0 when the user"See full answer
"System architecture diagram. Define API params, responses, tradeoffs between caching and webhooks to update message delivery status."
Kaitlyn M. - "System architecture diagram. Define API params, responses, tradeoffs between caching and webhooks to update message delivery status."See full answer
"find total sum. assign that to rightsum
traverse from left to right: keep updating left sum and right sum, when they match return the index.
else if you reach end return -1 or not found"
Rahul J. - "find total sum. assign that to rightsum
traverse from left to right: keep updating left sum and right sum, when they match return the index.
else if you reach end return -1 or not found"See full answer
"I most want to communicate a few principals of conflict resolution that I believe were integral in this situation, which are mutual respect, a results orientation, an unwavering focus on the user.
To that end, here’s how I’d like to structure this answer: First, I’ll tell you about the project we were working on, to provide some background for you. Second, I’ll describe the disagreement. Third, I’ll describe how we arrived at a solution, and finally, I’ll discuss how those 3 conflict resolu"
Ross B. - "I most want to communicate a few principals of conflict resolution that I believe were integral in this situation, which are mutual respect, a results orientation, an unwavering focus on the user.
To that end, here’s how I’d like to structure this answer: First, I’ll tell you about the project we were working on, to provide some background for you. Second, I’ll describe the disagreement. Third, I’ll describe how we arrived at a solution, and finally, I’ll discuss how those 3 conflict resolu"See full answer
"With $1 billion to invest in generative AI, my focus would be on addressing unmet needs in everyday life. Here's my vision:
Identify User Pain Points: I would start by understanding the specific challenges a segment of users face daily. Many people are integrating AI into their routines to simplify tasks, yet there are gaps that need to be filled.
Learn from ChatGPT’s Success: ChatGPT's rapid growth to 200 million users demonstrates the demand for AI solutions that genuinely solve"
Aayush S. - "With $1 billion to invest in generative AI, my focus would be on addressing unmet needs in everyday life. Here's my vision:
Identify User Pain Points: I would start by understanding the specific challenges a segment of users face daily. Many people are integrating AI into their routines to simplify tasks, yet there are gaps that need to be filled.
Learn from ChatGPT’s Success: ChatGPT's rapid growth to 200 million users demonstrates the demand for AI solutions that genuinely solve"See full answer
"Great question.
As a Product Manager, it is common to have to have difficult conversations with clients, stakeholders, or co-workers. This question actually reminds me of a time that I was faced with having to tell a client that the original estimate we gave them was much lower than it should have been and would, therefore, take much longer and cost a lot more as well.
In this scenario, we had to work within a client's legacy codebase and didn't realize the limitations, roadblocks, and barrie"
Kiley S. - "Great question.
As a Product Manager, it is common to have to have difficult conversations with clients, stakeholders, or co-workers. This question actually reminds me of a time that I was faced with having to tell a client that the original estimate we gave them was much lower than it should have been and would, therefore, take much longer and cost a lot more as well.
In this scenario, we had to work within a client's legacy codebase and didn't realize the limitations, roadblocks, and barrie"See full answer
"Situation - A time I dealt with conflict while on a team was while I was working at Shopify on physical and digital gift card refund point of sale solutions. The situation was that we were dealing with complex technical constraints including not changing particular UI components behavior to act as they should be intended. On the refund screen, the existing design was using a toggle on the same screen to bring up a modal for gift card selection to either select digital or physical options. Thi"
Ben G. - "Situation - A time I dealt with conflict while on a team was while I was working at Shopify on physical and digital gift card refund point of sale solutions. The situation was that we were dealing with complex technical constraints including not changing particular UI components behavior to act as they should be intended. On the refund screen, the existing design was using a toggle on the same screen to bring up a modal for gift card selection to either select digital or physical options. Thi"See full answer
"Let's take Google Fitbit as the product and analyze how to identify its competitors.
1. Identify Direct Competitors (Similar Wearables & Smartwatches)
Fitbit is a fitness tracker and smartwatch brand, so direct competitors include:
Apple Watch Series (Apple)
Samsung Galaxy Watch (Samsung)
Garmin Wearables (Garmin)
Amazfit & Zepp (Huami)
Xiaomi Mi Band (Xiaomi)
These brands offer smartwatches or fitness bands with similar health-tracking features.
2. Use Launch Events for Insi"
Rajdeep J. - "Let's take Google Fitbit as the product and analyze how to identify its competitors.
1. Identify Direct Competitors (Similar Wearables & Smartwatches)
Fitbit is a fitness tracker and smartwatch brand, so direct competitors include:
Apple Watch Series (Apple)
Samsung Galaxy Watch (Samsung)
Garmin Wearables (Garmin)
Amazfit & Zepp (Huami)
Xiaomi Mi Band (Xiaomi)
These brands offer smartwatches or fitness bands with similar health-tracking features.
2. Use Launch Events for Insi"See full answer
"Hi Everyone,
As an aspiring product manager, I feel with the latest Ray-Ban or Orion AR glasses that provides hands-free experience to the user. So basically, with these glasses you can interact, ask it to remember where you parked and what can you make with the ingredients which are in front of you, I think an extension to it can be a very great healthcare product.
Now let's imagine that this glass is storing all your eating habits, what medicines you take, with an integration to meta watches"
Pankhuri T. - "Hi Everyone,
As an aspiring product manager, I feel with the latest Ray-Ban or Orion AR glasses that provides hands-free experience to the user. So basically, with these glasses you can interact, ask it to remember where you parked and what can you make with the ingredients which are in front of you, I think an extension to it can be a very great healthcare product.
Now let's imagine that this glass is storing all your eating habits, what medicines you take, with an integration to meta watches"See full answer
"Are we speaking of all Meta Ads products on something specific?
All of them
Meta is a social media and AI company that generates most of it's revenue from Ads on social media.
Meta's mission is to empower people to build communities and bring the world closer together.
If ads violate the community guidelines regulations that can directly hurt both Meta's mission and its revenue stream.
For example ads that include hate speech are against community guidelines and also hurts Meta's mission. Ha"
Yair G. - "Are we speaking of all Meta Ads products on something specific?
All of them
Meta is a social media and AI company that generates most of it's revenue from Ads on social media.
Meta's mission is to empower people to build communities and bring the world closer together.
If ads violate the community guidelines regulations that can directly hurt both Meta's mission and its revenue stream.
For example ads that include hate speech are against community guidelines and also hurts Meta's mission. Ha"See full answer
"Great. I will start by understanding the goal of Google Photos and how it aligns with the goal and mission of Google. After defining goals, I will talk about the user actions which will contribute towards this goal. Based on these actions, we will define metrics.
Check-in with the interviewer on the approach here. Assuming that this looks good for the interviewer to proceed.
Google Photo - Helping users organise & manage their pictures. Completely in line with Google's mission.
Thinking ab"
Harshit G. - "Great. I will start by understanding the goal of Google Photos and how it aligns with the goal and mission of Google. After defining goals, I will talk about the user actions which will contribute towards this goal. Based on these actions, we will define metrics.
Check-in with the interviewer on the approach here. Assuming that this looks good for the interviewer to proceed.
Google Photo - Helping users organise & manage their pictures. Completely in line with Google's mission.
Thinking ab"See full answer
"All products and services have to sell. I would create measurements on how much time, labor, and funds went into a project and how much value it brings back to customers and company."
John H. - "All products and services have to sell. I would create measurements on how much time, labor, and funds went into a project and how much value it brings back to customers and company."See full answer