Interview Questions

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

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

U K. - "Additional of COVID disclaimers to COVID related reels in instagram has helped users to navigate the crisis effectively as well as get the facts addressed regarding the vaccine."See full answer

Niji R. - "General Approach: In a funnel, prospects that dropped off at the very end just before conversion are the ones that were most likely to convert simply because they went through the effort of going through multiple steps to advance to the very end of the funnel. The more the prospects advances through the funnel, better their probability of converting. I'd therefore focus more on reducing drop-offs at the final stages of the funnel for better conversion. Caveats: There are certain use-cases where"See full answer

Ilnur I. - "I can try to summarize their discussion as I remembered. Linear regression is one of the method to predict target (Y) using features (X). Formula for linear regression is a linear function of features. The aim is to choose coefficients (Teta) of the prediction function in such a way that the difference between target and prediction is least in average. This difference between target and prediction is called loss function. The form of this loss function could be dependent from the particular real"See full answer

Ravi teja N. - "I solved it using recursion and then memoization. Used Dynamic programming approach"See full answer

Asish B. - "The supply and demand for Uber Eats may be greatly impacted in the near future by the two macroeconomic factors listed here. Each trend links to large alterations in consumer behavior, labor markets, and cost structures that can cascade across the delivery ecosystem. Changes in Consumer Spending and Inflation Growing Costs and Fees for Food: Customers may order fewer deliveries or choose less expensive goods if food prices, restaurant running costs, or delivery fees increase as a result of"See full answer

Abdurhman M. - "Graphic design is the process of visual communication and problem-solving through the use of typography, photography"See full answer

Adib M. - "Useful article on API migration https://www.linkedin.com/pulse/tips-successful-api-migration-pooja-nihalani/"See full answer

Anonymous Hummingbird - "Q: How do we know that they spend too much time in the app? A: User research/Qualitative survey goal: decrease dissatisfaction that they spend too much time in IG Persona's, lets segment based on usage: New users: just signed up and getting the hang of it lurkers: don't post or engage, just follow contributors: post occasionally (stories + posts) super users/micro influencers: post daily, engage with commenters, spend a lot of time in discover tab IG mission statement is to capture and s"See full answer

Mohit C. - "-- LTV = Sum of all purchases made by that user -- order the results by desc on LTV select u.user_id, sum(a.purchase_value) as LTV from user_sessions u join attribution a on u.sessionid = a.sessionid group by u.user_id order by sum(a.purchase_value) desc"See full answer

Surbhi G. - "Deep Learning is a part of Artificial Intelligence, it's like teaching the machine to think and make decisions on its own. It's like how we teach a child the concept of an apple - it's round, red, has a stem on top. We show them multiple pictures of apples and then they understand and can recognize an apple in future. Similarly, we feed lots of data to the machine, and slowly, it starts learning from that data, and can then make relevant predictions or decisions based on what it has learnt. A co"See full answer

Kasturi K. - "What do you mean by smart lock. It is home locking system or digital locks Assuming it refers to home solutions that Google wants to get to build Customers Homeowners/ Rental Hotels Banks Vehicles Shops Each of the customer segments are good. Let’s investigate some of their characteristics Homeowners/ Rental – Huge Market as every urban house has a need. Hotels – Again the need is very high. Affordability is high. Low desirability to change existing set up. Banks – No"See full answer

Maliki U. - "Here is my implementation: select marketing_channel, AVG(purchasevalue) as avgpurchase_value from attribution group by marketing_channel order by avgpurchasevalue DESC ; There is no need to copy and past the line of code for calculating the average into order by, just Alias is enough because going by the order of execution in sql, Always, order by is executed after executing select clause."See full answer

Michelle D. - "I would first want to confirm my understanding of the reasoning behind no-ads-allowed in the top left of the feed. For this case, I will assume that the rule is not a hard rule and one in which we may test in this prompt. I'd next confirm my understanding of Pinterest's revenue model with the interviewer. My understanding is as follows: Pinterest serves ads to pinners. Conversion (i.e., purchase) via the ad yields some amount of profit to Pinterest. There's some amount of costs associated and"See full answer

Parag L. - "I was in my early days of leadership and strategy. In Marriott when a decision was made by C suite to buy products as wrapper over cloud providers I was surprised and based on my limited information and knowledge posted a question to Chief technology officer as why it won't be a good strategy to directly use Native offering from AWS. The reason enlightened me and gave new a new thought process that being such a large enterprise that has presence in 200+ countries across globe we may have challen"See full answer

Pm P. - "Alexa: Is the virtual assistant that runs on amazon smart speakers as well as on other devices. Clarification on goals/Objectives: What would the goal at that point of time be? Is it increase in revenue ? Either via new customers i.e. adoption or Increasing the wallet share of the customer? Increasing the sales ordered via Alexa ? Why do people want to use Alexa? To get answers, make their lives easier by automating activities within their home Integrates with amazon account so"See full answer

Anuradha T. - "What‘s the goal of increasing Spotify’s premium subscribers? - To monetize and get more premium subscribers Users: Target users could potentially fall in 3 categories 1) Users who are interested in paying a premium price for great curated playlists 2) Users who are interested in listening to music but not willing to pay a price Targeting #1 Pain points: 1) As a user I wouldn’t want to subscribe to something w/o being listening to the playlists 2) If I do subscribe I would like to receiv"See full answer