"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
"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
"As a PM i received a feedback from my program manager on my style of verbal communication. It is about me speaking faster when i wanted to get away with a topic that i wasn't confident (may be not backed up with data, or still in process of getting detailed insight of a problem etc.). Whereas when I'm confident I tend to speak slowly or more assertively that made people to follow easily.
I welcomed that feedback so from then on when I'm not confident in a topic I became more assertive to let pe"
Rajesh V. - "As a PM i received a feedback from my program manager on my style of verbal communication. It is about me speaking faster when i wanted to get away with a topic that i wasn't confident (may be not backed up with data, or still in process of getting detailed insight of a problem etc.). Whereas when I'm confident I tend to speak slowly or more assertively that made people to follow easily.
I welcomed that feedback so from then on when I'm not confident in a topic I became more assertive to let pe"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
"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
Product Manager
Product Design
🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.
"I would like to speak loud to narrow the scope of this question so I can be effective in identifying a solution to the problem on hand. Hope that is OK.
You mentioned, “Re-design the airport experience”. Is there a goal for this re-design exercise? Some top goals that come to my mind are the following. Please guide me so I can set it and we can proceed from there.
“Increase the number of passengers who travel to and from this airport”
“Improve customer satisfaction”
**“Get in"
Tara J. - "I would like to speak loud to narrow the scope of this question so I can be effective in identifying a solution to the problem on hand. Hope that is OK.
You mentioned, “Re-design the airport experience”. Is there a goal for this re-design exercise? Some top goals that come to my mind are the following. Please guide me so I can set it and we can proceed from there.
“Increase the number of passengers who travel to and from this airport”
“Improve customer satisfaction”
**“Get in"See full answer
"Clarify:
Are we talking about traditional noise-cancelling which cancels noise for listeners or we are talking about the speaker side noise-cancellation? - Interviewer replied: Both
Are we exploring to build something on top of existing hardware around Meta VR products or something in general? - Interviewer replied: up to you.
High level though process (Could be detailed with more structure):
Considering Meta's vision on building metaverse, where meta currently has AR/VR products li"
Anonymous Shark - "Clarify:
Are we talking about traditional noise-cancelling which cancels noise for listeners or we are talking about the speaker side noise-cancellation? - Interviewer replied: Both
Are we exploring to build something on top of existing hardware around Meta VR products or something in general? - Interviewer replied: up to you.
High level though process (Could be detailed with more structure):
Considering Meta's vision on building metaverse, where meta currently has AR/VR products li"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
"So first, I have some clarifying questions, what is Facebook lite?
If I understand correctly this is a version of the Facebook application for Android, with the same functionality but lighter in terms of size. It is aimed to be used in emerging markets where the bandwidth is limited
What are the tradeoffs for the size of the app?
I guess that some visual elements are stripped down from the app and reduced its size
Is this application exist or I am launching it
The timeframe of the product?"
Gadi R. - "So first, I have some clarifying questions, what is Facebook lite?
If I understand correctly this is a version of the Facebook application for Android, with the same functionality but lighter in terms of size. It is aimed to be used in emerging markets where the bandwidth is limited
What are the tradeoffs for the size of the app?
I guess that some visual elements are stripped down from the app and reduced its size
Is this application exist or I am launching it
The timeframe of the product?"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 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
"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
"There are two parts to this questions:
Part 1: Why did Meta create Rooms? ( limiting to video collaboration)
Answer: Potential reasons for Meta to create their own Zoom equivalent:
Provide a video collaboration platform to employees.
Due to size and global distribution of its workforce it may make economic sense to make an in-house product that is cheaper than buying an enterprise license of Zoom
Meta already has the technology and infrastructure to do videocalls and meetings because of"
Tony A. - "There are two parts to this questions:
Part 1: Why did Meta create Rooms? ( limiting to video collaboration)
Answer: Potential reasons for Meta to create their own Zoom equivalent:
Provide a video collaboration platform to employees.
Due to size and global distribution of its workforce it may make economic sense to make an in-house product that is cheaper than buying an enterprise license of Zoom
Meta already has the technology and infrastructure to do videocalls and meetings because of"See full answer
"Before diving into the Solution, I would ask a few clarifying questions.
What is the scope of the fake news
What type of fake news are we focusing on - Political, Health-related, etc
Are we looking at specific examples or a general category of fake news
When you say impact, what do you mean by that? Is it time spent on posts, the nature of the engagement (e.g., likes, shares, comments), and the sentiment of the comments?
User Demographics:
what is the demographic pr"
Bhavna S. - "Before diving into the Solution, I would ask a few clarifying questions.
What is the scope of the fake news
What type of fake news are we focusing on - Political, Health-related, etc
Are we looking at specific examples or a general category of fake news
When you say impact, what do you mean by that? Is it time spent on posts, the nature of the engagement (e.g., likes, shares, comments), and the sentiment of the comments?
User Demographics:
what is the demographic pr"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
"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
"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 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
"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