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

IamaPM - "First I would clarify what ad manager is? Ad platform provided by meta which can be used by users across any meta product - marketplace, instagram, facebook? Questions Is this decline in any specific region? Is this decline specific to an app/ product like Instagram/ marketplace Has the MAU of Ad Manager (users clicking on ad manager without publishing) declined or increased? An increase here might mean that the total ads published has not decreased as such , but the ratio has changed"See full answer

Priyanka D. - "Target Consumers: corporate clients - for business meetings students (in school, college) aspirants who want to take competitive exams/tests Identify underserved customer needs: re-application leads to post-it's not being sticky enough space crunch so user needs to be precise post-its need to stick from all 4 corners for it to be readable and so it folds less writing with pen, marker gets imprinted on next page Define Value Proposition: a small piece of paper with concise list of"See full answer

Reno S. - "func isMatch(text: String, pattern: String) -> Bool { // Convert strings to arrays for easier indexing let s = Array(text.characters) let p = Array(pattern.characters) guard !s.isEmpty && !p.isEmpty else { return true } // Create DP table: dpi represents if s[0...i-1] matches p[0...j-1] var dp = Array(repeating: Array(repeating: false, count: p.count + 1), count: s.count + 1) // Empty pattern matches empty string dp[0]["See full answer

Rahul J. - "Clarifying questions Target geography: USA, all urban areas Form factor: Mobile app, supported on iOS and Android Items to be borrowed: simple appliances like toaster, FMCG products, etc. Target market USA has a population of millions of people People generally need to frequently borrow household items from neighbours in case of emergency (or even otherwise) Internal company assessment Meta's mission is to create communities that help each other. This problem ties in well with t"See full answer

Rohit K. - "Clarifying scope : This is a feature on top of existing swiggy app to deliver prepared food for health-conscious people Clarify the term health conscious : Calory counters Macro trackers : Need balance of carb, protein, fat etc. Fresh Eaters :Need fresh ingredients Allergic due to some ingredient Ill people There can be various user personas along with respective pain points are: 1) Gym goers : No way to count the calories or track macro intakes in a swiggy order 2) Fresh eaters : Lack"See full answer

Sri H. - "First of all, are some of these hypothetical questions? Anyway, I'd start by asking what's a "Video feature" ;-)"See full answer

Emiliano I. - "Look for the main variables and see if there differences in the distributions of the buckets. Run a linear regression where the dependent variable is a binary variable for each bucket excluding one and the dependent variable is the main kpi you want to measure, if one of those coefficients is significant, you made a mistake. "See full answer

Dave F. - "After researching Glassdoor, I provided an in-depth answer that incorporated my interest in DB technologies, alignment with career objectives, and ability to make an impact from professional experience. "See full answer

Yuexiang Y. - "A Random Forest works by building an ensemble of decision trees, each trained on a slightly different version of the data. The key mechanism is bagging: for each tree, we sample the training data with replacement (bootstrapping), so every tree sees a different subset of examples. On top of that, at each split the algorithm randomly selects a subset of features, so trees explore different predictors. These two sources of randomness decorrelate the trees. When we aggregate them — by averag"See full answer

Scott S. - "my team is distributed across different regions, different time zones. Managing distributed teams presents unique challenges and opportunities,. I have developed a structured approach to ensure effective collaboration, communication, and productivity. I follow various strategies, as follows: I schedule regular meetings, including daily stand-ups, weekly syncs, and monthly retrospectives. This ensures that everyone stays aligned and up-to-date on team progress and priorities. I leverage commu"See full answer

Anonymous Eagle - "I generate insights through stakeholder requirements and the data I have in hand"See full answer

Chelsey V. - "Suppliers have an interest in the purchase of inputs by the company. They want companies to pay on time"See full answer