Interview Questions

Elisa L. - "Facebook’s mission statement is to build community, so any product related to movies that Facebook builds should have that in mind. I’ll start by looking at the lifecycle of a movie and then some current pain points that people might have to think about opportunities for a movies product. The lifecycle of a movie revolves around creation (script, filming, casting, acting), production, and distribution (streaming services vs theatres). An idea for creation could be helping users collaborate or"See full answer

Ramendra S. - "Step 1: Clarifying the Problem Scope We will focus on designing the leaderboard for Dream11 with these assumptions: Registered teams: 100,000 users are actively participating and ranked. Real-time updates: Leaderboard updates frequently as players accumulate points based on live sports events. Multiple leagues: Each user can participate in different leagues, so we will need to maintain a separate leaderboard for each league. Query efficiency: Users frequently"See full answer

Shashank K. - "Situation: Our company was going through tech stack updated and our team tasked to migrate existing code into Typescript(TS) and all future development to be written with TS within our codebase. TASK: Migrate existing codebase to TS and future integration to be TS compatible. ACTION: The team deep dived into picking up TS skill and learnt some basics and focused on delivering the migration in phases. I prioritised the files to migrate based on levels of complexity. I created a Fil"See full answer

Simon O. - "Functional Requirement Ingest Book Reviews in real time User in the website needs specify title tho search books, return response is the list of reviews on the books. Non Functional Requirement: User get real-time book reviews> It nees to handle the search among 1 million of active users daily"See full answer

Mohammedsiraj A. - " Here is the breakdown of the information in those images: \\1. The Amharic Letter (Financial Request)\** This is a formal letter from the \Dawa Zone Muslim Affairs Council\\ addressed to the \\Commercial Bank of Ethiopia (CBE)\. \Date:\\ 30/6/2018 (Ethiopian Calendar) \\Subject:\\ Opening a savings account. \\Purpose:\\ The letter requests the opening of a savings account for \\Nuur Mosque\**, located in Bale Zone, Dawa City. \Authorized Signatories:\\"See full answer

Sahil A. - "Clarify: Zoom for business - we are referring to Zoom meetings for enterprise customers Are there any specific features or goals we want to track. Assumption - We are at overall zoom business for enterprise customers Is there any particular geography or demographics we want to look at - Assumption - we are looking at across the globe Goals: Zoom allows users to conduct meetings internally and externally with folks across the organization. Enterprise customers access Zoom with their cor"See full answer

Anonymous Stork - "For Xbox, the next-generation product I propose is a virtual reality headset. The rationale is threefold: Industry Trends: Competitors like Meta and Apple are investing heavily in VR/AR, signaling strong market potential. Xbox Legacy: Xbox has a history of pushing innovation in gaming hardware (e.g., Kinect), and VR represents the next frontier beyond traditional consoles. Strategic Need: With console sales flattening, Xbox must expand into new experiences that deepen engagement and different"See full answer

Jasmin R. - "Let's imagine you want to open Google Maps, you type maps.google.com and hit Enter. Here is what happens: You type maps.google.com into the address bar of your browser. Browser completes the address, for example, maps.google.com → https://www.maps.google.com [Address decoding] → browser breaks down the URL into parts ‘https://’: protocol → how the browser should connect to the website Default is HTTP (Hypertext Transfer Protocol) which shows up as ‘ http:/"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

Sameer S. - "I: Design a banking app for kids S: Sure, let me start with clarifying questions. What is our goal for building this app? I: To create financial literacy early in childhood and also increase our customer base. S: Sure. Are we going to launch it globally or in any specific geography or demography? I: Globally. S: Sure, Any resource or time constraints to keep in mind because I need to prioritize the features on the roadmap based on that? Also, are we launching it on iOS or Android? I: No resource"See full answer

Mark - "Questions: Should we consider US or Global? Is there any existing market insights/research around driverless cars adoption? Can we assume that driverless car technology is production / public ready by 2025? Is this focus on commercial or consumer use? Assumption: Let's look at US to start for our estimation since Driverless car regulation and adoption trend will probably differ per country Let's also assume we want to estimate market size for driverless cars in 2025 for consume"See full answer

Ankit M. - "Clarifying questions: When we talk about a 'meditation app', are we mainly focusing on audio content? And are we thinking of this under a big brand or are we a fresh startup? Also, is our main target the US? And, are we designing mainly for individual use, or are we thinking about larger settings like schools? Interviewer: It's a startup. We're aiming for individual users, mainly in the US, and yes, an audio-based format. Summary till now: In today's digital age there's an increasi"See full answer

David I. - "WITH filtered_posts AS ( SELECT p.user_id, p.issuccessfulpost FROM post p WHERE p.postdate >= '2023-11-01' AND p.postdate < '2023-12-01' ), post_summary AS ( SELECT pu.user_type, COUNT(*) AS post_attempt, SUM(CASE WHEN fp.issuccessfulpost = 1 THEN 1 ELSE 0 END) AS post_success FROM filtered_posts fp JOIN postuser pu ON fp.userid = pu.user_id GROUP BY pu.user_type ) SELECT user_type, post_success, post_attempt, CAST(postsuccess AS FLOAT) / postattempt AS postsuccessrate FROM po"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

Jacky Y. - "Problem scope: Can this system detect Bot in real-time online or offline? Both. Online traffic: 1M DAU. Latency: 2s. Offline frequency: daily Offline data: 2B activity logs. Data: How do we know a Bot player (Label)? Human label. Imbalance data: reweight, resample. Develop a Bot simulator to generate more data offline for training. Given lower weight to simulator data than human label. Features: Signals from different models online. Log all the features for offline. Propose new features: dail"See full answer

Syed A. - "Sales Performance Dashboard t for sales leaders to monitor product performance: Sales Performance Dashboard Top-Level Metrics (KPI Summary) Time Filter: [Day] [Week] [Month] [Quarter] [Custom Range] Total Sales Revenue Displays total revenue for the selected period. Units Sold Breakdown by product category and SKU. Average Deal Size Total revenue ÷ Number of deals closed. Conversion Rate _Leads to sales conversion ratio."See full answer