Interview Questions

Bradley E. - "I'm pretty sure Exponent's answer is wrong. In the snippet below, they use "pl.name = 'Telephones' to attempt to filter down to the Telephone transactions, but they do this within a LEFT JOIN which means all product_lines rows are returned. > LEFT JOIN product_lines pl > ON p.productlineid = pl.id > AND pl.name = 'Telephones' Below is my solution. Also, I didn't see anywhere that said the "amount" column was in cents instead of dollars, but I still divided by 100 to be consistent with Exp"See full answer

stash - "Clarification What category of Marketplace are we setting a goal for as there are several sub-marketplaces? —> We are looking at overall Marketplace Are we focused globally or in the US? —> Lets limit to the US To set the Goal for FB marketplace I will start by describing the product, go over goals for the users (buyers / sellers) and the business (FB), review user actions, list metrics and then summarize our goal for marketplace and choose a few keys metrics to track our progress towa"See full answer

Prajwal M. - "from typing import List def maxprofitgreedy(stock_prices: List[int]) -> int: l=0 # buying r=1 # selling max_profit=0 while rstock_prices[l]: profit=stockprices[r]-stockprices[l] maxprofit=max(maxprofit,profit) else: l=r r+=1 return max_profit debug your code below print(maxprofitgreedy([7, 1, 5, 3, 6, 4])) `"See full answer

Poha - "Design the cache, set policy like LRU or other custom policies."See full answer

Gomathi S. - "I product manage customer care - while I belong to the ecommerce platform team. customer care is not a direct contributor for revenue and the feedback i received during my career progression was unless i contribute to revenue i cannot be on promotion track. this is difficult feedback to act on as its not by job responsibility. worked with my manager on 2 fronts - 1) create a succession plan so i can take on additional responsibility that contributes to revenue and 2) create a plan on how care ca"See full answer

Khushbu R. - "Let’s say the matrix is m x n (i.e., m rows and n columns). Start from the top-right corner of the matrix. Move left if you see a 1. Move down if you see a 0. Keep track of the row index where you last saw the leftmost 1 — that row has the most 1s. public class MaxOnesRow { public static int rowWithMostOnes(int matrix) { int rows = matrix.length; int cols = matrix[0].length; int maxRowIndex = -1; int j = cols - 1; /"See full answer

Sandeep Y. - "Functional requirement's: partial search while searching for users, products any keywords in the search. additional keywords in the filter Black listed words in the search. Non functional requirements: low latency, search through 2 Billion records recent search should be cached. Design: high reads, we should have caching enabled over the primary db storages. caching cluster can be added when the search load increases. read ahead. - check in cache (periodic cache refresh), lfu, lru "See full answer

Scarlett S. - "Clarifying and definition of the metrics By creations down by 5%, how do you calculate the drop? the how % user create stories has dropped, or the overal stories being created fewer, could be average stories created by a user drops. Basically, how do you calculate the creation and drop? They have similarities, but it reveals diffrent type user behahviors. Assume they say fewer people create fewer stories , both, Just to be confirm that, we saw a 5% change/dig in how many user"See full answer

Rajeev K. - "Here's how I'd approach investing that $10 million over the next year and a half. The biggest chunk about $4 million would go straight into our core infrastructure because that's what everything else depends on. We're seeing massive demand for real-time payments, so I'd put $2.5 million into building instant settlement capabilities and integrating with FedNow and RTP rails. The remaining $1.5 million would beef up our platform scalability because we're hitting capacity limits during peak times,"See full answer

Sathi C. - "Being a team player is very important to a small to medium team where each individual play a role to set the culture of collaboration for the team. I will definitely be coaching my report to improve on becoming a team player and trying to influence to understand why it is utterly important for her/his individual growth and success. A ship can not be built by only two hands and any disconnect within the team can prove to be costly."See full answer

Product V. - "Clarifying Questions What is definition of blind - people who cannot see Is this also inclusive of partially blind - No Does this cater people who are blind naturally or got blind due to some illness or accident - Only natural Why do you want to build it - what is the intended goal Improve the smartphone experience Do we expect the users any kind of phone experience when we talk about this device - Yes, basic phone experience with accessibility features "See full answer

Kartikeya N. - "Clarifying questions We are referring to Facebook here within Meta products, correct?: Yes Can we base the CAC as of 2025?: yes Facebook acquires users through multiple channels, are we focussed on any particular channel? : We are looking at an overall CAC for Facebook What all do we want to include in CAC? Can we limit it to the marketing and advertising costs and leave aside technical, infrastructure or people costs?: yes Here’s how I will calculate this. **Customer acquisition c"See full answer

Riku H. - "Great question - this is similiar to the "should uber go into rides for kids?" type of question so it's mostly strategy but also part design the way the question is phrased. Purely design would be " Tell me how you would build uber for kids" Assumption here is Uber in India functions the same as anywhere else in the world, is that correct? Yes, but in India they also take cash payments OK, what about safety regulations like car seats? (needs clarificaitons) What about driver licensing in Ind"See full answer

Anuradha T. - " I will attempt to answer this. Barnes and Nobles Nook, although Amazon had an advantage in terms of being early to market (2007) with the Kindle, B&N Nook could have been marketed Nook more creatively, given that B&N has access to massive inventories of books in digital format. It fell short of: Focusing on the differentiation in marketing Being aggressive in marketing tactics by promoting the Nook at events, webinars, out-of-store marketing Attracting the user base by highlighting the m"See full answer

Kirit K. - "Had to refactor code at recent startup after having it fully deployed and working. This was due to us hitting some performance and UX issues. What I did was refactor the core engine first myself, and then line up a work team to progressively refactor the edges and exception flows that sit around the core. Completed in 4 weeks."See full answer