Interview Questions

Alexey T. - "-- The text of the task is a bit confusing. If the status is repeated several -- times, then in the end you should show as start_date the date of the first -- occurrence, and in end_date the date of the last occurrence of this status, -- and not the date of the beginning of the next status with t1 as (select order_id, status, orderdate as startdate, lead(orderdate) over (partition by orderid order by orderdate) as enddate, ifnull(lag(status) over (partition by order_id order by or"See full answer

Nidhi S. - "There are couple of reasons for it - Kind of role : Its a product manager role loaded with analytical work, So working with data in stringent regulatory guideline make it more exciting and thrilling. Location & industry is like - Cherry on the cake, Bangalore weather and BFI is at its all time peak as people spending behavior is changing continuously, it will be interesting to see big giants like visa are managing it."See full answer

Garima B. - "I faltered on this question. I haven't given a PMM interview in a very long time since I moved from marketing to pure product management. I chose DownDog Yoga App as my preferred app, since I use either either their sleep meditations or the yoga app thrice a week. The feature that was introduced was Aerial Yoga (the interviewer made it as a feature) I went with the assumption that Aerial Yoga is something that needs to be driven off-line rather than online - requires studio space, infrastructr"See full answer

Kay T. - "Clarify: Can I assume I’m a PM at Amazon for the wishlist feature? What is the wishlist feature?You can create a wishlist for yourself of items you want to buy later You can create a wishlist for other people you are shopping for (ex. Christmas, birthdays, etc) You can share this wishlist with others How are we defining “improvement”? (I’m assuming I’m responsible for coming up with the definition) Why do we want to improve the wishlist feature in particular? (Again, I’m responsible"See full answer

Surbhi G. - "When choosing a machine learning algorithm for a system, I take several parameters into account. Initially, I identify the problem's nature, whether it's categorization, regression, clustering, or dimensionality reduction. For instance, if I'm dealing with a classification problem, I might lean towards algorithms like Decision Trees, Logistic Regression, or SVMs. Moreover, the availability of resources, including memory and computation power, is important. For large datasets, I might prefer an a"See full answer

Anonymous Minnow - "Goals (Prod & Safeway) User Groups: Shoppers: College Students Professionals Families Elderly New customers (not already in the store) I selected elderly due to trends on the aging population being a significant population in the next decade and it being a group we have the most opportunity as Safeway to support. Pain Points **Most likely these customers are buying things in person or someone is purchasing items for them and gettin"See full answer

Riku H. - "Great question. Before I start can I start asking some clarifying qs? By video I am assuming this is FB videos where it's selectively fed unto the newsfeed correct? Yes For FB events should the user be fed with their events, their friends, events or also events in their network? Good Q. I would say yes for the purpose of this question that that's all in scope. Is videos the same as reels? No in this case they are similar but different products where FB videos do not have the 90 sec t"See full answer

Nid P. - "I explained the story of trying to help the engineer to improve the performance and after it is failed, the steps I have taken to move the eng to PIP."See full answer

Anonymous Condor - "Yes, I need to compare the first half of the first string with the reverse order of the second half of the second string. Repeat this process to the first half of the second string and the second half of the first string."See full answer

Jessica C. - "select customer_id, order_date, orderid as earliestorder_id from ( select customer_id, order_date, order_id, rownumber() over (partition by customerid, orderdate order by orderdate) as orderrankper_customer from orders ) sub_table where orderrankper_customer=1 order by orderdate, customerid; Standard solution assumed that the orderid indicates which order comes in first. However this is not always the case, and sometime orderid can be random number withou"See full answer

Anonymous Chickadee - "was there a specific scenario given for the interaction?"See full answer

Aravinth K. - "What is your experience with user testing? All products/feature I have worked on B2C space is primarily testing users for a hypothesis. Why B2C? Because you have millions of users who you have not met and also impossible to meet. Hence we formulate hypotheses and evaluate users' behaviour based on our goal. For example, one of the last features I worked on tried to answer the question "Will users who pay their bill using Net Banking use other payment methods if it is not shown to them?" Henc"See full answer

Anonymous Partridge - "We will have to use a second more powerful LLM Model to validate the answers. LLM as a judge"See full answer

Exponent - "This is a Strategy Question, which asks you to justify high-level business decisions and strategy. There's no set formula, but we recommend proposing at least three different reasons to answer the question. Let's go over one possible solution: > If I were TikTok, I would look to monetize it similar to Instagram, Twitter, and Facebook: through dedicated ad channels.Specifically having pre-roll ads appear on open, and ads appear in-feed every few videos. TikTok is the perfect platform to lever"See full answer