"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 architecture diagram. Define API params, responses, tradeoffs between caching and webhooks to update message delivery status."
Kaitlyn M. - "System architecture diagram. Define API params, responses, tradeoffs between caching and webhooks to update message delivery status."See full answer
"#simple solution
1.firstly find the node in the bst (O(logn) time complexity it take)
2.now removing the node consists of 3 cases:
1.if the node is leaf (no children):
(keep track of parent and do)
parent.left or parent.right=NULL
simply remove the node ()
2.if(has one child) replace the node with its child
3.if has both childs
we replace the node with either inorder predesor(max of left tree)or inorder succesor and remove
the node wh"
Sambangi C. - "#simple solution
1.firstly find the node in the bst (O(logn) time complexity it take)
2.now removing the node consists of 3 cases:
1.if the node is leaf (no children):
(keep track of parent and do)
parent.left or parent.right=NULL
simply remove the node ()
2.if(has one child) replace the node with its child
3.if has both childs
we replace the node with either inorder predesor(max of left tree)or inorder succesor and remove
the node wh"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
Execution
Analytical
🧠Want an expert answer to a question? Saving questions lets us know what content to make next.
"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
"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
"Product Understanding -
Ads are what you see from companies as stories, posts, reels. Post are from users (connections). We have to design an experience which produces maximum engagement while generating ad revenue.
Clarifying Questions -
Is it specific to posts/stories/reels ?
Is there an existing post to ads ratio or do we have to start from scratch?
Is it specific to a device/OS?
Is it specific to a region/user demographic?
Assumption -
Existing posts to ads ratio"
Vishal S. - "Product Understanding -
Ads are what you see from companies as stories, posts, reels. Post are from users (connections). We have to design an experience which produces maximum engagement while generating ad revenue.
Clarifying Questions -
Is it specific to posts/stories/reels ?
Is there an existing post to ads ratio or do we have to start from scratch?
Is it specific to a device/OS?
Is it specific to a region/user demographic?
Assumption -
Existing posts to ads ratio"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
"Clarify
10X -> usage or revenue
Approach
What is Msft Copilot & key capabilities
Understand the space in which Copilot operates :
Target segments & use-cases serve
Competitors (alternatives)
Leverage microsoft has :
Understand the stack (infra -> application layer) -> leverage
Understand Microsoft ecosystem & leverage we have
Define : 10X growth strategy (for whom -> & what? -> distribution (acquire & retain))
MSft Copilot & key capabilities
Cons"
Neeraj K. - "Clarify
10X -> usage or revenue
Approach
What is Msft Copilot & key capabilities
Understand the space in which Copilot operates :
Target segments & use-cases serve
Competitors (alternatives)
Leverage microsoft has :
Understand the stack (infra -> application layer) -> leverage
Understand Microsoft ecosystem & leverage we have
Define : 10X growth strategy (for whom -> & what? -> distribution (acquire & retain))
MSft Copilot & key capabilities
Cons"See full answer
"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
"As a Business Analyst, I would employ a cross-functional approach for implementing virtual debit and credit cards by collaborating closely with various departments. Initially, I would work with the market research team to understand customer needs and industry trends. With the IT and security teams, I would focus on designing a robust, user-friendly, and secure virtual card system. Collaboration with the legal department would ensure compliance with financial regulations. Partnering with the mar"
Anonymous Moth - "As a Business Analyst, I would employ a cross-functional approach for implementing virtual debit and credit cards by collaborating closely with various departments. Initially, I would work with the market research team to understand customer needs and industry trends. With the IT and security teams, I would focus on designing a robust, user-friendly, and secure virtual card system. Collaboration with the legal department would ensure compliance with financial regulations. Partnering with the mar"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
"Population of Bangalore - 1.4 cr
On an average 4 people live in 1 householde=> 1.4cr/4 => ~35L HouseHolds
Out of the 35L Household,
30% household
fall below poverty line
are not interested in ordering online due to their own personal reasons
prefers to visit to the hotel directly and eat instead of ordering online => Thus remaining is ~25L households
out of the 25L households,
assuming at least 20% of the households place one order on average on any given day will lead to 5L orders"
Volderdore - "Population of Bangalore - 1.4 cr
On an average 4 people live in 1 householde=> 1.4cr/4 => ~35L HouseHolds
Out of the 35L Household,
30% household
fall below poverty line
are not interested in ordering online due to their own personal reasons
prefers to visit to the hotel directly and eat instead of ordering online => Thus remaining is ~25L households
out of the 25L households,
assuming at least 20% of the households place one order on average on any given day will lead to 5L orders"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
"The question is bit vague (I guess deliberately) so I believe firstly we shall ask questions and resolve ambiguity. Some initial questions could be :
1) Is this one time activity or something that should be done on continuous basis. If continuous basis then at what frequency.
2) How much staleness is acceptable in SYSTEM Y data
3) Are there any limitation in SYSTEM Y and is it fair to assume that we would need some kind of transformation to bring data into SYSTEM Y schema.
4) What kind of vol"
Kshitij A. - "The question is bit vague (I guess deliberately) so I believe firstly we shall ask questions and resolve ambiguity. Some initial questions could be :
1) Is this one time activity or something that should be done on continuous basis. If continuous basis then at what frequency.
2) How much staleness is acceptable in SYSTEM Y data
3) Are there any limitation in SYSTEM Y and is it fair to assume that we would need some kind of transformation to bring data into SYSTEM Y schema.
4) What kind of vol"See full answer
"So we need to only consider Delhi within city limits? Yes
And will we consider the big trees and not bushes? Yes
Now inside Delhi total size is 1484 sq km means 2000000 sq km
In this, there are 2% area which is lake or water so remove that will be (2000000-( 2000000 km*2%) )= 1960000 sq km
In this area in Delhi, we have 20 % area where it is a park that means ( 1960000- (1960000*20%)) = 1568000 km area nonpark and 392000 km is a park area
Obviously, in the park area, the density will b"
Indranil G. - "So we need to only consider Delhi within city limits? Yes
And will we consider the big trees and not bushes? Yes
Now inside Delhi total size is 1484 sq km means 2000000 sq km
In this, there are 2% area which is lake or water so remove that will be (2000000-( 2000000 km*2%) )= 1960000 sq km
In this area in Delhi, we have 20 % area where it is a park that means ( 1960000- (1960000*20%)) = 1568000 km area nonpark and 392000 km is a park area
Obviously, in the park area, the density will b"See full answer