Interview Questions

Maliki U. - "Here is my implementation: select marketing_channel, AVG(purchasevalue) as avgpurchase_value from attribution group by marketing_channel order by avgpurchasevalue DESC ; There is no need to copy and past the line of code for calculating the average into order by, just Alias is enough because going by the order of execution in sql, Always, order by is executed after executing select clause."See full answer

Saloni S. - "Firstly I would research about it and identify its objectives and epics with user stories. Then accordingly I would suggest the ideas that can be done with TRAVEL."See full answer

Frederick K. - "\# An program that prints out the peak elements in a list of integers. Pseudocode: 1. Define a function that takes a list of integers as input. 2. Initialize an empty list to store the peak elements. 3. Loop through the list of integers. 4. For each element, check if it is greater than its neighbors. 5. If it is, add it to the list of peak elements. 6. Return the list of peak elements. def findpeakelements(nums): if not nums: return [] peaks = [] n = len(nums"See full answer

Shivam S. - "Binary search is the technique to search an element in a sorted array in O(log(N)) time. It is also used in problems wherever we find monotonically increasing or decreasing patterns."See full answer

Gaurav B. - "class TreeNode(var val: Int, var left: TreeNode? = null, var right: TreeNode? = null) fun isAverageOfDescendants(root: TreeNode?): Boolean { fun helper(node: TreeNode?): Triple { if (node == null) return Triple(0, 0, true) val (leftSum, leftCount, leftValid) = helper(node.left) val (rightSum, rightCount, rightValid) = helper(node.right) val totalSum = leftSum + rightSum val totalCount = leftCount + rightCount // If leaf n"See full answer

Shivam B. - "The Critical Rendering Path (CRP) refers to the sequence of steps that a web browser takes to convert HTML, CSS, and JavaScript into a fully rendered webpage. CRP highlights the processes that can slow down the time it takes for a webpage to become interactive for users."See full answer

Anonymous Armadillo - "I couldn't follow the solution offered here, but my solution seemed to pass 6/6 tests. Any feedback is welcome, thank you! def encrypt(word): en_word = "" for i in range(len(word)): if i == 0: en_word += chr(ord(word[0])+1) else: num = ord(word[i]) + ord(en_word[i-1]) while num > 122: num -= 26 en_word += chr(num) return en_word def decrypt(word): de_word = "" for i in range(len(word)): if i == 0: de_word += chr(ord(word[i]"See full answer

Anonymous Koala - "Google GOAL is to organize work info and private information to users. Providing info on operating  hours can upset customers making him not to visit google to check hours but rather use other APPs as yelp. Will hurt Google advertising revenue. Also restaurant business if  the user find info is not credible Stakeholders Goggle End  users Owners Current Sources Restaurants website Customers feedback Owners adding it on google business Chances of disambiguation holida"See full answer

Exponent - "This is a Measure Success question with a slight twist. The twist here is we need to consider a hypothetical changes 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

R K. - "Some clarifying questions: Is this going to be a part of exciting Meta product or completely new one? you choose Is there a particular sport or range of sports that the product should cater to? all sports, should be agnostic. What is "athletes"? pros? amateurs? fitness enthusiasts? you can decide Is there a specific problems or challenges faced by athletes does he want the product to address? feel free to make assumptions Is there a specific goal that we want to achieve"See full answer

Afework B. - "5II"See full answer

Brody C. - "Honestly, I was a bit all over the place with this one. My structure was: Meta Mission Audiences Thinking about journeys and pain points (TAM + Unmet Needs) Brainstorm solutions Prioritize solutions MVP - Measure of success Risks and tradeoffs The interviewer kept trying to derail the conversation. I chose Group Volunteers (a group of people who want to volunteer together) as the audience, and in hindsight it was a poor choice. Because I chose that over individuals, I couldn't narrow down"See full answer

Anonymous Hare - "function getDifferentNumber(arr) { // your code goes here const n = arr.length; //Define Max Integer const MAX_INT = Math.pow(2, 31) - 1; //Coppy arr to arr1 then sort arr1. const arr1 = arr; arr1.sort(function(a,b) {return a -b}); // Put arr1 in Set to optimize lo const uniqueSet = new Set(arr1); console.log(uniqueSet); // Check for the smallest nonnegative integer not in the array for (let i = 0; i < n; i++) { if (!uniqueSet.has(i)) { return i; } } if(n<MAX_INT) return n+1; else return -1; }"See full answer