Interview Questions

Anonymous Cheetah - "I talked about a time that my manager had a better understanding of something than me and that I had to start to ask him what he knew about a certain type of thing once I was getting work assigned"See full answer

Tiffany A. - "SELECT customer_id, order_date, orderid AS secondearliestorderid FROM ( SELECT order_id, customer_id, order_date, ROWNUMBER() OVER (PARTITION BY customerid, orderdate ORDER BY orderid ASC) AS rank FROM orders ) WHERE rank = 2 ORDER BY orderdate, customerid `"See full answer

Kai H. - "I have 2 product feedbacks. I think it has been mentioned by many users of the platform. Provide a text summary of the videos so that we do not have to watch through the whole interview practice Actually comment if the interview was good or not, currently we do not really know if the answer given is of high quality "See full answer

Karthik T. - "Clarifying questions : I would like to confirm what type of parking spots we are talking about, should we assume cars ? Assumption : Cars Is it referring to only parking spots in non-residential complexes or public places or does it include residential too ?Assumption : both Assumptions : Places where we could see parking spots Shopping malls Parking in the park Residence spots Legal parking spots Variables in play Population = assuming a family of 4 => population / 4 (nu"See full answer

Hamzeh H. - "S – Situation: In a university project, my team was building a collaborative code editor. As part of the functionality, we needed a login system so users could securely access their sessions and collaborate in real time. T – Task: I was responsible for implementing the authentication system. Initially, I planned to build the entire login system from scratch, including user management, password storage, and session handling. But as the deadline approached, I realized that implementing thi"See full answer

S G. - "Clarification questions: How are these metrics calculated? Get context on why these metrics are important? Are we looking at any specific role? Benchmarking: What is the current time to hire? How does this compare to competitors? Do we have a desired goal/target for these metrics? Problem Solving: I began by analyzing the various steps in the hiring process and the number of days taken at each stage. Soon realised that the bulk of the time is taken in a few steps (80/20). Drilled down further"See full answer

Astro S. - "What are they looking for in the answer? "See full answer

Mrinalini R. - "A good answer is describing an experience where you either proposed something that was selected after discussion or an alternate approach was taken, or you disagreed with a decision and argued for something else, either successfully or not. A good answer would be you had cogent arguments, the decision went another way for some reason, and you then fully backed the decision (agree to disagree is another way of stating it). You did not take it personally and you fully committed to the deci"See full answer

Syed I. - "I use a data driven approach by ensuring there is a deep-dive on all alternatives. My approach to tradeoffs is around how to achieve the customer experience needed. I ensure there is an immediate path to green for a solution and a follow-up solution addressing the problem rightly."See full answer

Rahul D. - "Clarifying questions: Revolut aim is to be one stop financial shop (super app) the cross border payments is yet another feature which makes cutomers come to revolut again and again to pay across borders, correct? If so, cross border payments is an important solution for Rev's overall mission and as a principal I would like to agree that whatever feature improvement we suggest should Not take customer outside of Rev App Should continue making Rev's cros border payments best in"See full answer

Scott S. - "Designing a Price Drop Tracker system like CamelCamelCamel involves creating a platform that tracks price changes for products on various e-commerce websites and notifies users when prices drop. Here’s a detailed system design for such a service: Functional Requirements User Registration and Authentication\: Users can register and log in. Support for social media logins (e.g., Google, Facebook). Product Tracking\: Users can add products to their watchlist for"See full answer

Clayton P. - "The interviewer hinted that a two-tower recommender system might be a suitable approach, using user history to embed users and pages separately and train on view or interaction data. Instead, I proposed a different approach that I felt was more aligned with how knowledge is structured in Confluence: I designed a system using a graph database to model the relationships between Confluence pages. Each page is a node, and edges represent content-based references. For example, when one article"See full answer

Anonymous Newt - "CQ: What's the goal - we are just exploring Any specific timeline we are targeting - NA Why specifically podcast - its a growing area and can help engage the customers Any specific geography to be kept on mind - You tell Approach: Understand Netflix’s landscape Understand more about the Podcast space via Porter’s 5 Forces framework Decide mode of entry Tradeoffs & Risk Netflix’s landscape; Product - OTT player Who uses - kids, adults When do they use – leisure"See full answer

Mark H. - "Clarification: workplace is a communication messaging tool for employee to send and receive messages. Why: meta's mission current landscape market trends meta's unique value strength & weakness Workplace Mission: build a communication tool for employees to better collaborate and engage with each other Goal: focus on engagement, not revenue Product ecosystem: Meta Company sourcing department IT department User: sender/receiver #of people log in #of people"See full answer

Bimal M. - "Clarification questions: What do you mean by online furniture-selling market? Why would google want to do it? Why does google want to do it now? Where does google want to launch it? Let me make the assumptions answering above questions: It is like google flights, say we call it google furnitures, where it organizes, curates furniture information to the users and then refers to the seller website instead of selling furniture directly to the consumer like amazon, walmart, way"See full answer

Rita V. - "Gardening product for Meta Clarifying question: Is this going to be a new product? Or part of FB/IG? Gardening as a work? Pleasure? Lets start with META mission - Meta’s mission is to bring people together and form a community. In our case of gardening, it can be smart to solve the case of tips and questions, specially for users that just start to do some gardening. Its a nice hobby and can bring people to work together and support each other. Users I think I will go and seg"See full answer

Alfred O. - "We can use dictionary to store cache items so that our read / write operations will be O(1). Each time we read or update an existing record, we have to ensure the item is moved to the back of the cache. This will allow us to evict the first item in the cache whenever the cache is full and we need to add new records also making our eviction O(1) Instead of normal dictionary, we will use ordered dictionary to store cache items. This will allow us to efficiently move items to back of the cache a"See full answer

Amney M. - "it is really good explanation thanks it is really good explanation thanks"See full answer

Hamzeh J. - "Evaluate how much the issue affects the sprint goal and timeline. If it blocks the main goal, it needs to be prioritized. Discuss the issue with the team. Analyze the root cause of the issue. Is it because of unclear requirements or a design flaw? You may need to re-prioritize tasks. If the issue is serious enough to delay or change the sprint goal, communicate the updates to stakeholders and manage their expectations. Keep an eye on the solution’s progress and adjust your plans a"See full answer