"As I understand it, you’d like me to design a mobile native application (for iOS or Android) that helps people manipulate data similar to that of Microsoft Excel or Google Sheets. You can add and import data, edit it, run calculations, regressions, and generate charts and graphs.
If it’s ok with you, I’d like to confine the design to iOS, and based on my knowledge of how a product manager uses a spreadsheet.
I’d like to approach this problem by first identifying the goal of the app. Since we’r"
David I. - "As I understand it, you’d like me to design a mobile native application (for iOS or Android) that helps people manipulate data similar to that of Microsoft Excel or Google Sheets. You can add and import data, edit it, run calculations, regressions, and generate charts and graphs.
If it’s ok with you, I’d like to confine the design to iOS, and based on my knowledge of how a product manager uses a spreadsheet.
I’d like to approach this problem by first identifying the goal of the app. Since we’r"See full answer
"Clarifying questions:
Location: Mountian view campus. [Google has campuses across the world and for the interview purpose design the product for Mountian view campus]
Assumption : Scope of the design is on-campus travel purpose between buildings.
Product: Digital product
Target Customer segments
Meetings: Googlers who takes bikes to commute to a different build for meetings.
a. Goal: On-Time for meetings
Lunch or breakfast: Lunch spot co-ordinat"
S K. - "Clarifying questions:
Location: Mountian view campus. [Google has campuses across the world and for the interview purpose design the product for Mountian view campus]
Assumption : Scope of the design is on-campus travel purpose between buildings.
Product: Digital product
Target Customer segments
Meetings: Googlers who takes bikes to commute to a different build for meetings.
a. Goal: On-Time for meetings
Lunch or breakfast: Lunch spot co-ordinat"See full answer
"Clarified with interviewer:
How it is used ?
user will give facebook page of school as input
What is the criteria for declaring school as duplicate ?
same name and location
used exposed APIs of parent service to create and maintain a inverted index [msg queue+spark].
Duplicate matching service will use elastic search [and filter out input school page]. Elastic will search and return results of school name and geospatial matching ."
A S. - "Clarified with interviewer:
How it is used ?
user will give facebook page of school as input
What is the criteria for declaring school as duplicate ?
same name and location
used exposed APIs of parent service to create and maintain a inverted index [msg queue+spark].
Duplicate matching service will use elastic search [and filter out input school page]. Elastic will search and return results of school name and geospatial matching ."See full answer
System Design
🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.
"Bitshift the number to the right and keep track of the 1's you encounter. If you bitshift it completely and only encounter one 1, it is a power of two."
Nils G. - "Bitshift the number to the right and keep track of the 1's you encounter. If you bitshift it completely and only encounter one 1, it is a power of two."See full answer
"A DOS attack is meant to shut down a machine or network, making it inaccessible to its intended users. Some mitigations would be knowing what normal and abnormal traffic is. Deploy Firewalls for sophisticated application attacks."
Adriel W. - "A DOS attack is meant to shut down a machine or network, making it inaccessible to its intended users. Some mitigations would be knowing what normal and abnormal traffic is. Deploy Firewalls for sophisticated application attacks."See full answer
"Clarifying questions:
Reason to add this feature? No particular reason but let's assume it's an industry practice
Any resource constraints? None for now
I am assuming all furniture sold on the site is Wayfair's and not sold by third parties? Yes
Approach:
Industry, company and product profile and target audience
Wayfair is a e-commerce company selling furniture.
Direct competitors are other online only businesses like amazon. Indirect competition include physical stores like home depot/l"
Anonymous Beaver - "Clarifying questions:
Reason to add this feature? No particular reason but let's assume it's an industry practice
Any resource constraints? None for now
I am assuming all furniture sold on the site is Wayfair's and not sold by third parties? Yes
Approach:
Industry, company and product profile and target audience
Wayfair is a e-commerce company selling furniture.
Direct competitors are other online only businesses like amazon. Indirect competition include physical stores like home depot/l"See full answer
"This question is a Diagnosis Question.
Let's follow the template for answering Diagnosis Questions:
Ask clarifying questions
List potential high level reasons
Gather context (with TROPIC method!)
Establish a theory of probably cause
Test theories
Give a potential solution
Summarize
Ask Clarifying Questions
Before we begin, it's important to ask clarifying questions if necessary. This question is quite straight forward so we may not have ma"
Exponent - "This question is a Diagnosis Question.
Let's follow the template for answering Diagnosis Questions:
Ask clarifying questions
List potential high level reasons
Gather context (with TROPIC method!)
Establish a theory of probably cause
Test theories
Give a potential solution
Summarize
Ask Clarifying Questions
Before we begin, it's important to ask clarifying questions if necessary. This question is quite straight forward so we may not have ma"See full answer
"I have not been at SFO airport but if it would have been a similar busy airport like Mumbai Airport I would use the following approach.
Re-iterating the question: We are interested in improving the experience for users who drop their cars in airport parking. The experience in question starts from the moment they enter the parking area till the time they board the plane.
Core metrics that define the experience for users:
Time taken to board the flight from the time I reached at the parking z"
Anubhav A. - "I have not been at SFO airport but if it would have been a similar busy airport like Mumbai Airport I would use the following approach.
Re-iterating the question: We are interested in improving the experience for users who drop their cars in airport parking. The experience in question starts from the moment they enter the parking area till the time they board the plane.
Core metrics that define the experience for users:
Time taken to board the flight from the time I reached at the parking z"See full answer
"Let's assume that the school furniture includes Table, Chair and Whiteboard. Now, the first step is to find the number of students in the U.S
Let's assume that the population of the U.S is 300M. Let's assume that Americans start education at 5 years old till 25 for undergrad. It means Americans spend 20 years of their life in school. Average living years for people is 80.
20/80 * 100 = 25%. It means 25% of the American population attends college.
25/100*300M = 75M.
So, there are 75M students"
Anonymous Shrimp - "Let's assume that the school furniture includes Table, Chair and Whiteboard. Now, the first step is to find the number of students in the U.S
Let's assume that the population of the U.S is 300M. Let's assume that Americans start education at 5 years old till 25 for undergrad. It means Americans spend 20 years of their life in school. Average living years for people is 80.
20/80 * 100 = 25%. It means 25% of the American population attends college.
25/100*300M = 75M.
So, there are 75M students"See full answer
"Timeline and trends
analyze period when the CTR was down
Check external factors
Seasonality and holidays
Competitive factors
Industry-wide changes
Ad performance analysis
Ad copy
Product feed quality
Pricing
Promotions and discounts
Audience targeting and segmentation
Specific demographics?
User segment?
Device across mobile, desktop, and tablet
Ad placement and auction insights
Anything changed with ad placement?"
Varun J. - "Timeline and trends
analyze period when the CTR was down
Check external factors
Seasonality and holidays
Competitive factors
Industry-wide changes
Ad performance analysis
Ad copy
Product feed quality
Pricing
Promotions and discounts
Audience targeting and segmentation
Specific demographics?
User segment?
Device across mobile, desktop, and tablet
Ad placement and auction insights
Anything changed with ad placement?"See full answer
"
read_dir(path: str) -> list[str] returns the full path of all files and sub- directories of a given directory.
is_file(path: str) -> bool: returns true if the path points to a regular file.
is_dir(path: str) -> bool: returns true if the path points to a directory.
read_file(path: str) -> str: reads and returns the content of the file.
The algorithm: notice that storing all the file contents' is too space intensive, so we can't read all the files' contents to store and compare with each"
Idan R. - "
read_dir(path: str) -> list[str] returns the full path of all files and sub- directories of a given directory.
is_file(path: str) -> bool: returns true if the path points to a regular file.
is_dir(path: str) -> bool: returns true if the path points to a directory.
read_file(path: str) -> str: reads and returns the content of the file.
The algorithm: notice that storing all the file contents' is too space intensive, so we can't read all the files' contents to store and compare with each"See full answer
"If I get to live my life again I will try to be more confident, it took me a life time to get some confidence and to be what I am today, I ll try to be less dependent on others, I ll work for women empowerment."
Umaira K. - "If I get to live my life again I will try to be more confident, it took me a life time to get some confidence and to be what I am today, I ll try to be less dependent on others, I ll work for women empowerment."See full answer