Interview Questions

Anonymous Jaguar - "Code reviews, automated linting, unit tests, integration tests, validation tests"See full answer

Jacky T. - "SELECT order_amount FROM ( SELECT *, rank() OVER(ORDER BY order_amount desc) as ranking FROM departments d LEFT JOIN orders o ON d.departmentid = o.departmentid LEFT JOIN customers c ON o.customerid = c.customerid WHERE department_name = 'Fashion' ) where ranking = 2"See full answer

Anonymous Sparrow - "I would go look in the mirror and ask that person why the legal team is only flagging issues a week ahead of launch date. Did I not engage our legal team way in advance at the conception stage? Did I not follow up or collaborated with my program manager to follow up shortly with the legal team to check their progress of evaluating issues? If I did not do these things, it is on me. Let's assume I did do those things, but the legal team needed a lot of time to evaluate or get external opinion, th"See full answer

Mahesh G. - "Clarifying questions: Is it before pre launch or for it's current business? > Pre launch Goals > Adoption, engagement Can briefly talk about: What the company cares about? (Uber & Uber Eats) Uber: Redefining the world moves for the better Uber Eats: Make eating well effortless at any time, for anyone, anywhere Expectations of consumers and restaurants/Stores Consumers: At one's comfort, one wants the groceries or/and food to be delivered to their"See full answer

Anna H. - "Clarifying questions: How to define “price” in this interview question? Price is defined as the market value of a crypto asset (bitcoin, Ethereum, tether, BNB etc.). Due to the characteristic of crypto assets which is time-sensitive, is this designed for a particular period of time? 1H, 1D, 1W, 1M, 1Y? No Do we know the target customer segment given geographic location or demographic? Not specific. Is it designed across devices? Mobile app. Assumptions: There are 03 cu"See full answer

Ankit J. - "The goal is to determine which shows get promoted to the home screen i.e the screen the user sees after launching Netflix. There are two ways to promote shows today; Editorially - the editorial team selects the categories and shows to be shown to the users Algorithmically - based on the historical views and contextual information such as location, time of the year, age, etc the recommendation algorithm determines a list of shows to show on the screen. The higher level goal for Netflix is o"See full answer

Miguel C. - "Missing launch. Only design is covered."See full answer

Tomer B. - "Clarify What do we mean by memorialize? Are we aiming to launch a physical or software product? What is our goal with this product? Are there specific types of pets we have in mind? Assumption Memorialize means to remind ourselves about our loved pets who passed away. We would like to launch a software product. The goal is to help users cope with the lose of their beloved pets. We also focus on house pets, keeping it for dogs and cats as the biggest market for pets. User"See full answer

Exponent - "This is another Diagnosis problem. To answer this question, we suggest you use our framework (along with the TROPIC method) to be as thorough as possible. The framework is as follows: Ask clarifying questions List potential high level reasons Gather Context (TROPIC)Time Region Other features / products (internal) Platform Industry / Competition Cannibalization Establish a theory of probable cause Test theories Propose solutions Summarize "See full answer

Shankhadip M. - "My least favorite product is a desktop software solution called Marg, which is used frequently at our family business. Its an inventory, bookkeeping, and accounting software for small businesses in India and integrates with the official government tax portal. The general journey to accomplish any task, say adding a new product type, is very unintuitive and requires someone to be hands-on and familiar with the product to actually do this. Getting there is pure hit and trial. Like most desktop sof"See full answer

Mitchell K. - "How technical and specific do you have to go when describing your past projects?"See full answer

Jim T. - "In the end I said number of bookings, but explained how I would get there. I talked about the company's mission first (which I didn't know but guessed it was something about making it easier or more accessible for people to travel) and then talked about a few potential metrics that could fit (bookings, NPS, etc). But in the end I explained that number of bookings is not only tied to their core value proposition, but it also reflected a happy customer base on both sides of the transaction (renter"See full answer

Ihuoma remita U. - "through the combination of online resources, hands on project and community engagement."See full answer

Mitchell K. - "How does team matching and Bootcamp work for PMs?"See full answer

Aimable - "."See full answer

Lucas G. - "Because testing many engagement metrics at once increases the risk of finding effects that aren't real (the 'multiple comparisons problem'), you must adjust your criteria for statistical significance. For social media data, the Benjamini-Hochberg procedure is often a practical choice as it controls the rate of false discoveries (FDR) while still allowing you to detect genuine changes; however, the ideal adjustment method will vary depending on your specific number of metrics (e.g., use Bonferron"See full answer

Akheel M. - "Product recommendation is basically on what you have already viewed / listened etc. It would be based on your clicks, engagement and feedback as well.It mostly works on the most recent experience and sorted by the current experience first ( meeting the above criteria) followed by the relevant sorts by most positive responses in the categories recorded for you."See full answer