Interview Questions

Sid S. - "· Scoping the problem: · What kind of aeroplane - wide / narrow body, single/double deck. Assume normal domestic US plane with about 150 seating capacity Will the plane be empty(no passengers or luggage) - assume yes Will we only fill the cockpit, passenger area and cargo hold or do we need to consider wings, engines, etc - assume no We will consider the theoretical limit and ignore any inefficiencies in arranging the balls Breaking the problem down: Considering the interior o"See full answer

Apurv W. - "Clarify: Understanding of wallets an UPI What is failure rate here? - transaction failed Is it real time failure or successful on front end but failed in backend - assuming it is front end, real time failure. Have other related products/features experienced the same change? Diagnose (impact, significance) Failure rate = assuming it is significantly increasing Impact = customer lifetime value, # of bookings, Avg order value and satisfaction too. Users & value Seller = Revenue "See full answer

Ben G. - "Situation - A situation where I used creative / innovative thinking to eliminate frustration with a product was while I was working on Point of Sale and Polaris for Retail Design System for Shopify. Upon seeing our vision for the future of this design system, it lacked a lot of the visual polish and necessary components that would make the product much more competitive in the market - this included having a lack of an interaction model for what is tappable vs. not tappable as well as containmen"See full answer

Nilanjan D. - "Firstly, congratulations to both the interviewer and interviewee. This was a great learning experience However, being a Full Stack engineer and I was having the following suggestions around the Data Model - Driver & Approval can be two different tables Approval & Document - Approval can be a tuple of (userid,documentid) - comments against a rejection (marks the document which triggers rejection)In this way we can capture the entire history of approval workflow (initiate/pending/appr"See full answer

Erjan G. - "1) select avg(session) from table where session> 180 2) select round(sessiontime/300)*300 as sessionbin, count() as sessioncount from table group by round(sessiontime/300)300 order by session_bin 3) SELECT t1.country AS country_a, t2.country AS country_b FROM ( SELECT country, COUNT(*) AS session_count FROM yourtablename GROUP BY country ) AS t1 JOIN ( SELECT country, COUNT(*) AS session_count FROM yourtablename `GROUP BY countr"See full answer

Hari S. - "Clarifying questions: Is this a standalone product or a Meta integrated product? Which region is this for? US or another region or global? Is this for a county run library or a more informal group community library? Assumptions: It's a meta integrated product US based system group run community library Let's see if a lending library fits into Meta's company mission to build community and bring people closer together. Yes, a lending library does build community by helping peop"See full answer

Anonymous Capybara - "using a relational database isn't a good choice for this system! we need more availability here than consistency (CAP theorem)"See full answer

Esha - "Clarifying Questions What do we mean by ‘improve’? Is there a certain goal that we are trying to attain? Is there a target user that we are going for? Any constraints or things to keep in mind when building this? Assumptions Only focused on google docs and not collaboration on other G-suite products such as PPT or sheets What is Google Docs? Web-based productivity tool that allows you to access your files from any computer through your gmail account. You can also share and"See full answer

Aruna D. - "Assumption #1: the deal is signed and the customer now will being the process of moving to GCP Assumption #2 : the deal includes Iaas as well as Paas (App Engine) - moving apps from on prem to cloud Objective : Design a product that will help the customer onboard and successfully plan the move to GCP. Customer is using on premise and is new to cloud. Lets assume the tool should include the roadmap planning too ie decisions such as moving all vs some applications etc . As in any onboarding to"See full answer

Sabi M. - "there's no audio the last ~10 minutes from the interviewer so we can't get a sense of the feedback from the interviewer. I did think it took the interviewee a little too long to figure out the issue itself and could have benefited from taking some time to think and gather thoughts before jumping into drivers of the issue."See full answer

Saran V. - "Understanding: Understand the reason for the pushback? Is the pushback related to any program constraints such as schedule, cost, quality, or scope? Is this pushback from a single stakeholder or a majority of the stakeholders? Working towards overall program goal: Explain how your idea is tied to the overall program's success metric or the goal Bring in data points to echo the above point Bring in examples of how this approach has helped in the past or with other competitors "See full answer

Malvika S. - "Top three most important variables Uber could use to estimate the ETA for passenger pickup, beyond the ETA on Google Maps can be: Driver related - sometimes driver cancel rides after they are assigned or agree to pickup, especially at odd hours. Sometimes, they can also cancel midway through their journeys. Other factor can be that they drive slower or faster than google maps ETA. Car related - The car may be old or not maintained well than other cars. It can be CNG, Diesel, petrol or elec"See full answer

Manas M. - "I'd ask Clarification questions here before proceeding with designing a CDN. The questions would be. What is the Use Case with multiple questions in it What sort of Content do you want to serve - Static files or Streaming Media or trending content? How many regions do you want to cover Do you want to prioritize speed and the Latest file availability or do you want to prioritize time-based caching per region? Budget constraints(push cdn's can be cheaper). Whether"See full answer

Anonymous Puma - "Assuming for the US Segment by size of businessNumber of employees per business sizePrice per employee=Revenue Price per employee should decrease with a larger employee base. 30M businesses in the US Small Business 60% of businesses are small=18M Average number of employees=50 Price per employee=$5 Small Business Revenue=$2.7B Medium Business 30% of them are medium=9M Average number of employees=1000 Price per employee=$3 Medium Business Revenue=$8.1B Large Business 10% of th"See full answer