Interview Questions

Glados - "Strategy of 15 minute delivery apps. I will discuss what delivery apps are, what is their current business model, examples of some delivery apps, any market metrics/share, opportunity, how 15-minute delivery apps fit in, challenges/opps, what's next, takeaways. Clarifying questions Are we focused on North America? Any other geo? Delivery apps -> Assumed to be food/grocery/alcohol delivery not packages (Amazon)? Assumed delivery apps for end-consumers not large businesses? Delivery apps o"See full answer

Zain R. - "I've worked on projects not quite like this, but very similar, in the past - I'll borrow from that to answer this: The Broader Context this problem doesn't specify the type of data we're working with, or how it's being ingested to align with my personal background, I'll assume a picture that lends this problem well to being a computer vision (abbreviated "CV") related question: let's say we have a conveyor belt in a waste facility, which sequentially carries a stream of waste w"See full answer

Rishabh L. - "Pizza Ordering System orderdetail - orderdetailid (PK), orderid (FK), itemid (FK), itemqty, itemized_price order - orderid (PK), customerid (FK), orderdate, locationid (FK), ordertype (DINEIN, PICKUP, DELIVERY), refid (dineinid, pickupid, deliveryid), subtotal, tax, tip, totalamount, payment_method (CASH, CARD) location - locationid (PK), locationdesc, city, state, startdate, enddate customer - customer_id (PK), name, address (nullable), phone (nullable), dob (d"See full answer

Julien C. - "👇 Your feedback is very much appreciated 👇 Clarifying Questions Should we look at it worldwide or in the USA only? Should we consider all Slack messages? ones that are sent in business-owned workspaces? ones that are sent in other types of communities? We'll give numbers for this scope: worldwide all messages Approach: Nb of users x Nb messages sent by user per hour x Nb hours worked per day Nb of users: 10M Nb of messages per hour: 10 Nb of hours worked per day: 8 So an"See full answer

R D. - "Plaid is a pattern and I love looking and recognizing patterns."See full answer

Exponent - "This is a Measure Success question with a slight twist. The twist here is we need to consider a hypothetical product rather that one already built. This changes our formula slightly - specifically we may not be able to apply a UX flow to drive analysis since we're unsure of the implementation. Instead, we'll look at core behaviors that are indicative of success. Here's the modified formula: Ask clarifying questions State the goal of the feature **Apply a UX flow to drive a"See full answer

Alex M. - "A red-black tree is a self-balancing binary search tree. The motivation for this is that the benefits of O(logN) search, insertion, and deletion that a binary tree provides us will disappear if we let the tree get too "imbalanced" (e.g. there are too many nodes on one side of the tree or some branches have a depth that is way out of proportion to the average branch depth). This imbalance will occur if we don't adjust the tree after inserting or deleting nodes, hence our need for self-balancing c"See full answer

Josh L. - "I would define success by first figuring out what our goal is by building the reels feature. Are we trying to increase DAUs? Increase enagement? Etc... For the sake of this, I think to define success it makes most sense to see if there is an increase in the amount of time users are spending on instagram. If time spent per user increases, it is likely that ad spend can increase and in turn increases instagram's reveue. We need to be sure that there are guard rails in place and make sure that by"See full answer

Darnel C. - "I consider the complexity of the task and align with the strengths and development goals of my team members. This not only fosters their growth but also builds a stronger, more self-sufficient team. Delegating allows me to focus on higher-level strategic initiatives and critical decisions that require my direct oversight. I want to ensure that I’m not spread too thin and can provide value where it’s most needed. I decide to own a task when cross functional stakeholders are involved and my expe"See full answer

Jaime A. - "I would avoid converting order_date WITH monthly_totals AS ( SELECT department_id, SUM(CASE WHEN DATETRUNC('month', orderdate) = '2022-11-01' THEN orderamount ELSE 0 END) AS novtotal, SUM(CASE WHEN DATETRUNC('month', orderdate) = '2022-12-01' THEN orderamount ELSE 0 END) AS dectotal FROM orders WHERE order_date BETWEEN '2022-11-01' AND '2022-12-31' GROUP BY department_id ), mom_increases AS ( SELECT "See full answer

Nikunj V. - "OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) are two types of data processing systems, each designed for specific purposes in the context of database and data warehouse environments. OLTP (Online Transaction Processing):Purpose: OLTP systems are designed to manage and handle high volumes of transactions, such as inserting, updating, and deleting data. These systems are typically used in day-to-day business operations. Characteristics: Handles small, si"See full answer

Ankur P. - "I will Use Bit manipulation for solving this question suppose if n is a power of 2 so it should satisfy (n&0)==0 else (n&0)==1"See full answer

Amparo L. - "My favorite app on my phone is Youtube because that way I could watch iCarly videos for free."See full answer

Manas M. - "Since Experimentation is a Broad Term I would like to ask a couple of Clarifying questions What kind of Experimentation User Behavior with newly introduced Beta features AI/Image learning Based Experimentation to test out trial features Something else API based experimentation for user/Third-party experiments,with APIs for new features exposed(this has a lot of potential where devs of apps etc can integrate new experimentation features in their apps with minima"See full answer

Akshay R. - "Let's start by describing a time machine, which is a device that allows somebody to move backwards or forwards in time. The movement could be physical movement, wherein the user gets physically transported to a different timeline, or it could be getting a glimpse into a different timeline, like wearing a VR headset and getting to experience a different timeline without physically being there. For the purpose of this exercise, I will assume, this time machine allows a person to physically trans"See full answer