Interview Questions

Bala G. - "SELECT s.Sale_Date, SUM(si.Quantity * si.SalePrice) AS TotalRevenue FROM Sales s JOIN SaleItems si ON s.SaleID = si.Sale_ID GROUP BY s.Sale_Date ORDER BY s.Sale_Date; "See full answer

Jagat mohan B. - "Found bug will not impact on the new requirements, if the engineering team aware of the source of the bug and the severity, than it can easily be handled and regression test to perform for a quality check. The new requirement should be equally prioritize for groom and start creating task and team to work on it. Finally based on the severity of the bug you can shuffle the resources between these items."See full answer

Anna D. - "Situation. Initially, my team consisted of young guys who were hired by team leaders based on hardskills. Previously, the company had just begun the transition from a process-based to a product-based approach. In the process of searching and selecting candidates, the interests of the team and the product owner were not taken into account. The candidate didn't pass a behavioral interview on soft skills. Thus, the team consisted of diverse and talented guys, but not very interested in fast wor"See full answer

S R. - "Wrote up a simple cache system using python dict. Added TTL requirement. Then went into code-level concurrency issues for the cache."See full answer

Tracy M. - "I defaulted to a dictionary-style definition of autonomy, then loosely tied it to users and systems. But I missed the interviewer’s signal that this was really a design/strategy probe. Stopping at a generic level made it sound like I couldn’t translate agency into what matters for product — user trust, trade-offs, risk, and roadmap implications."See full answer

Vikas T. - "Too much talk nothing concrete to know about the person that I am interviewing."See full answer

Ramachandra N. - " def closest_palindrome(n: str) -> str: """ Finds the closest palindromic number to n (excluding itself). Assumptions: If two palindromes are equally close, return the smaller one. n is a positive integer represented as a string. Time Complexity: O(1) Space Complexity: O(1) """ length = len(n) num = int(n) Helper to build palindrome from a prefix def makepalindrome(prefix: int, isodd_length: bool) -> int: s = str(prefi"See full answer

Arya C. - "Idea: Time complexity: O(n) each node visited once Space complexity: O(h) recursion stack For each node, we want to verify: Descendants here means all nodes in the subtree excluding the node itself. We do a post-order traversal (process children before the node itself). For leaf nodes, there are no descendants, so they are valid by definition. For internal nodes: Recursively compute the sum and count of nodes in the left and right subtrees. Calculate the total sum and"See full answer

Soledad A. - "Where is the second part of the video?"See full answer

Maya B. - "Sounds like interesting problem! First I'd like to clarify a few things.... Clarify/Find Constraints. WHO - who are we improving the post-booking experience for? restaurant visitors? or restaurant staff who view reservations? new vs existing users? WHAT - what do we mean by improve? is there a specific metric we're looking to improve upon (user experience? increasing show-up rate? booking a second time? etc.?) confirm process/JTBD - are we referring to the standard OpenTab"See full answer

Michelle D. - "I'd approach this first with a clarifying questions geared towards fraud prevention as these are going to be important to actually finding a root solution. I'd want to take cues from the interviewer in order to then identify potential hypotheses. Clarifying questions: How is fraud calculated? It's important to clarify the metric used to know that fraud is increasing. For example, is this a percent of all customers or transactions? Is the fraud that the merchant reported confirmed fraud"See full answer

Shivastuti K. - "For somebody who needs accessibility accommodation, this doesn't have a transcript so it is not useful to me."See full answer

Surbhi A. - "Authentication verifies "Who you are." Authorization determines "What you can do." Authentication establishes identity, while authorization specifies the actions or resources a user or entity is allowed to access or perform."See full answer

Scott S. - "Great question! Last year, we were working on a critical project to develop a real-time risk analytics platform. This platform was designed to provide our traders with instantaneous risk metrics, allowing them to make informed decisions in a fast-paced trading environment. Midway through the project, we faced a significant issue: our chosen data processing framework was not performing as expected under the high data throughput required by our trading algorithms. This was causing unacceptable lat"See full answer

Hamzeh H. - "S – Situation: In a university project, my team was building a collaborative code editor. As part of the functionality, we needed a login system so users could securely access their sessions and collaborate in real time. T – Task: I was responsible for implementing the authentication system. Initially, I planned to build the entire login system from scratch, including user management, password storage, and session handling. But as the deadline approached, I realized that implementing thi"See full answer

Izzy K. - "Clarifying questions (since there is no interviewer to clarify, I will state and make my assumptions below): Is this an app for park-goers, Six Flags employees, or some other stakeholder? Assumption: this is an app for park-goers Is there an age-limit on the app? Assumption: There is no specific age-limit, but it should be family friendly Will this app be standardized across all Six Flags locations? Assumption: yes To design this product, I will explain my thought proces"See full answer

Jay K. - "First, let’s discuss why this is important for any platform business Think of platform businesses like Amazon or YouTube as matchmakers. They connect people who want something with those who provide it, whether it's products or content. But here's the catch: users trust these platforms to make sure they're getting good stuff. They want genuine products, safe content, and no scams. So, platforms need to be like guardians. They check suppliers and content creators to make sure they're not"See full answer

Rani Y. - "Prompt : design a farm product Clarifying question : what is the timeline and budget that i need to consider to build this ? 1 year , flexible budget . Is there any geography that i need to focus on ? no restriction What is farming ? Farming is a practice of raising crops and braising animals to produce food for human survival . This is one of the old / primitive ways to grow food using natural resources like land , water etc Why is it imp now ? Farming as I said is vary primitive way to grow fo"See full answer

Debajyoti B. - "Understanding the problem: What do we mean by email notification experience here? Is it the quantity of notifications or quality?- it's the quality of the experience i.e. how can we make the experience better & more user centric How would you define enhance in this context?- here enhacement means improving the engagement with the emails resulting in more people viewing the photo/s on FB with email as source Are we supposed to enhance the viewer's experience only or the creators as w"See full answer