Interview Questions

- Z. - "with base as ( select viewerid, year, month, watchhours, lag(watchhours, 2) over (partition by viewerid order by year, month) as p3, lag(watchhours, 1) over (partition by viewerid order by year, month) as p2 from watch_time ) select viewer_id from base where p3 < p2 and p2 < watch_hours group by 1 `"See full answer

Eshaa D. - "Clarifying Question: When you say user growth do you have in mind new user acquisition or also talk about user retention/engagement? Assuming New User acquisition is the main referral goal I will pick this for my answer. Netflix is a subscription-based video-on-demand service, available globally on mobile, web or Living room TV, offering a high-quality viewing experience to satisfy consumers' digital entertainment desires. User groups: I think of Netflix's large user base across three lenses: "See full answer

Arya R. - "I'm going to assume the problem is limited until the point of where the rider get into the car. Rider segments/characteristics: Local rider (lives and travels in the same city) Tourist rider (visiting a city, using Lyft for the first time in the city) Lets think about some problems for these types of users: Local rider: (Choose to prioritize on these use-cases assuming its a larger % of rides overall) Ride shows as confirmed, but driver does not move on the map Driver does"See full answer

Shruti S. - "I do not think Facebook should remove the mandatory picture. As long as users get to choose who can see their pictures its a win win. eg: if i am sending out a request to anyone ( the picture is visible) - but when i am getting a request i can choose to be visible vs. invisible.. The pictures definitely should now be watermarked in a manner that AI cannot replicate it. giving a sense of security to users. Many might want to use this version for friends who are not on their friend list. For m"See full answer

Alvaro R. - "bool isValidBST(TreeNode* root, long min = LONGMIN, long max = LONGMAX){ if (root == NULL) return true; if (root->val val >= max) return false; return isValidBST(root->left, min, root->val) && isValidBST(root->right, root->val, max); } `"See full answer

Anjali M. - "Why? Uber is on demand platform, that leverages shared economy to power movement from Point A to B. Ubers business today is around 3 primary segments - Mobility, Deliveries, Freight. Mobility is the core product that enables riders to move from point A to Point B Using variety vehicles. Segment Users based on Usage / Frequency Daily - Prefers frequent but short trips, values convenience Occasional - Business professionals, even"See full answer

Michael B. - "Problem: Given a modified binary tree, where each node also has a pointer to it's parent, find the first common ancestor of two nodes. Answer: As it happens, the structure that we're looking at is actually a linked list (one pointer up), so the problem is identical to trying to find if two linked lists share a common node. How this works is by stacking the two chains of nodes together so they're the same length. chain1 = node1 chain2= node2 while True: chain1 = chain1.next chain2=chain"See full answer

Reno S. - "import Foundation func spiralCopy(inputMatrix: [[Int]]) -> [Int] { let arr = inputMatrix var top = 0, down = arr.count - 1 var left = 0, right = arr[0].count - 1 if top == down && left == right { return arr[top] } var ans: [Int] = [] while top <= down && left <= right { for i in left..<right { ans.append(arrtop) } for i in top..<down { ans.append(arri) } fo"See full answer

Ramachandra N. - "def mergeTwoListsRecursive(l1, l2): if not l1 or not l2: return l1 or l2 if l1.val < l2.val: l1.next = mergeTwoListsRecursive(l1.next, l2) return l1 else: l2.next = mergeTwoListsRecursive(l1, l2.next) return l2 "See full answer

Sneha S. - "Clarifying questions and assumptions: Personalised news feed is the culmination of curated posts, events, ads , videos, etc that is unique to each user. potentially this means that no 2 feeds are the same. I am assuming we are talking about the Facebook Blue app, since the term Newsfeed is generally associated with this app although the feed on Insta too is personalised. Thank you for this question. here is how i would structure my thoughts on arriving at success metrics for Personalised Ne"See full answer

Dhirendra S. - "I will start by asking some of the clarifying questions here - Does the interviewer want me to focus on any specific region or it's a global product - What's the timeline we are looking over here - Any specific problem statement that I should be focusing on - Any specific objective that they want me to drive Some of these questions will help to get my head straight and align myself with the interviewer. (2 mins to jot down my thoughts ) Answer - Problem statement : Will focus on the cha"See full answer