"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
"Clarifying questions:
Can I assume the timeframe to be today, ie Dec 2024? : Yes
What country are we targeting? Lets say it is India.
When we say "Use google search to find a new job" do we mean to say that they use Google search in their job search process or also convert and actually find a job? : The former.
I am assuming we are only considering when someone directly searches jobs on Google and not searches for some job search portal on google: Yes.
How long should the search"
Kartikeya N. - "Clarifying questions:
Can I assume the timeframe to be today, ie Dec 2024? : Yes
What country are we targeting? Lets say it is India.
When we say "Use google search to find a new job" do we mean to say that they use Google search in their job search process or also convert and actually find a job? : The former.
I am assuming we are only considering when someone directly searches jobs on Google and not searches for some job search portal on google: Yes.
How long should the search"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
"Explained the charts with using
Scatter Plot with Size and Color Encoding
X-axis: Ride duration (in minutes).
Y-axis: Total fare (in dollars).
Point size: Encodes the star rating (e.g., larger points for higher ratings).
Point color: Indicates whether the rating is favorable (green) or unfavorable (red).
Heatmap for Correlation Analysis
Why: Heatmaps are ideal for quickly identifying patterns and correlations between variables.
How:
Create a heatmap matrix where rows represent ride durat"
Saisandeep M. - "Explained the charts with using
Scatter Plot with Size and Color Encoding
X-axis: Ride duration (in minutes).
Y-axis: Total fare (in dollars).
Point size: Encodes the star rating (e.g., larger points for higher ratings).
Point color: Indicates whether the rating is favorable (green) or unfavorable (red).
Heatmap for Correlation Analysis
Why: Heatmaps are ideal for quickly identifying patterns and correlations between variables.
How:
Create a heatmap matrix where rows represent ride durat"See full answer
Business Analyst
Analytical
🧠Want an expert answer to a question? Saving questions lets us know what content to make next.
"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
"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
"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
"Questions? -Geography - US/ International
Model? SEXY? Model 3 Most used.
Timeline - 3 Quarters?
Increase engagement? - Existing people
Tesla - Electric company that builds EV cars.
Mission- To accelerate the world's transition to sustainable energy?
Mission
Why - To increase the engagement - active users
Recent Trends - Apps are rising on Apple Watch
Ease of Use? Portability?
Customer Segments
New people who bought Tesla
Existing People
Models - Model 3
Fleet Owners ["
Anonymous Tortoise - "Questions? -Geography - US/ International
Model? SEXY? Model 3 Most used.
Timeline - 3 Quarters?
Increase engagement? - Existing people
Tesla - Electric company that builds EV cars.
Mission- To accelerate the world's transition to sustainable energy?
Mission
Why - To increase the engagement - active users
Recent Trends - Apps are rising on Apple Watch
Ease of Use? Portability?
Customer Segments
New people who bought Tesla
Existing People
Models - Model 3
Fleet Owners ["See full answer
"Clarifying question: just want to make sure that I'm designing the right product, are you referring to ATM as in a machine that takes in a debit or credit card and dispenses cash? Also, is there any location restriction for where the machine is located at London Heathrow Airport, eg. departure hall after security or arrival hall before exiting baggage claim? These could potentially impact the use case. (Assume interviewer answers yes for first and no for second)
Approach:
Identify or segment"
Anonymous Sparrow - "Clarifying question: just want to make sure that I'm designing the right product, are you referring to ATM as in a machine that takes in a debit or credit card and dispenses cash? Also, is there any location restriction for where the machine is located at London Heathrow Airport, eg. departure hall after security or arrival hall before exiting baggage claim? These could potentially impact the use case. (Assume interviewer answers yes for first and no for second)
Approach:
Identify or segment"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
"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
"Good Discussion on the distributed messaging queues (Complex topic with lot of nuances)
Liked the mind-map style drawing of requirements and metrics capture
Touched on different types of queue styles (point to point, pub-sub, fan-out/fan-in)
Storage and WAL usage was interesting
Some distributed queue challenges that could be helpful to highlight / expand are:
Message guarantee / semantics - Ordering of messages across different servers
Replication
Master slave architecture or Pe"
Karthik R. - "Good Discussion on the distributed messaging queues (Complex topic with lot of nuances)
Liked the mind-map style drawing of requirements and metrics capture
Touched on different types of queue styles (point to point, pub-sub, fan-out/fan-in)
Storage and WAL usage was interesting
Some distributed queue challenges that could be helpful to highlight / expand are:
Message guarantee / semantics - Ordering of messages across different servers
Replication
Master slave architecture or Pe"See full answer
"Two clarification questions first! When we say quarters, are we assuming the quarters are stacked on top of each other, or are we measuring across the diameter? let's say they are stacked. And second question, is the height of the building just from the ground floor to the top of the building? yes.
Okay, the key numbers we need to find then are the height of the building in feet, and the # of quarters that fit into a foot.
First for the height of the building, the key numbers are heigh"
Helen Z. - "Two clarification questions first! When we say quarters, are we assuming the quarters are stacked on top of each other, or are we measuring across the diameter? let's say they are stacked. And second question, is the height of the building just from the ground floor to the top of the building? yes.
Okay, the key numbers we need to find then are the height of the building in feet, and the # of quarters that fit into a foot.
First for the height of the building, the key numbers are heigh"See full answer
"Would love to have transcripts posted below videos with timestamps to help us browse the video when video lengths are typically longer"
Hl M. - "Would love to have transcripts posted below videos with timestamps to help us browse the video when video lengths are typically longer"See full answer
"Clarify
Read more what & where? -> Books. Where -> upto candidate
Who are we? -> A big tech company
Goal -> to help people read more books
Assumptions
Books which aren't education/work related. Basically books that you read in your free time
Read doesn't necessarily mean read text, it means looking at and making sense of what is displayed. and display can be in any form -> text or image or video
Customers
Kids in age of 5-12 years
Teens
Adults
Elderly
We pick kids in age of 5-1"
Anonymous Crayfish - "Clarify
Read more what & where? -> Books. Where -> upto candidate
Who are we? -> A big tech company
Goal -> to help people read more books
Assumptions
Books which aren't education/work related. Basically books that you read in your free time
Read doesn't necessarily mean read text, it means looking at and making sense of what is displayed. and display can be in any form -> text or image or video
Customers
Kids in age of 5-12 years
Teens
Adults
Elderly
We pick kids in age of 5-1"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
"Situation : During my time in my previous company, I was leading a program which involved a cross-functional team. The project was to migrate all the legacy servers to Azure and had a tight deadline of 4 months. Each team had distinct goals and responsibilites to be delivered
Task : My task was to collaborate with the multi regional team and ensure a smooth delivery within the defined budget and schedule.
Action : I believe communication is the key to handle a cross-functional team"
Oriole O. - "Situation : During my time in my previous company, I was leading a program which involved a cross-functional team. The project was to migrate all the legacy servers to Azure and had a tight deadline of 4 months. Each team had distinct goals and responsibilites to be delivered
Task : My task was to collaborate with the multi regional team and ensure a smooth delivery within the defined budget and schedule.
Action : I believe communication is the key to handle a cross-functional team"See full answer