Interview Questions

Kartikeya N. - "Clarifying questions I am assuming the time frame for this question is irrelevant as this is a hypothetical question? : Yes Is IG prioritising the creator side or the viewer side more at the moment? : What do you think? I think it should be a balance for the long term sustenance of the network Are all these reels and views in a particular geography or globally? : Globally What is the duration for which these Views are measured? Assume a day Do we know anything about other engagemen"See full answer

David I. - "WITH filtered_posts AS ( SELECT p.user_id, p.issuccessfulpost FROM post p WHERE p.postdate >= '2023-11-01' AND p.postdate < '2023-12-01' ), post_summary AS ( SELECT pu.user_type, COUNT(*) AS post_attempt, SUM(CASE WHEN fp.issuccessfulpost = 1 THEN 1 ELSE 0 END) AS post_success FROM filtered_posts fp JOIN postuser pu ON fp.userid = pu.user_id GROUP BY pu.user_type ) SELECT user_type, post_success, post_attempt, CAST(postsuccess AS FLOAT) / postattempt AS postsuccessrate FROM po"See full answer

Singer29 - "Let me tell you about a time when my manager was on a two week PTO and I was building the post-MVP roadmap for a newly launched product. Being a SaaS platform for supporting restaurants, I'd led the conception, planning, development and launch of the MVP for an online ordering solution for diners in restaurants. After the launch of the MVP, our original plan was to build features which supported table-service restaurants like keeping an open tab. But while looking at the data, I realized that a"See full answer

Aarav G. - "Is there a reason a confidence interval was used to solve this problem over just using the mean/expected value directly?"See full answer

Anup S. - "Inventory Service and Registration service can they be in SYNC always ?? The "experience layer" needs accessed by Hotel owners also ??? How does real time inventory come from all Hotels ???"See full answer

Mark - "Clarifying questions: what's the original goal of this feature? what user problem / issues we identified that we are trying to address? Is there a particular user base or market/regions that we are trying to solve this issue for? Is the experience going to impact the rider's action? or does it also change the driver experience? Assume: the issue we are solving for is focus on the rider's experience - the goal of this feature is to increase the % of matched ride (ie rider/driver matche"See full answer

M N. - "Why do we want to build an ad platform? Should we discuss if we should/should not do this? Or have we decided? Let's say we decided. Now what's the goal of ad platform? Additional revenue stream. We need to make sure the ads we show don't distract our users from the core product but help our users with their financial needs through relevant advertisements. It might not be a bad idea to monetize the 13M users as long as we're connecting them with the right brands/services. Now let's look at the"See full answer

Anisha S. - "SELECT d.name as departmentname,e.id as employeeid,e.firstname,e.lastname,MAX(e.salary) as salary FROM employees e LEFT JOIN departments d ON e.department_id=d.id GROUP BY department_name ORDER BY department_name;"See full answer

Sagrika S. - "The biggest factor that excites me about technology is its ever changing and dynamic trend. In my life, I have seen the transition from landlines to simple mobile to smartphones, from Cathode tube desktop screen to super slim TFT and many more. I think technology has now (with time) become integral part of human life and getting in-sync with it is like a normal and very cool phenomena."See full answer

Tiago R. - "function knapsack(weights, values, cap) { const indicesByValue = Object.keys(weights).map(weight => parseInt(weight)); indicesByValue.sort((a, b) => values[b]-values[a]); const steps = new Map(); function knapsackStep(cap, sack) { if (steps.has(sack)) { return steps.get(sack); } let maxOutput = 0; for (let index of indicesByValue) { if (!sack.has(index) && weights[index] <= cap) { maxOutput ="See full answer

gdecuri - "Load Balancer, Multiple API Servers, game Service, pub-sub system, HTTP Long Polling for status updates, write-through cache. No SQL DB to store user, game, and move information."See full answer

Dinar M. - "Even more faster and vectorized version, using np.linalg.norm - to avoid loop and np.argpartition to select lowest k. We dont need to sort whole array - we need to be sure that first k elements are lower than the rest. import numpy as np def knn(Xtrain, ytrain, X_new, k): distances = np.linalg.norm(Xtrain - Xnew, axis=1) k_indices = np.argpartition(distances, k)[:k] # O(N) selection instead of O(N log N) sort return int(np.sum(ytrain[kindices]) > k / 2.0) `"See full answer

Akshay J. - "Started by asking clarification questions regarding design constraints and desired features. Break down the into re-usable components - HeroImg and Carousel (with 3 images rendered) Code the components and managed the state for both in the parent component."See full answer

Pree M. - "What is shopper demand? Let's say the ability to predict whether x number of shoppers are available during a certain time of day based on a some factors Variables: \# number of orders /per hour /per day /per week Shopping Time: time taken for a shopper to prep an order (how many orders can a shopper prep) $ average order value geographic factors since demand will vary by city number of stores or any other multiplying factor which help us predict order volume (which is dire"See full answer

Bhavna S. - "Step 1: Define Objectives and Key Metrics Objectives: Understand the demand for group video calling. Assess the potential impact on user engagement. Identify technical and user experience considerations. Key Metrics: Call Frequency: Number of 1:1 calls per user. Call Duration: Average duration of 1:1 calls. Call Participants: Identify users who frequently call multiple individuals. Concurrent Calls: Instances where users are engaged in multiple 1:1 call"See full answer

John F. - "Currently, I do a lot of data analysis using Azure Databricks and PowerBI. In Databricks, I write some basic SQL queries to retrieve the data and then pull that data into PowerBI for analysis. While this is sufficient, I believe there is room to make this skill set stronger. One way that I mitigate this currently is to maintain a strong relationship with our data analytics team. Whenever I have issues massaging or querying the data, I will reach out to one of those team members to help me get to"See full answer

Jeffrey F. - "I used the GAME method. Started first with defining the product and setting the mission and goal for Zoom. Stated that the product grew in popularity in 2020-2021 for both business and personal use, but since lockdown ended, shifted to business use. Goal is to effortlessly and seamlessly connect people anywhere. Focused on the business use case and stated Zoom makes revenue through contracts signed with various enterprises. Due to maturity of the product and business focused, said it make"See full answer

stash - "Clarification What does showing ads mean ? Is it showing outside of the car as a mobile billboard or showing inside of the car on screens? —> Inside of the car / digital ads What is our product strategy with Waymo. Do we want to get into the ride hailing business or license our tech —> To be defined by you Do we have any near or long term revenue goals for this —> Get wide usage of Waymo tech and be a key driver in accelerating the adoption of self-driving cars accessible in the world"See full answer