Interview Questions

Gloriose H. - "Required output in the solution not the one requested from the question. only customerid, firstname, last_name and years were required. Please this needs to be very clear. Otherwise my answer is with totalorderyear as ( SELECT o.customer_id, c.first_name, c.last_name, EXTRACT(YEAR FROM o.orderdate) AS orderyear, COUNT(o.orderid) AS totalorders FROM orders o LEFT JOIN customers c ON c.customerid = o.customerid GROUP BY o.customerid, c.firstname, c.last"See full answer

Snehangsu B. - "In a recent implementation of a large core banking project where we were breaking away from monolithic architecture to microservice based one we faced a situation where customer wanted to have a single repository of user and role management. Since Micro service based architecture talks about individual entities for multiple product suite it was mandatory to maintain individual user base. Based on the customer feedback, we had to come up with an unique design of single user base and replicating"See full answer

Chloe T. - "Mock interview 2/3/2025 Google Wallet User Needs (pain points): At physical store: understand the price tag proceed the transaction Audio cue to pick one credit card read the payment machine transaction confirmation (optional) balance hear transaction summary At home: check balance make payment send money receive money understand statement Prioritization Understand the price tag"See full answer

Rahul J. - "find total sum. assign that to rightsum traverse from left to right: keep updating left sum and right sum, when they match return the index. else if you reach end return -1 or not found"See full answer

Amparo L. - "One time at Lifetime Fitness 2019, One student was throwing a lot of towels in the counter which made things very disorganized, then I made a compromise with my coworker to put 2 towels at a time and then it worked well because it made the workspace very organized."See full answer

P K. - "Assumptions: Part of the core FB product and not standalone app/ Education for children in 13-18 range Goal: To improve the education of children while building stronger social networks with their family/friends and thus further the mission of the company of bringing the world together and offering tools to form communities. Key user segments: Students (middle and high school) Teachers Parents For the purpose of this exercise, I would like to focus on the student user gr"See full answer

Anonymous Stork - "Roadblocks or obstacles are common when working on projects. It's essential to navigate them and quickly find solutions to ensure timely delivery and success of your projects. Steps to handle roadblocks or obstacles: Gauge the potential imapct and decide if it's something that needs immediate solution or something that can be handled later. If it needs urgent solutions, try to understand the rootcause of the roadblock or obstacle and dig deep. If it's a already seen problem before, try"See full answer

Shivam B. - "To address this question, I'll assume that Horizon Worlds is a virtual reality platform offering immersive experiences and content to users. As a Product Manager at HW, my approach would be to focus on metrics that align with the growth stages of the product. I'll use the AARRR framework (Acquisition, Activation, Retention, Revenue, Referral) to guide our analysis. Assumptions: Horizon Worlds is primarily a content-driven virtual reality platform. The business model includes both free"See full answer

Takashi M. - "My approach is try to narrow down by 4W1H. When - When this happened? Still continuously happen the problem? Where - Is this happen specific region or entire customers? What - What kind of problem? One time big error or any data show the curve? Who - Is it all platform or specific platform (Web, iOS, Android) How - How serious problem? How many customer affected? Next step is to narrow down the causes is from internal factors or external factors. For internal factors: Any recent up"See full answer

Kinjal S. - "Shopping funnel and engagement: Global search brings up food items from multiple restaurants but results don't directly lead users to the item in the restaurant. Retention and repeat: Users are not able to earn and burn store-specific rewards. Similarly stores/restaurants can't build direct relationship w/ the customers and provide custom offers Multi-store cart and checkout. Currently DD supports cart and checkout from a single restaurant at a time. Many times customers want to order f"See full answer

dan - "Approach: 1) clarify and communicate baseline assumptions. 2) communicate how solving for this will align to FB's mission. 3) define the user groups we are solving for 4) Define the user journey pre/during/after natural disasters 4.a) pick a user group we want to go with 5) identify the painpoints for this user groups user journey 6) think about solutions 7) prioritize and elaborate 1) clarify and communicate baseline assumptions. Q: Can you tell me why FB is interesting in building"See full answer

Tiago R. - "function isValid(s) { const stack = []; for (let i=0; i < s.length; i++) { const char = s.charAt(i); if (['(', '{', '['].includes(char)) { stack.push(char); } else { const top = stack.pop(); if ((char === ')' && top !== '(') || (char === '}' && top !== '{') || (char === ']' && top !== '[')) { return false; } } } return stack.length === 0"See full answer

Shivam G. - "My Favourite music application - YT Music YT music is a music streaming service for individuals. YT Music is exclusive for YT Premium members. Users : Listeners Creator Ops (internal to Youtube) Business Goal : Improve Listener engagement by 20% in the next 6 months. Listener Engagement - DAU (Activity is defined as listened to music for at-least 10 mins) Listener User Segments : Music Enthusiasts Music for relaxation Which segment has the opportunity? List Pain"See full answer

Saurabh K. - "Missing Item - User ordered multiple items, few items are missing Wrong Item - Entire order is wrong / there are items in the order that were never ordered How is this measured ? CSAT Missing Items Wrong Items Step 1 : Collect data on orders that reported missing / wrong items. Dive deep to understand if the problem is isolated to a specific metro/zip code/restaurant type (say fast food vs fine dine), time of day (lunch vs dinner), tenure of the courier on th"See full answer