Interview Questions

Eduardo C. - "I started asking some questions regarding the constrains of the system: An antena is emitting a signal that says if the tagged device was out of the room where the interview was happening. I was able to decide which would be the schema for the Antena's message. The antena is sending the info of multiple users. The system doesn't need to push notification to the users when the user left the device behind. Upon reflection, this is what I recollected doing. I propuse the json schema a"See full answer

Naga M. - "PS: Below is my solution. Appreciate if you can provide feedback to improve Followup Questions: Are you referring to Credit Cards or Debit Cards? Assuming it's about Credit Card Why does Capital One want to issue Virtual Cards? (want to know any specific goal in mind) Want to improve security standards which will result in more usage (user purchases) Which user segments do you want to target? (Want to if they are focusing value from a specific user segment)? Assuming they are focu"See full answer

Anonymous Hamster - "talk about product and user not the design its not a UI/UX its a product question still"See full answer

Bimal M. - "Clarification questions: What do you mean by online furniture-selling market? Why would google want to do it? Why does google want to do it now? Where does google want to launch it? Let me make the assumptions answering above questions: It is like google flights, say we call it google furnitures, where it organizes, curates furniture information to the users and then refers to the seller website instead of selling furniture directly to the consumer like amazon, walmart, way"See full answer

Nick S. - "[I'm not sure whether the answer below is the best, as I have not gotten result and feedback from my interview] Ans: I would solve by first using a VAE-style model, to create a latent space embedding that translates user description to generate images. Training would be done on the 1000 avatar images and 100000 descriptions, following this scheme: VAE: description -> encoder -> latent space -> decoder -> image Q: "OK, but that means you're limiting the generated images to be only the 1000 imag"See full answer

Shahrukh K. - "Well, let's see how we can achieve this. Who are YouTube users? Kids students working professionals influencers homemakers Let's pick our user cohort as students. What are students doing on YouTube YouTube learning Entertainment How to increase their session count More relevant content Better recommendation logic Feedback loop to improve recommendation logic Suggestions once they complete a video, save later option, send"See full answer

Namrata L. - "NPS is the Net Promoter Score. It basically measures if the users will promote or recommend our product or not. Do we have any timelines for this? Also Amazon as in the Amazon MarketPlace right? So to improve NPS, we need to improve the customer experience and keep them more engaged. So lets focus on improving engagement. Mission of Amazon - Help users get any and everything by just clicking some buttons at their doorstep. Users Demographics - Teenagers, Young Adults, Adults, Oldies Pro"See full answer

Anonymous Mouse - "Clarify context: I'll assume that I'm a PM at Apple in this case 3 - 5 years: medium to long term thinking. So we're not just thinking about the next release. Any resource constraints? For example, any limitations on the number of engineers I have available, or can I assume that we might be able to deploy the entire iOS eng team to solve this if the problem and solutions are exciting enough? Assume no resource constraints for now, but will be thoughtful about feasibility. Any particular"See full answer

Stanislav I. - "I want to work at Stripe because Stripe has become the industry standard for many businesses and startups in the world. As a CFO I would be proud to work with a leader on a processing market, improving it position with my skills and experience. I will be happy to be a part of this great Team and learn from them."See full answer

Priyanka A. - "I will sit with the client to understand the requirement and priority. On the basis of the priority I will make a sprint plan with team where I will focus on the high priority items first. once sprint plan is done I will distribute roles and responsibility. In daily stand ups I will make sure about ant obstacle team is facing. Regularly check the backlog. I will check the project health daily using JIRA. If everything is going as planned I will release the first increment in"See full answer

Tiffany A. - "SELECT customer_id, order_date, orderid AS secondearliestorderid FROM ( SELECT order_id, customer_id, order_date, ROWNUMBER() OVER (PARTITION BY customerid, orderdate ORDER BY orderid ASC) AS rank FROM orders ) WHERE rank = 2 ORDER BY orderdate, customerid `"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 Tortoise - "SELECT i.item_category, o.order_date, SUM(o.orderquantity) AS totalunits_ordered FROM orders o JOIN items i ON o.itemid = i.itemid WHERE o.order_date >= DATE('now', '-6 days') GROUP BY i.item_category, o.order_date ORDER BY i.item_category ASC, o.order_date ASC;"See full answer

Salome L. - "SELECT items.item_category, SUM(orders.orderquantity) AS totalunitsorderedlast7days FROM orders JOIN items ON orders.itemid = items.itemid WHERE orders.order_date BETWEEN DATE('now', '-6 days') AND DATE('now') GROUP BY items.item_category `"See full answer