Interview Questions

Chelsea F. - "Questions: Are these bikes for personal or commercial use? Or both? For commuting, or should we also include recreational bikes (e.g. mountain bikes?) Should we include stationary exercise bikes, or only those used outside? E-bikes and motorcycles? Are we counting children, or just adults? Should we factor in whether the individual has purchasing power to purchase a new bike? What about renting a bike? Assumptions: Assuming we are sizing the market for personal commuter bicycles f"See full answer

Sangeeta P. - "Since I am residing in Bangalore, I will consider the Bengaluru airport. The airport has 2 terminals. I am going to consider the security scan done at both the terminals for the estimation. Does it include security scans for both international and domestic flights? --> Both The airport crew members and pilots also go through the security scan. So, should I include only them as well or only the passengers in my calculation? --> Only the passengers Number of people going through the security scan"See full answer

Dominique H. - "Starbucks"See full answer

Siddharth J. - "Google Plus"See full answer

Alexey T. - "with t1 as (select employee_name, department_id, salary, avg(salary) over (partition by departmentid) as avgsalary, abs(salary - avg(salary) over (partition by department_id)) as diff from employees ) select employee_name, department_id, salary, avg_salary, denserank() over (partition by departmentid order by diff desc) as deviation_rank from t1 order by departmentid asc, deviationrank asc, employee_name `"See full answer

Janell O. - "One of the most basic measures of how well a PMO is functioning is the percentage of projects that are completed as a ratio of all the projects in a portfolio. More illustrative is how many of the projects are completed within the timeframes budgeted for the projects."See full answer

Rohan M. - "My solution is simple; it does an in-order DFS traversal to create an array of in-order elements then it searches through the array to find the node we want the successor of. finally we return the node that is 1 after the input node, in the case our input node is the last element of our DFS we know there is no successor, therefore it returns None/null. CODE INSTRUCTIONS: 1) The method fi"See full answer

Namrata L. - "Design a concert ticketing service Clarifying questions Concerting ticket service as in a service which will take care of booking the concert and checking them at the entrance. That's it right? When we say concert, what scale are we talking about? Will we include one-room stand up shows as well or just the big concerts? Mostly on big concerts. Can expand later. Who are we? Are we a third party app or we deal with managing artists? Third party Why are we doing this? Solve the gaps and in"See full answer

Ragupathy V. - "Started with clarifications, listed out assumptions, created stories with user pain points in existing business, how we can eliminate in our design and strategy, metrics for the success of business initial 90 days, 6 months and a year. What i missed to present is the north star metrics Overall i thought i did well, still didnt get through Hope it will help me for other interviews in Amazon/Meta/Cisco"See full answer