Interview Questions

Glados - "Clarifying questions 1/ Any other products in VC portfolio I need to be aware of - "no" 2/ Market focus? - "no" Started off by stating database marketing 1/ SQL 2/ NoSQL Data models mostly relational Database trends 1/ Vector databases 2/ Growth in cloud / fully managed databases 3/ Multi cloud is important to avoid vendor lock in Ultimately Price/performance is king Competition 1/ Large cloud providers - AWS/GCP/Azure 2/ Legacy databases - Oracle/SQL Server 3/ Niche players - Vitess, Coc"See full answer

Anonymous Shrimp - "I would start off by talking about the goals of this feature. What's the goal of Instagram with blue check marks? What does it aim to achieve? For the purpose of this question, I am assuming that Instagram wants to verify celebrities/famous people/brands as the original profile that differentiates them from fake profiles or other fan groups. It's also to develop trust and credibility amongst Instagram users. The mission of Facebook is to connect people across the globe. Instagram, which is a p"See full answer

Anonymous Mongoose - "Given a Binary Tree, the task is to find its vertical traversal starting from the leftmost level to the rightmost level. If multiple nodes pass through a vertical line, they should be printed as they appear in the level order traversal of the tree. The idea is to traverse the tree using dfs and maintain a hashmap to store nodes at each horizontal distance (HD) from the root. Starting with an HD of 0 at the root, the HD is decremented for left children and incremented for right children. As we"See full answer

Ben G. - "Situation - A time where I had to collaborate with a team member in another department was while I was at Google working on my hotel project and had to work with the legal department for our OOBE flow. Task - I was tasked to work cross functionally with the legal department to lead the design of the out of box experience for our product to ensure our guest users were sure of policies around data and privacy. Action - In order to establish cadence and effective relationship building, I set up a t"See full answer

Ashima S. - "What do we mean by grow the VC feature? I am assuming the goal to be feature adoption. Goal: Increase VC feature adoption and usage within a timeframe (say, 6 months?) User Segments: I am thinking of the following user segments for this problem - Security conscious users (mostly an overlap with high spending limit card users) Frequent shoppers with multiple online subscriptions (we could quantify this like >5 subscriptions or so) Potential CapitalOne users who have shown interest in the"See full answer

Mark - "Questions: Is "Facebook Search" referring to the overall search bar at the top where users can search across multiple facebook products (people, events, groups, marketplace, etc.) Interview (I): Assume it is for the overall search experience What's the current goal for Facebook as a company? How does Facebook search fit into the current company goal? I: Your call **What's the goal for this improvement for Facebook Search? Are we aiming to drive engagement overall?"See full answer

Raul K. - "No of Cars in 1 year = [ Total Road Length] / [Distance Covered by 1 Self Drive Car in One Year] Clarifying Question - How does Mapping work? I assume the car has a bunch of cameras and the car needs to go via a road each once to do the mapping for Google Street view. Is that correct? Assumption Google Street view required cars to go via road once and then use camera for mapping Assumption for average speed of the car - This can vary if the car is on the highway Assumption of Area of"See full answer

Saurabh K. - "Missing Item - User ordered multiple items, few items are missing Wrong Item - Entire order is wrong / there are items in the order that were never ordered How is this measured ? CSAT Missing Items Wrong Items Step 1 : Collect data on orders that reported missing / wrong items. Dive deep to understand if the problem is isolated to a specific metro/zip code/restaurant type (say fast food vs fine dine), time of day (lunch vs dinner), tenure of the courier on th"See full answer

Hayatu H. - "What do all data scientists need to know about how to work with very large datasets? 37 Follow Request Answer More All related (39) Recommended 📷 Corrin Lakeland · Follow , M.S. Data Science, University of St. Thomas, St. Paul (2018)6yData Science consultant and managerUpvoted by[Tom Halloin](https://www.quora"See full answer

Gloriose H. - "Required output in the solution not the one requested from the question. only customerid, firstname, last_name and years were required. Please this needs to be very clear. Otherwise my answer is with totalorderyear as ( SELECT o.customer_id, c.first_name, c.last_name, EXTRACT(YEAR FROM o.orderdate) AS orderyear, COUNT(o.orderid) AS totalorders FROM orders o LEFT JOIN customers c ON c.customerid = o.customerid GROUP BY o.customerid, c.firstname, c.last"See full answer

Shubham K. - "For larger audience of the platform, Flipkart is an e-commerce website like Amazon in India. Gather more information 15% decline in comparison to last week, last month, last quarter or last year or across a particular sale duration that runs at a fixed frequency like Big Billion Days (similar to Great Indian Festival which Amazon puts up) Across a particular item, category, brand or overall. From which flow like Wishlist to cart, Product detail page to cart, Product comparison to c"See full answer

Ananya M. - "I am assuming current situation where public transport have restarted but uber pool is yet to start. Assuming it's Bay Area = I am considering internet penetration to be 100% . pop = 8 million (2M per age group) age group that would use uber (20-80 , under 18s can't ride) x age group that can afford uber ( low:mid:high income = 20:50:30 meaning 80% of each qualifying age group can afford uber) x people per household in need of transportation (3 people per household, 2 cars on average per househ"See full answer

Ammro H. - "I am not sure if I agree with the approach taken in the mock video. Should FB build a tablet? is not the same as "Design FB tablet." This is an analytical decision question, not a design question. I would have done strategic analysis using Porter's five forces or maybe SWOT and value chain analysis to decide rather than designing a product. My answer will be to examine critical factors to decide to build tablet vs. to build apps for existing non-FB tablets (ipads and android tablets) Users"See full answer

Takashi M. - "My approach is try to narrow down by 4W1H. When - When this happened? Still continuously happen the problem? Where - Is this happen specific region or entire customers? What - What kind of problem? One time big error or any data show the curve? Who - Is it all platform or specific platform (Web, iOS, Android) How - How serious problem? How many customer affected? Next step is to narrow down the causes is from internal factors or external factors. For internal factors: Any recent up"See full answer

Sumit P. - "CQs: Swiggy? → instamart or food delivery → consider both Why do we want to increase AOV right now? Is it not at the desired level or exploration? → let’s say exploration Swiggy is a public company → goal is profit Biggest bite in profit is delivery cost hence delivery cost/unit revenue should be minimised Delivery cost = (fixed base cost + distance * x) * probability of spoil cases Can be done by Lowering delivery cost → seems challenging "See full answer