"This system design question is very small compared to other questions like design instagram, twitter, google drive etc... Since the design involves less components the level of detail we have to go in them were deep. I had to explain how to deal with all the NFR for the distributed cache system. Whether it is a push model or a pull model. Hade to do BOE calculations for the database too."
Jagan M. - "This system design question is very small compared to other questions like design instagram, twitter, google drive etc... Since the design involves less components the level of detail we have to go in them were deep. I had to explain how to deal with all the NFR for the distributed cache system. Whether it is a push model or a pull model. Hade to do BOE calculations for the database too."See full answer
"-- The text of the task is a bit confusing. If the status is repeated several
-- times, then in the end you should show as start_date the date of the first
-- occurrence, and in end_date the date of the last occurrence of this status,
-- and not the date of the beginning of the next status
with t1 as (select
order_id,
status,
orderdate as startdate,
lead(orderdate) over (partition by orderid order by orderdate) as enddate,
ifnull(lag(status) over (partition by order_id order by or"
Alexey T. - "-- The text of the task is a bit confusing. If the status is repeated several
-- times, then in the end you should show as start_date the date of the first
-- occurrence, and in end_date the date of the last occurrence of this status,
-- and not the date of the beginning of the next status
with t1 as (select
order_id,
status,
orderdate as startdate,
lead(orderdate) over (partition by orderid order by orderdate) as enddate,
ifnull(lag(status) over (partition by order_id order by or"See full answer
"Clarifying questions -
Alexa HW, Alexa SW, Alexa particular feature?
Assumption - Pick any. Picking HW due to relevance with my background.
Any particular pain point that we are trying to address, or any specific goal that I should be aware of?
Assumption - None. Mine to pick.
Goal for Amazon is to be the most customer centric company. To extend the same vision - With Alexa HW our goal is to provide the best customer experience possible.
**Restating problem state"
SG - "Clarifying questions -
Alexa HW, Alexa SW, Alexa particular feature?
Assumption - Pick any. Picking HW due to relevance with my background.
Any particular pain point that we are trying to address, or any specific goal that I should be aware of?
Assumption - None. Mine to pick.
Goal for Amazon is to be the most customer centric company. To extend the same vision - With Alexa HW our goal is to provide the best customer experience possible.
**Restating problem state"See full answer
"The key approach in this situation is to practice the model of Collaborate, Mentor, Coach, and Care.
First, Collaborate with the co-worker to Identify the situation. Listen Listen Listen. understand the issues that the respective co-worker is going through and identify the root cause if it's internal or external.
In case the issue is not real or just a misunderstanding or it's the case of employee morale then I would mentor the co-worker and try to motivate him/her. Provide examples (if poss"
DM - "The key approach in this situation is to practice the model of Collaborate, Mentor, Coach, and Care.
First, Collaborate with the co-worker to Identify the situation. Listen Listen Listen. understand the issues that the respective co-worker is going through and identify the root cause if it's internal or external.
In case the issue is not real or just a misunderstanding or it's the case of employee morale then I would mentor the co-worker and try to motivate him/her. Provide examples (if poss"See full answer
Behavioral
🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.
"Union−Find
-We illustrate our basic approach to developing and analyzing algorithms by considering the dynamic connectivity problem. We introduce the union−find data type and consider several implementations (quick find, quick union, weighted quick union, and weighted quick union with path compression). Finally, we apply the union−find data type to the percolation problem from physical chemistry.
Analysis of Algorithms
-The basis of our approach for analyzing the performance of algorithms is th"
Katie - "Union−Find
-We illustrate our basic approach to developing and analyzing algorithms by considering the dynamic connectivity problem. We introduce the union−find data type and consider several implementations (quick find, quick union, weighted quick union, and weighted quick union with path compression). Finally, we apply the union−find data type to the percolation problem from physical chemistry.
Analysis of Algorithms
-The basis of our approach for analyzing the performance of algorithms is th"See full answer
"(This was not search autocomplete based on prefix matching question.)
First of all, please note :- The interviewer is not expecting you to get to the right answer in just 1 hr. These systems have been designed over months and improved over years and its impractical for anyone to expect you to get to the right answer in 1 hr. (There is no one single right answer).
At the end, the interviewer (director level person) told me the same. What they are looking for is your thought process, getting from"
shg - "(This was not search autocomplete based on prefix matching question.)
First of all, please note :- The interviewer is not expecting you to get to the right answer in just 1 hr. These systems have been designed over months and improved over years and its impractical for anyone to expect you to get to the right answer in 1 hr. (There is no one single right answer).
At the end, the interviewer (director level person) told me the same. What they are looking for is your thought process, getting from"See full answer
"General Approach:
In a funnel, prospects that dropped off at the very end just before conversion are the ones that were most likely to convert simply because they went through the effort of going through multiple steps to advance to the very end of the funnel. The more the prospects advances through the funnel, better their probability of converting. I'd therefore focus more on reducing drop-offs at the final stages of the funnel for better conversion.
Caveats:
There are certain use-cases where"
Niji R. - "General Approach:
In a funnel, prospects that dropped off at the very end just before conversion are the ones that were most likely to convert simply because they went through the effort of going through multiple steps to advance to the very end of the funnel. The more the prospects advances through the funnel, better their probability of converting. I'd therefore focus more on reducing drop-offs at the final stages of the funnel for better conversion.
Caveats:
There are certain use-cases where"See full answer
"Clarifying questions
Define relevant? Google should keep progressing in solving customer usecases / increasing revenue and profitability over next 10 yrs
Since we are discussing about 10 yr period, can i assume that we need not have any constraints in mind? Yes, do not consider any constraints
Just to be clear this is about Google in specific and not about Alphabet and various companies within the group. Yes, let's focus on google
Last assumption, can we assume that the overall goal / vi"
P D. - "Clarifying questions
Define relevant? Google should keep progressing in solving customer usecases / increasing revenue and profitability over next 10 yrs
Since we are discussing about 10 yr period, can i assume that we need not have any constraints in mind? Yes, do not consider any constraints
Just to be clear this is about Google in specific and not about Alphabet and various companies within the group. Yes, let's focus on google
Last assumption, can we assume that the overall goal / vi"See full answer
"Clarification:
What do we mean by success for YouTube search? Is it focused on user satisfaction, watch time, or ease of finding relevant content?
What do we mean by search? Does it refer to the search bar on the YouTube homepage, or are we including other types of search (e.g., FAQ, help documentation)?
Is there any specific area or metric the team is focusing on (e.g., engagement, retention, monetization)?
Structure:
1. Business Context
YouTube Vision: To give"
Ram - "Clarification:
What do we mean by success for YouTube search? Is it focused on user satisfaction, watch time, or ease of finding relevant content?
What do we mean by search? Does it refer to the search bar on the YouTube homepage, or are we including other types of search (e.g., FAQ, help documentation)?
Is there any specific area or metric the team is focusing on (e.g., engagement, retention, monetization)?
Structure:
1. Business Context
YouTube Vision: To give"See full answer
"Automated Reimbursement System
1. Clarifying Questions
Scope: Will the system be applicable to all employees or only specific grades/levels?
Ownership: Are we building this product internally for our own use, or is it intended for external/outsourced usage?
MVP Requirements: Besides automation, what additional features or problem statements should the Minimum Viable Product (MVP) address?
2. User Segmentation
Commute Expenses: e.g., m"
Kiran R. - "Automated Reimbursement System
1. Clarifying Questions
Scope: Will the system be applicable to all employees or only specific grades/levels?
Ownership: Are we building this product internally for our own use, or is it intended for external/outsourced usage?
MVP Requirements: Besides automation, what additional features or problem statements should the Minimum Viable Product (MVP) address?
2. User Segmentation
Commute Expenses: e.g., m"See full answer
"· How well the team is self-motivated and contributing overall success of the company by releasing high quality bug prone releases
· Growth of their team members
· Does the manager encouraging and supporting career switch based on the individual desire or passion"
BePostive - "· How well the team is self-motivated and contributing overall success of the company by releasing high quality bug prone releases
· Growth of their team members
· Does the manager encouraging and supporting career switch based on the individual desire or passion"See full answer
"Clarifying question:
Is there a goal that we have in mind?
Fb mission: empower people to create community and bring the world closer together
IG shops as I understand are the marketplace on IG, where users can view items listed for sale by creators/businesses and also search for specific items or categories. Users can actually buy through shops instead of getting navigated to the original business website.
IG shop goals: Businesses continue to face the challenges of selling onli"
Aimable - "Clarifying question:
Is there a goal that we have in mind?
Fb mission: empower people to create community and bring the world closer together
IG shops as I understand are the marketplace on IG, where users can view items listed for sale by creators/businesses and also search for specific items or categories. Users can actually buy through shops instead of getting navigated to the original business website.
IG shop goals: Businesses continue to face the challenges of selling onli"See full answer
"If it's a product end to end, then there's a lot to say. If it's just a feature on top of a product then I will focus on the complexity and how I break complex tasks into small milestones to partner with XFN teams to nail it. Focus on situation, task, actions and results"
S G. - "If it's a product end to end, then there's a lot to say. If it's just a feature on top of a product then I will focus on the complexity and how I break complex tasks into small milestones to partner with XFN teams to nail it. Focus on situation, task, actions and results"See full answer
"Goal - Use latest technology to efficiently drive DMV processes
User landscape -
DMV Employees
Public
Clarify if we designing for employee productivity, employee shifts, automate internal processes for DMV OR for Public who uses DMV services
Lets assume it is for Public.
So My prompt and new goal becomes: DMV app to reduce foot traffic to DMV by automating processes online
Is that correct to assume?
User Journey today:
User walkins to DMV -> A
User takes online appointment -> Fill sin"
Surbhi G. - "Goal - Use latest technology to efficiently drive DMV processes
User landscape -
DMV Employees
Public
Clarify if we designing for employee productivity, employee shifts, automate internal processes for DMV OR for Public who uses DMV services
Lets assume it is for Public.
So My prompt and new goal becomes: DMV app to reduce foot traffic to DMV by automating processes online
Is that correct to assume?
User Journey today:
User walkins to DMV -> A
User takes online appointment -> Fill sin"See full answer
"What‘s the goal of increasing Spotify’s premium subscribers? - To monetize and get more premium subscribers
Users: Target users could potentially fall in 3 categories
1) Users who are interested in paying a premium price for great curated playlists
2) Users who are interested in listening to music but not willing to pay a price
Targeting #1
Pain points:
1) As a user I wouldn’t want to subscribe to something w/o being listening to the playlists
2) If I do subscribe I would like to receiv"
Anuradha T. - "What‘s the goal of increasing Spotify’s premium subscribers? - To monetize and get more premium subscribers
Users: Target users could potentially fall in 3 categories
1) Users who are interested in paying a premium price for great curated playlists
2) Users who are interested in listening to music but not willing to pay a price
Targeting #1
Pain points:
1) As a user I wouldn’t want to subscribe to something w/o being listening to the playlists
2) If I do subscribe I would like to receiv"See full answer