Interview Questions

Anonymous Roadrunner - "-- Write your query here select id, (case when p_id is null then 'Root' when pid in (select id from treenode_table) and id in (select pid from treenode_table) then 'Inner' else 'Leaf' end) as node_types from treenodetable order by 1; `"See full answer

devopsjesus - "This was a 60 minute assessment. The clock is ticking and you're being observed by a senior+ level engineer. Be ready to perform for an audience. The implementation for the system gets broken up into three parts: Implement creating accounts and depositing money into an account by ID Implement transferring money with validation to ensure the accounts for the transfer both exist and that the account money is being removed from has enough money in it to perform the transfer Implement find"See full answer

Shashikant A. - "I followed STAR format"See full answer

Yag S. - "I studied Exponent's TinyURL system design video. My interviewer was asking many detailed questions on API design, schema, as well as data required to store. I found system design questions are bit high level instead of depth. I think should have detail design of API, schema and some additional flavors."See full answer

Sunflower - "Can you clarify how we define cyberbullying? To me, it means negative or abusive content targeted towards an individual or a group. This can be in the form or text or media. Lets talk about Reddit as a product: To enable positive discussions on diverse topics. Did I miss anything here? Lets talk about users here: We have: Teenagers: 13 - 19 years old Millennials: 20 - 39 years old Gen X and Baby Boomers: 40+ I think teenagers are the most vulnerable and the highest priority group for this use"See full answer

Sridhar K. - "Back in 2019, I had to take a decision of firing an engineer as he was rude and abusive to one of my customers"See full answer

Hari priya K. - "Smart Lock : Clarifying Questions : Are* we *talking about the locks we use for the doors or locks used for suitcases or study lockers ? "Scope is yours" What do we need by smart ? Are we a company that are already in lock business? - Yes Do we have significant marketshare in lock business ? - Yes Are we trying to address or improve any customer pain point or improve our metric? - "No" Customer Segment : Tech savvy - non tech savvy- Customer buys Old"See full answer

Kk - "Clarifying Questions : By reducing bandwidth , do you mean reducing the total size of video transfer reduction ? Ans Yes Is it ok to reduce the resolution by reducing the bandwidth : Ans May be yes and no Any app in particular you are looking forward which could help talking from its standpoint : Ans : Youtube Assumptions : Youtube has a compression algorithm which can still be made better with the evolution of technologies Solutions ( prioritised list ) Improve the compressio"See full answer

Anjesh D. - "I had multiple RCA to complete and each one had a deadline but the process to complete them wasn't streamlined which cause some of them to miss SLA and point of contact felt frustrated as she has no information to give to customer. I received feedback that what blocked me to move forward on those and how can I do better next time?"See full answer

Sachin R. - "If 0's aren't a concern, couldn't we just multiply all numbers. and then divide product by each number in the list ? if there's more than one zero, then we just return an array of 0s if there's one zero, then we just replace 0 with product and rest 0s. what am i missing?"See full answer

Anirudh G. - "Initial Questions: 1.How many patients do you think you will have in the next 5 years? Interviewer: Max 1000 In that case we don't have to build a highly scalable system. 2.Will you be carrying out some procedures like xrays, ct scans or will only be doing consultations? Interviewer: We will be doing minor procedures. Will refer to hospitals for anything major. 3.I see that you mentioned 2 locations. Are there any special billing requirements for each of them? Interviewer: No Users: Fo"See full answer

Alfredo M. - "The question refers to a very specific event: "step into the back for a few minutes, return and see a lot of people waiting"... I might try to clarify goals and scenario: Before I stepped back, there were no ppl waiting? If so, we might be talking about a very specific, even uncommon scenario, in which optimizations for the complete serving system in the long term might not be needed. Maybe they even arrived all together and this is expected behavior. Are people waiting for something specif"See full answer

P K. - "Note: Modifying the question to reflect the storage cost as well. Question: Estimate the cost of storing google photos on the photos app? Clarifying questions: Google photos - an app that syncs automatically to your camera app and uploads photos to Google cloud and reduces the need to store it on your device Cost of 1GB storage $0.002 Time storage cost per year Equation: Cost of storage per year = average cost of storing photos per day x 30 days x 12 months The ave"See full answer

Anonymous Hummingbird - "Q: should this be part of FB or a standalone product? A: no hard requirements, it just has to be something that FB would launch Q: is there a specific region we should be designing for? is it ok that we focus on the US as its the current epiccenter of the pandemic? A: Yes that's fine Q: fighting covid-19 is a very broad goal, what if we translated this into decrease the spread of covid-19 - there's multiple ways we could do that but it makes it a bit more concrete. A: Yes that sounds good "See full answer

Arthur Y. - "Clarifying Questions: By “down”, do we mean creation of messages (activation), engagement, or both? My assumed answer: engagement How are “messages” defined? Is it comments to posts, DMs, or posts themselves? My assumed answer: DMs How is engagement of DMs defined? Is it by number of DMs viewed, created, replied to? My assumed answer: all of that Quick Product Strategy Discussion: Why messaging is important to LinkedIn LinkedIn’s mission is"See full answer

Alice S. - "Clarify the problem. Ask lots of questions to uncover the root cause of the problem. This could be related to internal factors like releasing buggy updates or external factors like market trends, infrastructure, regulation etc etc. Establish where in the user journey the problem might be happening, if it's happening for a subset of users or for everyone e.g. on iOS platform etc etc, what time period has the problem occurred? Gradually or suddenly? How is the metric (in this case revenue)"See full answer

Anonymous Sparrow - "To make sure we are on the same page, this is a feature in the current FB app that would make it easier for people to volunteer? Or more broadly, the feature would aim to expand the base of volunteers. To start I want to dive deeper on the objective of the feature. Then we can look at possible users, pick a segment and outline their needs, then look at some solutions. We can then prioritize and see how we might roll something like this out. If I look at FB mission of building community and brin"See full answer

Pathworks P. - "I would begin by asking the following clarifying questions: Are there any special use cases such as VIP Penthouse access, restricted floors etc? Do we need to consider safety requirements or other technical constraints such as maximum load/capacity? If the lobby for the entire hotel located on the ground floor? Can we assume that the majority of the guest amenities are located near the lobby and lower floors? Can we assume that the passenger controls on the floors are purely directional"See full answer