Interview Questions

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

Evan R. - "Can someone explain to me the difference between: WHERE orderdate > currentdate - interval '7 days' and WHERE orderdate BETWEEN CURRENTDATE - INTERVAL '6 days' AND CURRENT_DATE Both give the same result in PostrgreSQL, but only the second one passes the test cases."See full answer

Akshay D. - "SELECT SUM(orderquantity) AS totalunitsorderedyesterday FROM orders WHERE order_date = DATE('now', '-1 DAY') `"See full answer

E L. - "WITH CTE AS ( SELECT *, ROWNUMBER()OVER(PARTITION BY utxoid ORDER BY transactionid) AS trxrk FROM transactions JOIN transaction_inputs USING (transaction_id) JOIN utxo USING (utxo_id) ) SELECT transaction_id AS InvalidTransactionId FROM CTE WHERE sender!=address OR trx_rk > 1 `"See full answer

Gowtami K. - "with cte as ( select user_id, timestamp as current_login, lag(timestamp,1) over(partition by userid order by timestamp) as previouslogin , round(abs(julianday(timestamp)-julianday(lag(timestamp,1) over(partition by userid order by timestamp)))2460)as minuteselapsed from useractivitylog where activity_type ='LOGIN' ) select userid, currentlogin, previouslogin, minuteselapsed from cte where currentlogin previouslogin `"See full answer

Evan R. - "The user table no longer exists as expected - I get an error that user does not contain user_id. Note that querying the table results in only user:swuoevkivrjfta select * FROM user `"See full answer

Anonymous Kingfisher - "The interviewer focused on the data models and steered the conversation there from the beginning. He had a specific design in mind and I just wasn't hitting it. He also wanted details on how I would implement the logic for splitting users into variants. I would recommend reading the LinkedIn blog on their AB Test system design."See full answer

Ajay P. - "Designing an evaluation framework for ads ranking is crucial for optimizing the effectiveness and relevance of ads displayed to users. Here's a comprehensive framework that you can use: Define Objectives and Key Performance Indicators (KPIs):** \\Click-Through Rate (CTR):\\ The ratio of clicks to impressions, indicating the effectiveness of an ad in attracting user attention. \\Conversion Rate:\\ The ratio of conversions (e.g., sign-ups, purchases) to clicks, measuring how well"See full answer

Kartikeya N. - "C : Okay. So I would want to start with knowing what is the product for which we have to build a recommendation system. I : This is a photo sharing product. C : Okay. So is this something on the lines of Instagram? I : Yes C : Okay. And are we a new product co or we have some current product built already? I : You can assume yourself. C : Okay. Is there any demography or country we are targeting? I : No, this is a global product C : Okay. So, the biggest goal of any product recommendation system"See full answer