"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"
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
"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"
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
"Initial Assumptions
I’m going to assume that this is a blue sky question, and there aren’t any constraints in terms of geo, funding, etc.
With that in mind, one deeply unoptimized product is… a parking meter.
I’ll assume for the sake of this answer that we’re focusing on parking in an urban environment since that’s where most parking-related friction exists.
I’m also going to assume that we’re a startup and don’t have any special strengths/ weaknesses that we need to account for"
Philip C. - "Initial Assumptions
I’m going to assume that this is a blue sky question, and there aren’t any constraints in terms of geo, funding, etc.
With that in mind, one deeply unoptimized product is… a parking meter.
I’ll assume for the sake of this answer that we’re focusing on parking in an urban environment since that’s where most parking-related friction exists.
I’m also going to assume that we’re a startup and don’t have any special strengths/ weaknesses that we need to account for"See full answer
"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"
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
"Clarifying questions:
I assume we're focused on the consumer side of this?
** Yes
I am assuming post booking begins immediately after booking a ticket and ends when the user leaves the airport at their destination. Does that sound right?
** Yes
Goals:
United Airlines wants to get its passengers to their destination seamlessly, safely, and on time.
Users:
I think about user groups in 3 main buckets.
1) 24 hours following booking
2) >24 following booking through 24 hours before boarding
"
Steven M. - "Clarifying questions:
I assume we're focused on the consumer side of this?
** Yes
I am assuming post booking begins immediately after booking a ticket and ends when the user leaves the airport at their destination. Does that sound right?
** Yes
Goals:
United Airlines wants to get its passengers to their destination seamlessly, safely, and on time.
Users:
I think about user groups in 3 main buckets.
1) 24 hours following booking
2) >24 following booking through 24 hours before boarding
"See full answer
Product Manager
Analytical
🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.
"Here's a simpler solution:
select
u.username
, count(p.postid) as countposts
from posts as p
join users as u
on p.userid = u.userid
where p.likes >= 100
group by 1
order by 2 desc, 1 asc
limit 3
`"
Bradley E. - "Here's a simpler solution:
select
u.username
, count(p.postid) as countposts
from posts as p
join users as u
on p.userid = u.userid
where p.likes >= 100
group by 1
order by 2 desc, 1 asc
limit 3
`"See full answer
"Narrow scope of mission:
As a Product Manager for Google Search, my primary mission would be to enhance the search experience for users, ensuring they find the most relevant information quickly and efficiently. This involves continually improving the quality of search results, enhancing the user interface, and exploring innovative features to meet evolving user needs.
Customer segments:
Google Search caters to a diverse range of users, including students, professionals, researchers, and"
Devendra B. - "Narrow scope of mission:
As a Product Manager for Google Search, my primary mission would be to enhance the search experience for users, ensuring they find the most relevant information quickly and efficiently. This involves continually improving the quality of search results, enhancing the user interface, and exploring innovative features to meet evolving user needs.
Customer segments:
Google Search caters to a diverse range of users, including students, professionals, researchers, and"See full answer
"Clarifying Qns:
Did the watch time went down and comments went up for the same videos or are we saying total watch time and total comments on Youtube? (Total)
I am assuming we are not including Youtube Live videos because those are typically live chat 1000’s of comments for a single video. (Correct)
Do we know if these two could be independent problems not correlated with each other (No)
Here is my approach to diagnose the root cause:
Will look at some general trends first
Intern"
Jacob C. - "Clarifying Qns:
Did the watch time went down and comments went up for the same videos or are we saying total watch time and total comments on Youtube? (Total)
I am assuming we are not including Youtube Live videos because those are typically live chat 1000’s of comments for a single video. (Correct)
Do we know if these two could be independent problems not correlated with each other (No)
Here is my approach to diagnose the root cause:
Will look at some general trends first
Intern"See full answer
"My stab at this (feedback welcome):
Total distance for last car 500 meters: Assuming mostly standard cars, average car length + gap = 5 meters.
Acceleration time total 505 seconds: first car reacts slowest, accelerate in 10 seconds. Every other car needs 5 seconds (can see ahead).
Takes 90 seconds to cover 500m: to cover 500m that means 90 seconds (20kph = 10km in 30min = 1km in 3min = 500m in 1.5m)
A bit under 10 minutes = 90s + 505s. Probably a bit less as last car"
Gabe M. - "My stab at this (feedback welcome):
Total distance for last car 500 meters: Assuming mostly standard cars, average car length + gap = 5 meters.
Acceleration time total 505 seconds: first car reacts slowest, accelerate in 10 seconds. Every other car needs 5 seconds (can see ahead).
Takes 90 seconds to cover 500m: to cover 500m that means 90 seconds (20kph = 10km in 30min = 1km in 3min = 500m in 1.5m)
A bit under 10 minutes = 90s + 505s. Probably a bit less as last car"See full answer
"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"
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
"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"
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
"To describe designing a complex system architecture, an AI would outline its analytical, iterative, and constraint-driven approach, highlighting principles like microservices, scalability, and security. An AI's process would be based on patterns learned from vast datasets of successful architectural designs, focusing on adaptability for different applications.
Here is a breakdown of an AI's approach to designing a complex system, followed by a hypothetical example based on its internal knowledge"
Teja G. - "To describe designing a complex system architecture, an AI would outline its analytical, iterative, and constraint-driven approach, highlighting principles like microservices, scalability, and security. An AI's process would be based on patterns learned from vast datasets of successful architectural designs, focusing on adaptability for different applications.
Here is a breakdown of an AI's approach to designing a complex system, followed by a hypothetical example based on its internal knowledge"See full answer
"Clarifyig questons
Why do we want to re-design the feature? are there any existing problem with the existing DM feature? -- you figure out
Do we have any particular goal in mind which we want to achieve? related to Engagement, Session time etc? -- Think yourself
When we say DMs, this includes P2P, Message to business, Message to an open account or you have something else in mind? -- Think yourself
With that bieng said lets first understand what are the core use cases of the DM as a feature
P"
Shoaib H. - "Clarifyig questons
Why do we want to re-design the feature? are there any existing problem with the existing DM feature? -- you figure out
Do we have any particular goal in mind which we want to achieve? related to Engagement, Session time etc? -- Think yourself
When we say DMs, this includes P2P, Message to business, Message to an open account or you have something else in mind? -- Think yourself
With that bieng said lets first understand what are the core use cases of the DM as a feature
P"See full answer
"Limit and rank() only works if there are no 2 employees with same salary ( which is okay for this use case)
For the query to pass all the test results, we need to use dense_rank
with ranked_employees as
(
select id, firstname, lastname, salary,
denserank() over(order by salary desc) as salaryrank
from employees
)
select id, firstname, lastname, salary from ranked_employees
where salary_rank <= 3
`"
Vysali K. - "Limit and rank() only works if there are no 2 employees with same salary ( which is okay for this use case)
For the query to pass all the test results, we need to use dense_rank
with ranked_employees as
(
select id, firstname, lastname, salary,
denserank() over(order by salary desc) as salaryrank
from employees
)
select id, firstname, lastname, salary from ranked_employees
where salary_rank <= 3
`"See full answer
"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."
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
"Approach:
1) Clarify question with interviewer
When we say "app", I'd like to confirm the app for which user. For example, in Rides, we have an app for the rider and an app for the driver. For Eats, we have an experience for a customer purchasing food but I don't know of the experience for the restaurant. Could you confirm which users' experience you're describing when saying "app"?
Let's say rider/customer purchasing food.
Also is this a situation prior to launch of Uber Eats, wh"
Michelle D. - "Approach:
1) Clarify question with interviewer
When we say "app", I'd like to confirm the app for which user. For example, in Rides, we have an app for the rider and an app for the driver. For Eats, we have an experience for a customer purchasing food but I don't know of the experience for the restaurant. Could you confirm which users' experience you're describing when saying "app"?
Let's say rider/customer purchasing food.
Also is this a situation prior to launch of Uber Eats, wh"See full answer
"Wrote up a simple cache system using python dict. Added TTL requirement. Then went into code-level concurrency issues for the cache."
S R. - "Wrote up a simple cache system using python dict. Added TTL requirement. Then went into code-level concurrency issues for the cache."See full answer
"Clarify the Goal (What Does Success Look Like?) Asked: Why is DoorDash launching bikes for Dashers? Is it to:
Expand Dasher availability in dense urban areas?
Lower delivery times or costs?
Increase access to work for those without cars?
Each possible goal shapes the metrics differently.
Broke Metrics into Categories:
Operational Metrics
Measure how well bikes are functioning as a delivery method.
Average delivery time (bike vs car/walk)
Order completion rate for bike Dashers
On-t"
Logan S. - "Clarify the Goal (What Does Success Look Like?) Asked: Why is DoorDash launching bikes for Dashers? Is it to:
Expand Dasher availability in dense urban areas?
Lower delivery times or costs?
Increase access to work for those without cars?
Each possible goal shapes the metrics differently.
Broke Metrics into Categories:
Operational Metrics
Measure how well bikes are functioning as a delivery method.
Average delivery time (bike vs car/walk)
Order completion rate for bike Dashers
On-t"See full answer