Interview Questions

Bala G. - "WITH ActiveUsersYesterday AS ( SELECT DISTINCT user_id FROM user_activity WHERE activity_date = CAST(GETDATE() - 1 AS DATE) ), VideoCallUsersYesterday AS ( SELECT DISTINCT user_id FROM video_calls WHERE call_date = CAST(GETDATE() - 1 AS DATE) ) SELECT (CAST(COUNT(DISTINCT v.userid) AS FLOAT) / NULLIF(COUNT(DISTINCT a.userid), 0)) * 100 AS percentagevideocall_users FROM ActiveUsersYesterday a LEFT JOIN VideoCallUsersYesterday v ON a.userid = v.userid;"See full answer

Precious H. - "Firstly, In designing a denoising system for sounds, I would start by clarifying the type of noise either stationary or non-stationary and application constraints which are the latency, scalability, accuracy and deployability. For real-time systems like Google meet, I will prefer a hybrid DSP + ML model like RNNoise. For batch processing like YouTube audio enhancement, a deep learn-based system such as Demucs or SEGAN would work well. Then I will need to evaluate how well the system improves aud"See full answer

Amy M. - "Before we head into this - let's redefine this question to identify some objectives and key results: re-Design FB security privacy intimacy a few questions I want to clarify are: Is this for desktop, mobi web, or apps? Apps Is this for US only? Yes May I assume some resources available for me? Such as Designers, Data Scientists, Developers? Sure ----- Okay let me think about this for a min ---- I'd like to start off by: Thinking about th"See full answer

D P. - "Question for the community: have others experienced a situation where the interviewer really pushed for defining a success metric early on in the case before making too much progress on the case itself? If so, how did you handle? How I approached the case: I used the framework taught here on Exponent but have a question for the community. At the beginning of the interview, I shared my steps - company goals, customer, painpoints, solutions, prioritize and if we had time, I'll explore some succ"See full answer

P D. - "Clarifying questions Define relevant? Google should keep progressing in solving customer usecases / increasing revenue and profitability over next 10 yrs Since we are discussing about 10 yr period, can i assume that we need not have any constraints in mind? Yes, do not consider any constraints Just to be clear this is about Google in specific and not about Alphabet and various companies within the group. Yes, let's focus on google Last assumption, can we assume that the overall goal / vi"See full answer

Aeshvarya J. - "Clarifying questions : When we speak about video buffering, are we looking at long video (more than an hour), medium video, short videos and shorts? I will assume its all video types. Is this was a steady increase or sudden one and over what time period? I will assume sudden one over last week? Has we experienced any such issues in the past or trends? I will assume no. Are we experiencing this globaly or for some region? I assume globaly The KPI we are measuring is Average Video Buffering T"See full answer

Andrew M. - "DMV is the Department for Motor Vehicles, notorious for long wait times and an overall poor customer experience. I'm not familiar with the different functions that the DMV serves, but from my understanding, people go to the DMV when they want to renew their drivers licenses, so I would like to focus on that for now. Current experience: Long wait time to get drivers license photo taken I am really not familiar with any other services the DMV provides, so I will focus on taking photos. Pain"See full answer

Anonymous Flamingo - "One challenge that I faced when working with sales was managing unrealistic expectations. As a developer, I often had to work with sales teams to define the scope and timeline for projects. However, it was not uncommon for the sales team to promise clients certain features or deliverables that were not feasible within the allotted time and budget. To address this challenge, I learned to be proactive in clarifying the limitations and constraints of the project with the sales team, and to work wit"See full answer

G. D. - "It's possible the Onboarding Flow is fine as it is - but I would do some initial hands-on exploring. I would go through the boarding steps myself. Re-Visit the flow with a clean perspective. Take notes on Pros & Cons. Things I liked. Things I didn't like. Create a table. Brainstrorm some UI / UX / Flow features that could use some improvement. If my simple analysis warranted some more exploration - I would do an informal survey with my immediate internal colleagues - and possibly even my tight"See full answer

Dhruv M. - "During my internship at Insighta Analytics, our team was planning to prioritize a marketing campaign focused on customer acquisition through social media ads. The marketing lead was confident this would yield the best ROI based on past success. I was tasked with supporting the strategy by analyzing customer engagement trends. But as I dove into the data, I started to question whether the current direction was the best use of our budget. I analyzed customer conversion data from the last two quart"See full answer

Will P. - "The first step is to clarify what the interviewer means by a sales decline. Questions I would ask here include: Did sales drop suddenly or gradually? What is the magnitude of the sales drop? Are sales down for a specific product? Are sales down for a specific channel (drive-thru, walk-in, etc.)? This series of questions is to make sure we are on the same page when we say 'sales are down.' We may not know the why yet, but the what should be easy to align on. Otherwise, how would"See full answer

Madhu K. - "Define success for Youtube search I would start with clarifying questions / assumptions, followed by mission of YouTube (YT). I would then list down a few metrics that would be guided by the goal of YouTube and which user actions link to that goal and finally which of them should be used to define success. Clarifying questions: When you say YouTube search, can I assume only text search for now and exclude voice search ? Interviewer: Thats fine. We can stick to text search for now. "See full answer

Gk K. - " can we use blomfilters to check existing usernames? and if both are creating at a time, like both are choosing some abcd , here system checks whether user with that name exists or not. so while checking , it will add an entry on redis (example) with this name as key and obtain lock using some distributed lock. , it will lock on that name. (like seat booking in bookmyshow) with some TTL value. so this check will happen once user enters his interest username and also while submit .. 2 times che"See full answer

Stanislav I. - "First, take a BIG short position in Tesla stocks!"See full answer

Rick E. - " O(n) time, O(1) space from typing import List def maxsubarraysum(nums: List[int]) -> int: if len(nums) == 0: return 0 maxsum = currsum = nums[0] for i in range(1, len(nums)): currsum = max(currsum + nums[i], nums[i]) maxsum = max(currsum, max_sum) return max_sum debug your code below print(maxsubarraysum([-1, 2, -3, 4])) `"See full answer

Ananya M. - "US population = 330M , 80M across 4 generations population that is physically able to travel, can afford travel, travels for business ranges between 20-60 year olds = 160M calculating maximum demand: long weekends in summer are peak travel times, lets assume 60% of population who are able and can afford travel, do so during long weekend = 0.6x160M lets say 60% of this population choses prefers domestic travel while 40% go international (consider Mexico, Canada, London are international"See full answer

James H. - "I broke the vehicles down by regions in the world. Designed a wireless api interface to sync with a database backend that linked to google maps through another service and api."See full answer

Alibi M. - "I would answer this question using MECE framework: Profit = Revenue - Costs. Revenue = # customers * price In case of the trading platform, this could be translated into avg. trading activity per user * avg. commission rate . Ask if there has been any recent change to Active users or their trading activities. Similarly, ask if the commission rate has been changed recently. Based on this information, you can then identify the problem and get to the root cause of this. Similarly with Costs. "See full answer