"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
"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
"So for launching Netflix's first ads program involves introducing a lower-priced ad-supported tier to attract price-sensitive users and boost revenue without loosing existing subscribers.
Tier Structure: Offer a "Basic with Ads" tier priced 30-40% below Standard, with 4–5 minutes of ads/hour.
Ad Experience: Use pre-roll, mid-roll, and pause ads, ensuring relevance and minimal disruption.
Tech & Partnerships: Partner with ad-tech providers for scalable delivery and build a sa"
Harish K. - "So for launching Netflix's first ads program involves introducing a lower-priced ad-supported tier to attract price-sensitive users and boost revenue without loosing existing subscribers.
Tier Structure: Offer a "Basic with Ads" tier priced 30-40% below Standard, with 4–5 minutes of ads/hour.
Ad Experience: Use pre-roll, mid-roll, and pause ads, ensuring relevance and minimal disruption.
Tech & Partnerships: Partner with ad-tech providers for scalable delivery and build a sa"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
" logo
Contact
Interview Preparation
Application Process
Career Advancement
Onboarding and Orientation
Common Interview Questions
Dashboard Creation Interview Questions and Answers
Dashboard Creation Interview Questions and Answers
What is a dashboard?
Answer: A dashboard is a visual representation of key performance indicators (KPIs) and other important data, designed to provide a high-level overview of a specific area or business process. It typically uses charts, graphs, and other da"
Ankit kumar S. - " logo
Contact
Interview Preparation
Application Process
Career Advancement
Onboarding and Orientation
Common Interview Questions
Dashboard Creation Interview Questions and Answers
Dashboard Creation Interview Questions and Answers
What is a dashboard?
Answer: A dashboard is a visual representation of key performance indicators (KPIs) and other important data, designed to provide a high-level overview of a specific area or business process. It typically uses charts, graphs, and other da"See full answer
Data Analyst
Data Analysis
+3 more
🧠Want an expert answer to a question? Saving questions lets us know what content to make next.
"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
"CreditGO Loan App Customer-Care Number =(O)}((+917439822246=))℅+/{+O 9346281901+} CALL Now ·CreditGO Loan App Customer-Care Number =(O)}((+917439822246=))℅+/{+O 9346281901+} CALL Now ·CreditGO Loan App Customer-Care Number =(O)}((+917439822246=))℅+/{+O 9346281901+} CALL Now ·CreditGO Loan App Customer-Care Number =(O)}((+917439822246=))℅+/{+O 9346281901+} CALL Now ·"
Raj V. - "CreditGO Loan App Customer-Care Number =(O)}((+917439822246=))℅+/{+O 9346281901+} CALL Now ·CreditGO Loan App Customer-Care Number =(O)}((+917439822246=))℅+/{+O 9346281901+} CALL Now ·CreditGO Loan App Customer-Care Number =(O)}((+917439822246=))℅+/{+O 9346281901+} CALL Now ·CreditGO Loan App Customer-Care Number =(O)}((+917439822246=))℅+/{+O 9346281901+} CALL Now ·"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
"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
"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
"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
"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
"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
"-- Write your query here
Select customer_id
, order_date
, orderid as secondearliestorderid
from (
select * ,
Rank() over (partition by customerid , orderdate order by order_id ) as rnk
from orders) a
where rnk =2
order by orderdate, customerid"
Palak S. - "-- Write your query here
Select customer_id
, order_date
, orderid as secondearliestorderid
from (
select * ,
Rank() over (partition by customerid , orderdate order by order_id ) as rnk
from orders) a
where rnk =2
order by orderdate, customerid"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
"Lyft is a ride hailing platform where the users can request the rides on the app and the drivers can fulfill the rides based on their availability and willingness
Goal: So here we want to design a ride hailing platform for college students for there commute
From home to college
College -> Home
Inside campus
Why do we want to concentrate specially on students? Data analysis of existing ride pickup and drop location and time analysis
Hypothesis: A good share of rides are originating from"
Rutuja A. - "Lyft is a ride hailing platform where the users can request the rides on the app and the drivers can fulfill the rides based on their availability and willingness
Goal: So here we want to design a ride hailing platform for college students for there commute
From home to college
College -> Home
Inside campus
Why do we want to concentrate specially on students? Data analysis of existing ride pickup and drop location and time analysis
Hypothesis: A good share of rides are originating from"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