Interview Questions

Vinayak A. - "Let's start with understanding the objective. The assumed objective is to be able to optimize for ads revenue by showing optimal number of ads to users without reducing the user engagement metrics. So, the approach I would take here is to perform experimentation with certain set of customers cohort based on different parameters. The metrics I would keep track of Customers average user engagement - time per session before and after the experiment over a week. Number of ads shown per ses"See full answer

Negar H. - "SW: Headway (Audio book app) Goal: Track user engagement with the product. (Analytics) To Track user engagement with the product I would first define the user actions defined as user engagement, and then define quantitative metrics to track user behaviour. User actions -> engagement: Actions: User Plays an Audio book (following by user's retention) User uses Next chapter button to continue listening User marks Audio books as favourites User shares Audio books Metrics: DAU & 2."See full answer

Gowtami K. - "select DISTINCT p.product_id, p.product_name , CASE when sale_date is null then 'Not Sold' else 'Sold' END as sale_status from products p left join sales s on p.productid= s.productid `"See full answer

Ahmed A. - "Good Question, but I would've marked this as medium not hard difficulty, since it's just a straightforward traversal."See full answer

Rose G. - "I'm working on a Health Data Warehouse product, that would allow smoother medical research is a highly regulated environment, in France. 0 - In the Healthtech world, Government Regulations have to be taken into account. In my product's case, they work in our favor as procedures for medical research were extremely complex and limited, and the government recently allowed a new regulatory environment: the HDW. There is always a risk though that the government itself places itself as a competitor"See full answer

Claire W. - "Add more social features"See full answer

Mark S. - "E(VAR(X))= VAR(X) VAR(X)= E[(X-E(X))^2] = E[X^2]-E[X]^2"See full answer

gdecuri - "Load Balancer to multiple API Servers, pub sub system to publish user events, Game Engine Service, Write through cache and NoSQL DB. HTTP Long Polling to get user status updates"See full answer

Harshi B. - "SELECT DISTINCT title, ROUND(AVG(rating) over (partition by title),1) avg_rating, ROUND(AVG(rating) over (partition by genre),1) genre_rating FROM rating r JOIN movie m ON r.movieid=m.movieid ORDER by 1"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

Amit S. - "Fast food service Good service application."See full answer

Suhas P. - "Implementing the anomaly Machine learning using some algorithm like Isolation Forest algorithm DBscan algorithm and local data point find algorithm."See full answer

Sim S. - "Started with user-groups to identify the differences world wide: speed of internet, how high end devices are The interviewer just wanted to dive into the questions of latency & the technical fast. I then said let's separate out server vs client. On server side, cannot have australian users hitting california servers for data. So must be some sort of global availability of caching. And ensure rapid read out of that cache so something like a redis solution would help. Then switch gears to cli"See full answer

Exponent - "It's always good to start with identifying what type of problem you're tackling. The problem we need to tackle is essentially a variation on a Favorite Product Question. We know there's a formula for this type of question, so now our job is to tactically execute on the formula. Let's begin with the Favorite Product Question formula: Choose a product and briefly explain what it is Who are the users? What are their pain points? **How did competitors solve it in the"See full answer

Daniel M. - "Clarifying questions / Assumptions: Scope: US market Constraints: none Limiting to UberX, Uberpool, UberXL services On-the-ground operations: event operations, things going on as people arrive or leave the event Defining 'events': scoping it down to concerts or large-scale events (that typically have a lot of traffic) Defining 'better experience': easier to get to and leave events Goal: I will optimize for greater user satisfaction with our service, which should translate in"See full answer