Interview Questions

Sreeram reddy B. - "select employeename, employeeid, salary, department, DR from ( select employeename, employeeid, salary, dense_rank() over (partition by department order by salary desc) DR, department from employee ) where DR <=3 order by department, DR"See full answer

Rick E. - " O(n) - characters in the string O(n) - stack def identify_adjacent(s: str, k: int) -> str: stack = [] n = len(s) for ch in s: if stack: topch, topcnt = stack[-1] if top_ch == ch: top_cnt += 1 stack[-1] = (ch, top_cnt) else: top_cnt = 1 stack.append((ch,1)) if top_cnt == k: stack.pop() else: stack.append"See full answer

XYZ - "We have observed that DAU have been declining, while MAU has remained constant. Activity is define as: Logging in. Viewing content. Posting content. Interacting with other users (likes, comments, etc.). Daily Active Users (DAU): This measures the number of unique users who engage with Instagram on a daily basis. It indicates how frequently users interact with the platform and reflects its daily stickiness. Monthly Active Users (MAU): This measures the number of unique users who en"See full answer

Rahul J. - "find total sum. assign that to rightsum traverse from left to right: keep updating left sum and right sum, when they match return the index. else if you reach end return -1 or not found"See full answer

Manas M. - "Couple of Clarification Questions to be asked are: Aim of the physical product Retention/Encourage Loyalty Attract new customers Collect customer Data outside of the Airbnb ecosystem for better advertising and customer focus User Base of Airbnb Solotravellers - traveling to new places for exploring/solo travel Business Travelers - Lot of business Travelers who own small/medium businesses and book their own travel can choose airbnb Family gr"See full answer

Jacob S. - "Cloud computing is like going out to a restaurant instead of cooking dinner at home. When you cook at home, you have to do everything yourself. You need to use your own plates, pots, and pans. You have to know how many people are coming over and buy the right amount of ingredients. If more people join for dinner than you expected, you'll run out of food! But if fewer people show up, then you'll have leftovers that go to waste. And on top of it all, you have to do all the cooking, set up, and cl"See full answer

Srikant V. - "Used Recursive approach to traverse the binary search tree and sum the values of the nodes that fall within the specified range [low, high]"See full answer

BriskD - "I watched a couple of videos like this, one of them by Exponent staff (I think). It was disappointing that the architecture diagram and the walkthrough was a general layered architecture that you can apply to any backend system. I was wondering if there are videos that can be considered a reference material to watch, learn and improve on the tech (sys design) skills, and not so much about the soft skills."See full answer

devopsjesus - "This was a 60 minute assessment. The clock is ticking and you're being observed by a senior+ level engineer. Be ready to perform for an audience. The implementation for the system gets broken up into three parts: Implement creating accounts and depositing money into an account by ID Implement transferring money with validation to ensure the accounts for the transfer both exist and that the account money is being removed from has enough money in it to perform the transfer Implement find"See full answer

Michael A. - "First, I want to get a better sense of what is a DAU. What is considered “Active”? User sending message, reading message, opening app? All of the them, any activity within the Messenger App Second, it’s important to know the context of the change. What timeframe was this over? Let’s assume this was over the past 30 days. Ok, a follow up to this would be to check if this is a seasonal pattern? For example, there could be a correlation to Messenger usage and school starting. **This"See full answer

Anni P. - "I firstly discuss the brute force approach in O(n^2) time complexity , than i moved to O(nlogn) tine complexity than i discussed the O(n) time complexity and O(n) space complexity . But interviewer want more optimised solution , in O(n) time complexity without using extra space , The solution wants O(1) space complexity i have to do changes in same array without using any space . This method is something like i have to place positive values to its original position by swapping and rest negativ"See full answer

Aditya S. - "From Product Management perspective: I would first start with some clarifying questions. Is this algorithm to be used across Play Store for all kinds of apps or for some specific catgeory of apps What is the major objective. Are you entering a new market and hence objective is to capture market OR already in an existing market and want to maximise profit (since Google, most likely second objective) I would like to experiment with algorithms and see results before finalising. This will nee"See full answer

Jay C. - "How would you monetize messenger? Clarifying Questions Is this messenger app or web? INTERVIEWER: Assume both are a possibility, but feel free to pick one Is there a larger facebook goal or metric we are optimizing for? INTERVIEWER: Monetization speaks to revenue so assume goal is to increase revenue for Facebook as a whole Does this include messenger Rooms or should we stick to the traditional FB messenger? INTERVIEWER: _Messenger rooms is a great call out, but let's stick"See full answer

Jazmia H. - "Weak point: suggested something that YouTube Music already does- offering the service free to Premium members. Rebounded by saying the lack of user awareness is a pain point and how it can be mitigated- by frequent check-ins by way of notifications and emails Strong point: discussed overall strategies of global expansion, marketing and innovation with pros and cons for each approach. Settled on discussing an innovation piece combining ranked recommendation of YouTube music as well as personaliz"See full answer

Sam - "Disagreement --> persistent ---> more data insights ---> positive relationship ---> mentor/trust"See full answer

P K. - "Assuming this is meant to be a standalone product. Its a standalone app. Goal: Simplify the shopping experience in store for a user. Success would be defined in terms of app usage as a proxy for user satisfaction. I want to think about the a given user segment, their pain points, ways to improve their pain and a way to evaluate those solutions. Broadly user personas associated with grocery shopping are - stores and customers. For the purpose of this interview I want to focus on customer se"See full answer