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

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

Anonymous Hyena - "A load balancer accepts requests from clients (e.g. web browsers on the Internet) and backend services (e.g. a web server). Load balancers are useful for replicating backend services onto multiple machines to meet increased demand. The design of a load balancer should address the following questions: What protocols should be supported? IP allows computers to communicate using packets, similarly to how people send letters. IP packets are addressed using an IP address and port number. "See full answer

Megha V. - "Assumptions, company, industry, external, customers, problems, solutions, metrics Company is microsoft, its vision is to help people and organization to achieve their full potential by increasing productivity . Task management - there are many products like notes, google task etc which exist but no one is market leader. A user had a list of tasks which she wants to complete by Y deadline and their is prirotization among these and could be categorized Task - start day, end day, estimated time to"See full answer

S R. - "Did pretty ok. Gathered requirements, back of the envelope calculations and drew out the typical system design with details of components. Dug in deep into each box and probed around why it was needed."See full answer

Dhruv M. - "During my internship at Inspira Analytics, our intern team had worked for two weeks on a client presentation for a new data dashboard. Unfortunately, during the final review, the manager pointed out several major flaws in our analysis and asked us to redo the entire structure. The feedback was blunt, and the team felt discouraged, questioning whether our efforts were even valued. As the informal team lead, I felt responsible for helping lift the team’s morale and refocus everyone so we could del"See full answer

Mark S. - "Range captures the difference between the highest and lowest value in a data set, while standard deviation measures the variation of elements from the mean. Range is extremely sensitive to outliers, it tells us almost nothing about the distribution of the data, and does not extrapolate to new data (a new value outside the range would invalidate the calculation). Standard deviation, on the other hand, offers us an insight into how closely data is distributed towards the mean, and gives us some pr"See full answer

Meenakshi D. - "BETWEEN and HAVING clauses in SQL serve different purposes: 1. BETWEEN Clause Used to filter rows based on a range of values. Works with numeric, date, or text values. Can be used with WHERE or HAVING clauses. The range includes both lower and upper bounds. Example: Filtering employees with salaries between 30,000 and 50,000 `SELECT * FROM Employees WHERE salary BETWEEN 30000 AND 50000;` 2. HAVING Clause Used to filter **groups"See full answer

Yulia D. - "First, I would like to ask some clarifying questions. Are we talking about the business metrics dashboard or health metrics(like response time)? - it is up to you Do I understand right that Netflix is a subscription-based video streaming service for watchers? So I know that they create original content for Netflix, but it is out of the scope of this question. - right My approach will be to: Define the business goal from Netflix’s mission Break down the actions taken by users at each stage of the"See full answer

Josephine F. - "How do you ensure that your process maps accurately reflect current workflows in a university?"See full answer

Ankit J. - "The goal is to determine which shows get promoted to the home screen i.e the screen the user sees after launching Netflix. There are two ways to promote shows today; Editorially - the editorial team selects the categories and shows to be shown to the users Algorithmically - based on the historical views and contextual information such as location, time of the year, age, etc the recommendation algorithm determines a list of shows to show on the screen. The higher level goal for Netflix is o"See full answer

Steve M. - "def split_count(s): return 2**(len(s)-1) `"See full answer

Miguel C. - "Missing launch. Only design is covered."See full answer

Rajeev K. - "Here's how I'd approach investing that $10 million over the next year and a half. The biggest chunk about $4 million would go straight into our core infrastructure because that's what everything else depends on. We're seeing massive demand for real-time payments, so I'd put $2.5 million into building instant settlement capabilities and integrating with FedNow and RTP rails. The remaining $1.5 million would beef up our platform scalability because we're hitting capacity limits during peak times,"See full answer

Surbhi G. - "Deep Learning is a part of Artificial Intelligence, it's like teaching the machine to think and make decisions on its own. It's like how we teach a child the concept of an apple - it's round, red, has a stem on top. We show them multiple pictures of apples and then they understand and can recognize an apple in future. Similarly, we feed lots of data to the machine, and slowly, it starts learning from that data, and can then make relevant predictions or decisions based on what it has learnt. A co"See full answer

jantheman88 - "Company Mission: To Organize the World's Information Clarify: What type of product are we looking to build? Software, Hardware? -> Hardware Makes sense since Google has a strong software stack including Android TV, which is a huge business by Firestick & Nvidia Shield, as well as Chinese based hardware implementations. Is there any restrictions for this type of approach, or are we free to go around any way we'd like? -> You're free to take any approach you'd like. Google has a strong c"See full answer

Anonymous Condor - "Yes, I need to compare the first half of the first string with the reverse order of the second half of the second string. Repeat this process to the first half of the second string and the second half of the first string."See full answer

M N. - "Acqui: #unique impressions Activ: #clicks per first time user on products and carousel Engage: #clickthroughs, CTR of products by sort order(accuracy) ,carousel clicks, hovers, #clickthroughs that resulted in a purchase(relevance) retent: purchase frequency of reco clickers reve: revenue from recommended products broken by rank "See full answer

Zakery K. - "I told a story about having good intentions to help out a superior with a problem but I did so without seeking buy-in (permission) first. While I did solve the problem and provided value to him and my other colleagues, I was reprimanded for crossing boundaries and not respecting his privacy (I accessed his computer without his permission to deliver a resolution to a problem). While I had good intentions and the outcome was good, my approach left me with a negative mark and a life long lesson r"See full answer