Interview Questions

Helen Z. - "Two clarification questions first! When we say quarters, are we assuming the quarters are stacked on top of each other, or are we measuring across the diameter? let's say they are stacked. And second question, is the height of the building just from the ground floor to the top of the building? yes. Okay, the key numbers we need to find then are the height of the building in feet, and the # of quarters that fit into a foot. First for the height of the building, the key numbers are heigh"See full answer

Bala G. - "SELECT s.Sale_Date, SUM(si.Quantity * si.SalePrice) AS TotalRevenue FROM Sales s JOIN SaleItems si ON s.SaleID = si.Sale_ID GROUP BY s.Sale_Date ORDER BY s.Sale_Date; "See full answer

Harshit G. - "Great question. My favourite product is YouTube Music. Let's see on what its strategy should be for next year. Clarifying questions No clarifying questions on this as I will be working with my favourite products. I will have few assumptions which I will state out before we proceed. Assumptions Assuming that we need to come up with strategy for YouTube Music app - not considering YouTube as a whole as part of this. I am considering overall audio streaming as the space to come up with the s"See full answer

Kapil D. - "Overall a very good summary of ranking problems. I wish there are more details in the post on depth of modeling. One can talk more about advance ML architectures like DCN, BertRec etc"See full answer

Anonymous Bee - "Which structure would you suggest for such a question?"See full answer

Hl M. - "Would love to have transcripts posted below videos with timestamps to help us browse the video when video lengths are typically longer"See full answer

Ross B. - "I most want to communicate a few principals of conflict resolution that I believe were integral in this situation, which are mutual respect, a results orientation, an unwavering focus on the user. To that end, here’s how I’d like to structure this answer: First, I’ll tell you about the project we were working on, to provide some background for you. Second, I’ll describe the disagreement. Third, I’ll describe how we arrived at a solution, and finally, I’ll discuss how those 3 conflict resolu"See full answer

Arthur Y. - "Clarifying Questions/Statements: Clarify understanding of Fundraisers: My answer: product that lets users create fundraisers for a particular cause, and invite/share it with other users to donate to that cause. Usually set for a certain target donation amount to be met, and a timeframe for which a user can donate to the cause Are we assuming the lifecycle of the Fundraisers product today? If so, then I’d focus on engagement, since we have a meaningful amount of users on FB ap"See full answer

Anonymous Moth - "As a Business Analyst, I would employ a cross-functional approach for implementing virtual debit and credit cards by collaborating closely with various departments. Initially, I would work with the market research team to understand customer needs and industry trends. With the IT and security teams, I would focus on designing a robust, user-friendly, and secure virtual card system. Collaboration with the legal department would ensure compliance with financial regulations. Partnering with the mar"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

Indranil G. - "So we need to only consider Delhi within city limits? Yes And will we consider the big trees and not bushes? Yes Now inside Delhi total size is 1484 sq km means 2000000 sq km In this, there are 2% area which is lake or water so remove that will be (2000000-( 2000000 km*2%) )= 1960000 sq km In this area in Delhi, we have 20 % area where it is a park that means ( 1960000- (1960000*20%)) = 1568000 km area nonpark and 392000 km is a park area Obviously, in the park area, the density will b"See full answer

Debajyoti B. - "Understanding the problem: What do we mean by email notification experience here? Is it the quantity of notifications or quality?- it's the quality of the experience i.e. how can we make the experience better & more user centric How would you define enhance in this context?- here enhacement means improving the engagement with the emails resulting in more people viewing the photo/s on FB with email as source Are we supposed to enhance the viewer's experience only or the creators as w"See full answer

Kartikeya N. - "Clarifying questions: Can I assume the timeframe to be today, ie Dec 2024? : Yes What country are we targeting? Lets say it is India. When we say "Use google search to find a new job" do we mean to say that they use Google search in their job search process or also convert and actually find a job? : The former. I am assuming we are only considering when someone directly searches jobs on Google and not searches for some job search portal on google: Yes. How long should the search"See full answer

LateArriver - "A mature manager. Great conversational answer. I wish more sessions with him"See full answer

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

Philip C. - "Initial Assumptions I’m going to assume that this is a blue sky question, and there aren’t any constraints in terms of geo, funding, etc. With that in mind, one deeply unoptimized product is… a parking meter. I’ll assume for the sake of this answer that we’re focusing on parking in an urban environment since that’s where most parking-related friction exists. I’m also going to assume that we’re a startup and don’t have any special strengths/ weaknesses that we need to account for"See full answer

Kiley S. - "Great question. As a Product Manager, it is common to have to have difficult conversations with clients, stakeholders, or co-workers. This question actually reminds me of a time that I was faced with having to tell a client that the original estimate we gave them was much lower than it should have been and would, therefore, take much longer and cost a lot more as well. In this scenario, we had to work within a client's legacy codebase and didn't realize the limitations, roadblocks, and barrie"See full answer