"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"
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
"Functional Requirement
User should be able to add review the food item/order
User should be able to rate the food item delivered
User should be able to Like/Dislike others reviews
User should be able to see all reviews on a food item
Users should be able to receive rewards based on criteria- (Quality of the reviews- Based on number of likes - Monthly cash card)
OOS - Item is already ordered and exists in a separate system, User is authenticated. No Media
Non Functional requireme"
Anshika R. - "Functional Requirement
User should be able to add review the food item/order
User should be able to rate the food item delivered
User should be able to Like/Dislike others reviews
User should be able to see all reviews on a food item
Users should be able to receive rewards based on criteria- (Quality of the reviews- Based on number of likes - Monthly cash card)
OOS - Item is already ordered and exists in a separate system, User is authenticated. No Media
Non Functional requireme"See full answer
"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"
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
"SELECT
s.Sale_Date,
SUM(si.Quantity * si.SalePrice) AS TotalRevenue
FROM Sales s
JOIN SaleItems si ON s.SaleID = si.Sale_ID
GROUP BY s.Sale_Date
ORDER BY s.Sale_Date;
"
Bala G. - "SELECT
s.Sale_Date,
SUM(si.Quantity * si.SalePrice) AS TotalRevenue
FROM Sales s
JOIN SaleItems si ON s.SaleID = si.Sale_ID
GROUP BY s.Sale_Date
ORDER BY s.Sale_Date;
"See full answer
Data Engineer
Coding
+2 more
🧠Want an expert answer to a question? Saving questions lets us know what content to make next.
"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"
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
"Understanding the problem:
What do we mean by email notification experience here? Is it the quantity of notifications or quality?- it's the quality of the experience i.e. how can we make the experience better & more user centric
How would you define enhance in this context?- here enhacement means improving the engagement with the emails resulting in more people viewing the photo/s on FB with email as source
Are we supposed to enhance the viewer's experience only or the creators as w"
Debajyoti B. - "Understanding the problem:
What do we mean by email notification experience here? Is it the quantity of notifications or quality?- it's the quality of the experience i.e. how can we make the experience better & more user centric
How would you define enhance in this context?- here enhacement means improving the engagement with the emails resulting in more people viewing the photo/s on FB with email as source
Are we supposed to enhance the viewer's experience only or the creators as w"See full answer
"In my role as a Product Owner, I was developing a platform for a logistics company.
As a PO and that too of a digital agency, my work was mostly before-end-to-after-end, it would start from pitching, strategy, product management, launch, funding deck prep.
In mid of the product management cycle, the client starts adding pressure to deliver way before the deadline, as they had found the PE firm that conceptually was ready to start funding discussion, since this was not scoped before the start,"
Umang S. - "In my role as a Product Owner, I was developing a platform for a logistics company.
As a PO and that too of a digital agency, my work was mostly before-end-to-after-end, it would start from pitching, strategy, product management, launch, funding deck prep.
In mid of the product management cycle, the client starts adding pressure to deliver way before the deadline, as they had found the PE firm that conceptually was ready to start funding discussion, since this was not scoped before the start,"See full answer
"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"
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
"CQ:
What's the goal - we are just exploring
Any specific timeline we are targeting - NA
Why specifically podcast - its a growing area and can help engage the customers
Any specific geography to be kept on mind - You tell
Approach:
Understand Netflix’s landscape
Understand more about the Podcast space via Porter’s 5 Forces framework
Decide mode of entry
Tradeoffs & Risk
Netflix’s landscape;
Product - OTT player
Who uses - kids, adults
When do they use – leisure"
Anonymous Newt - "CQ:
What's the goal - we are just exploring
Any specific timeline we are targeting - NA
Why specifically podcast - its a growing area and can help engage the customers
Any specific geography to be kept on mind - You tell
Approach:
Understand Netflix’s landscape
Understand more about the Podcast space via Porter’s 5 Forces framework
Decide mode of entry
Tradeoffs & Risk
Netflix’s landscape;
Product - OTT player
Who uses - kids, adults
When do they use – leisure"See full answer
"Designing a Price Drop Tracker system like CamelCamelCamel involves creating a platform that tracks price changes for products on various e-commerce websites and notifies users when prices drop. Here’s a detailed system design for such a service:
Functional Requirements
User Registration and Authentication\:
Users can register and log in.
Support for social media logins (e.g., Google, Facebook).
Product Tracking\:
Users can add products to their watchlist for"
Scott S. - "Designing a Price Drop Tracker system like CamelCamelCamel involves creating a platform that tracks price changes for products on various e-commerce websites and notifies users when prices drop. Here’s a detailed system design for such a service:
Functional Requirements
User Registration and Authentication\:
Users can register and log in.
Support for social media logins (e.g., Google, Facebook).
Product Tracking\:
Users can add products to their watchlist for"See full answer
"In the API design, the interviewer is switching between RPC style (operation based endpoints) and REST style (resource oriented). Sticking to one convention and explaining why it is preferred over the other e.g. REST if the twitter domain maps nicely to resources e.g. /tweet or /follower or /user would help to create a more consistent and unified API. It would make it easier for clients to integrate with the API as well."
dreamingincode - "In the API design, the interviewer is switching between RPC style (operation based endpoints) and REST style (resource oriented). Sticking to one convention and explaining why it is preferred over the other e.g. REST if the twitter domain maps nicely to resources e.g. /tweet or /follower or /user would help to create a more consistent and unified API. It would make it easier for clients to integrate with the API as well."See full answer
"Clarification questions:
What do you mean by online furniture-selling market?
Why would google want to do it?
Why does google want to do it now?
Where does google want to launch it?
Let me make the assumptions answering above questions:
It is like google flights, say we call it google furnitures, where it organizes, curates furniture information to the users and then refers to the seller website instead of selling furniture directly to the consumer like amazon, walmart, way"
Bimal M. - "Clarification questions:
What do you mean by online furniture-selling market?
Why would google want to do it?
Why does google want to do it now?
Where does google want to launch it?
Let me make the assumptions answering above questions:
It is like google flights, say we call it google furnitures, where it organizes, curates furniture information to the users and then refers to the seller website instead of selling furniture directly to the consumer like amazon, walmart, way"See full answer
"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"
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
"Design an alarm clock for blind people
Clarifying question:
Does it have to be a physical product or software? Your call
Do I need to think about the long-term implications of the product from a strategy perspective or a single product? single product
What are the metrics this company will focus on? Engagement
What industry are we in? (start-up, google/Amazon, etc) - Startup
What do we mean by blind? - ppl who cannot see anything, or people who still have sense of"
Manu G. - "Design an alarm clock for blind people
Clarifying question:
Does it have to be a physical product or software? Your call
Do I need to think about the long-term implications of the product from a strategy perspective or a single product? single product
What are the metrics this company will focus on? Engagement
What industry are we in? (start-up, google/Amazon, etc) - Startup
What do we mean by blind? - ppl who cannot see anything, or people who still have sense of"See full answer
"I will divide my answer in 2 parts:
Process I use for managing risks in any Project
I will explain a real life situation where a Risk occurred and how I managed it
Process for Risk Management can be broken down into 3 parts:
Risk Identification: Risk identification is a team effort and is an ongoing process that happens throughout the Project. Technical Risks are usually identified during design/build/testing stage. I maintain a Risk register document to capture all the risks identified"
Saket S. - "I will divide my answer in 2 parts:
Process I use for managing risks in any Project
I will explain a real life situation where a Risk occurred and how I managed it
Process for Risk Management can be broken down into 3 parts:
Risk Identification: Risk identification is a team effort and is an ongoing process that happens throughout the Project. Technical Risks are usually identified during design/build/testing stage. I maintain a Risk register document to capture all the risks identified"See full answer
"I have 2 product feedbacks. I think it has been mentioned by many users of the platform.
Provide a text summary of the videos so that we do not have to watch through the whole interview practice
Actually comment if the interview was good or not, currently we do not really know if the answer given is of high quality
"
Kai H. - "I have 2 product feedbacks. I think it has been mentioned by many users of the platform.
Provide a text summary of the videos so that we do not have to watch through the whole interview practice
Actually comment if the interview was good or not, currently we do not really know if the answer given is of high quality
"See full answer