Interview Questions

E L. - "WITH CTE AS ( SELECT *, ROWNUMBER()OVER(PARTITION BY utxoid ORDER BY transactionid) AS trxrk FROM transactions JOIN transaction_inputs USING (transaction_id) JOIN utxo USING (utxo_id) ) SELECT transaction_id AS InvalidTransactionId FROM CTE WHERE sender!=address OR trx_rk > 1 `"See full answer

Gabriele G. - "Using a DFS approach, computing all the distances from typing import List from collections import deque def shortestCellPath(grid: List[List[int]], sr: int, sc: int, tr: int, tc: int) -> int: if sr == tr and sc == tc: return 0 nRows = len(grid) nCols = len(grid[0]) distances = [] stack = deque([(sr, sc, 0)]) visitedSet = set() while stack: nodeR, nodeC, nodeDist = stack.pop() if gridnodeR == 0 or (nodeR, nodeC) in visited"See full answer

Celia F. - "Managing multiple demands within timelines requires effective prioritization, organization, and time management skills. My task is to assess priorities, set realistic timelines, and allocate resources efficiently to meet deadlines. For instance, I've implemented project management tools and workflows to track tasks, monitor progress, and ensure timely delivery of deliverables. By effectively managing multiple demands, I've been able to meet deadlines consistently and deliver high-quality work fo"See full answer

Aiden L. - "clarification define a handyman: someone who's paid to do minor renovations or domestic repairs. define the app: standalone or within facebook or meta's app family? why are we designing this? should I come up with a goal (engagement, monetization)? constraints (financials/timeline)? goal: adoption. since it's a new app, i want ppl to adopt first and then monetize the users. I'd define a handyman as someone who's paid by app users to do minor fixes, such as unc"See full answer

Indranil G. - "It is NYC so mainly a business area. Also, there will be travelers to visit. Now we estimate that 5% of them are business travelers and 3 % of them are tourist So 8000000*5% = 400000 is Business And 7600000*3% = 228000 is tourist Now we also need to consider there are a family tourist who will use the same room that let us estimate 40% of the tourists are family means 40% * 7988000M = 91200 family and 1368000 is solo travelers 45600 are family room required considering there are 2 fa"See full answer

Surbhi G. - "In order to train a machine learning model for license plate detection, which is essentially image recognition, I would first need a large labeled dataset of images featuring license plates. From hereon, I would use a model architecture suitable for image-related tasks, like CNNs (Convolutional Neural Networks). When it comes to deploying the model, I would first optimize it, aiming for the best balance between speed and accuracy. Depending on the specifications, the model could be deployed eith"See full answer

Sasi K. - "Backend"See full answer

William M. - "Relu = 0 if > some threshold else x sigmoid normalizes to 0-1 asymptotically"See full answer

Exponent - "Before we begin, it's important to understand what the interviewer is testing with this type of question. This is a Strategy Question that tests an interviewee's ability to create compelling arguments from high level information, discern motive, and think strategically. We can split this question into two views: is Spotify's high churn rate okay or not? Let's see the argument that is bad, and then the opposing side. High churn is bad We'll first give the naive argument here — that churn i"See full answer

Farhan -. - "Sorting is a technique to arrange data in either increasing order or decreasing order, and, the function that implements this functionality is called sort function"See full answer

Anonymous Dove - "People interested in travel on Pinterest are looking for inspiration, information, and interaction. They want to discover new places, learn useful tips, and connect with other travelers. To improve their experience, I would suggest the following ideas: Create curated collections of travel pins: Pinterest users love to browse and save pins that match their interests and preferences. By creating curated collections of travel pins, you can showcase the best content from different sources and"See full answer

Julien C. - "👇 Your feedback is very much appreciated 👇 Clarifying Questions Bookshelf: how is this bookshelf going to be used? at home? in a library? Elderly People: do we have more precisions on this elderly population? are they sick?disabled? [Interviewer: this bookshelf will be for home purposes. You'll have to specify.] Here's what we gonna do: Users & Pain Points: let's try to better understand who we are designing this bookshelf for Solutions: we'll brainstorm a few solutions and"See full answer