"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"
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
"Evaluate how much the issue affects the sprint goal and timeline. If it blocks the main goal, it needs to be prioritized.
Discuss the issue with the team.
Analyze the root cause of the issue. Is it because of unclear requirements or a design flaw? You may need to re-prioritize tasks.
If the issue is serious enough to delay or change the sprint goal, communicate the updates to stakeholders and manage their expectations.
Keep an eye on the solution’s progress and adjust your plans a"
Hamzeh J. - "Evaluate how much the issue affects the sprint goal and timeline. If it blocks the main goal, it needs to be prioritized.
Discuss the issue with the team.
Analyze the root cause of the issue. Is it because of unclear requirements or a design flaw? You may need to re-prioritize tasks.
If the issue is serious enough to delay or change the sprint goal, communicate the updates to stakeholders and manage their expectations.
Keep an eye on the solution’s progress and adjust your plans a"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
"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."
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
"#include
#include
#include
using namespace std;
vector diff(const vector& A, const vector& B) {
unordered_set elements;
vector result;
for (const auto& element : A) {
elements.insert(element);
}
for (const auto& element : B) {
if (elements.find(element) == elements.end()) {
result.push_back(element);
} else {
elements.erase(element);
}
}
for"
Chinmay S. - "#include
#include
#include
using namespace std;
vector diff(const vector& A, const vector& B) {
unordered_set elements;
vector result;
for (const auto& element : A) {
elements.insert(element);
}
for (const auto& element : B) {
if (elements.find(element) == elements.end()) {
result.push_back(element);
} else {
elements.erase(element);
}
}
for"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
"To design a scalable ticketing system for peak events like Black Friday, you must employ a microservices architecture, implement robust load balancing, leverage caching, and use a combination of NoSQL and relational databases for different data types. Key features also include real-time seat booking, secure payment integration, mobile compatibility with QR code validation, robust admin dashboards for analytics, and integrated marketing tools like promo codes. The system needs to prioritize avail"
Teja G. - "To design a scalable ticketing system for peak events like Black Friday, you must employ a microservices architecture, implement robust load balancing, leverage caching, and use a combination of NoSQL and relational databases for different data types. Key features also include real-time seat booking, secure payment integration, mobile compatibility with QR code validation, robust admin dashboards for analytics, and integrated marketing tools like promo codes. The system needs to prioritize avail"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
"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;"
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
"S – Situation:
In a university project, my team was building a collaborative code editor. As part of the functionality, we needed a login system so users could securely access their sessions and collaborate in real time.
T – Task:
I was responsible for implementing the authentication system. Initially, I planned to build the entire login system from scratch, including user management, password storage, and session handling. But as the deadline approached, I realized that implementing thi"
Hamzeh H. - "S – Situation:
In a university project, my team was building a collaborative code editor. As part of the functionality, we needed a login system so users could securely access their sessions and collaborate in real time.
T – Task:
I was responsible for implementing the authentication system. Initially, I planned to build the entire login system from scratch, including user management, password storage, and session handling. But as the deadline approached, I realized that implementing thi"See full answer
"Described a scenario where I joined an established project as an EM
Typical medium sized team - 6 devs, 2 testers, PO, PM (part time) Scrum master (very hands off)
The product was well established and already being used by circa 30000 single country based users for the companies own products (personal banking capabilities)
We were due to go live with a BIG change about 2 months after I joined - this change meant a user could manage multiple personal banking accounts from the 1 interface. We w"
Hans - "Described a scenario where I joined an established project as an EM
Typical medium sized team - 6 devs, 2 testers, PO, PM (part time) Scrum master (very hands off)
The product was well established and already being used by circa 30000 single country based users for the companies own products (personal banking capabilities)
We were due to go live with a BIG change about 2 months after I joined - this change meant a user could manage multiple personal banking accounts from the 1 interface. We w"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
"Overall a very good summary of ranking problems.
I wish there are more details in the post on depth of modeling. One can talk more about advance ML architectures like DCN, BertRec etc"
Kapil D. - "Overall a very good summary of ranking problems.
I wish there are more details in the post on depth of modeling. One can talk more about advance ML architectures like DCN, BertRec etc"See full answer
"I talked about a time that my manager had a better understanding of something than me and that I had to start to ask him what he knew about a certain type of thing once I was getting work assigned"
Anonymous Cheetah - "I talked about a time that my manager had a better understanding of something than me and that I had to start to ask him what he knew about a certain type of thing once I was getting work assigned"See full answer
"I will start with making sure that I have a clear understanding of Medium and how it works. I will ask the interviewer to fill in any gaps in my knowledge of Medium.
Medium is a platform for
novice, and professional writers to express/share their opinions
readers to read about subjects that matter to them
the platform has been running for some time (6-7 years), so it is relatively mature (this confirms that Medium has found a product-market fit)
Here is my high-level structure for answeri"
Rachita D. - "I will start with making sure that I have a clear understanding of Medium and how it works. I will ask the interviewer to fill in any gaps in my knowledge of Medium.
Medium is a platform for
novice, and professional writers to express/share their opinions
readers to read about subjects that matter to them
the platform has been running for some time (6-7 years), so it is relatively mature (this confirms that Medium has found a product-market fit)
Here is my high-level structure for answeri"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
"Great question. My favourite product is YouTube Music. Let's see on what its strategy should be for next year.
Clarifying questions
No clarifying questions on this as I will be working with my favourite products. I will have few assumptions which I will state out before we proceed.
Assumptions
Assuming that we need to come up with strategy for YouTube Music app - not considering YouTube as a whole as part of this.
I am considering overall audio streaming as the space to come up with the s"
Harshit G. - "Great question. My favourite product is YouTube Music. Let's see on what its strategy should be for next year.
Clarifying questions
No clarifying questions on this as I will be working with my favourite products. I will have few assumptions which I will state out before we proceed.
Assumptions
Assuming that we need to come up with strategy for YouTube Music app - not considering YouTube as a whole as part of this.
I am considering overall audio streaming as the space to come up with the s"See full answer