Interview Questions

KAI - "Answer: select fromcaller, count(DISTINCT tocallee) as num_calls from calls group by fromcaller having count(DISTINCT tocallee) >= 3 Setup: CREATE TABLE calls ( from_caller VARCHAR(20), to_callee VARCHAR(20) ); INSERT INTO calls (fromcaller, tocallee) VALUES ('Alice', 'Bob'), ('Charlie', 'Dave'), ('Alice', 'Frank'), ('Charlie', 'Heidi'), ('Charlie', 'Judy'); "See full answer

Shubham S. - "Introduction UberSenior is a new service offered by Uber that provides safe, reliable, and convenient transportation for senior citizens. This PRD outlines the key features, functionalities, and user experience for both seniors and drivers using UberSenior. Problem Statement Existing transportation options for seniors often have limitations, including: Accessibility: Lack of vehicles equipped for mobility aids or physical limitations Technology barriers: Difficulty using smartphone"See full answer

Jasmin R. - "Candidate: Before we go ahead I have a few clarifying questions, I’d like to ask. Interviewer: Sure. Candidate: What is the exact definition of a restaurant, are we counting coffee shops, bars, street food trolleys, homemade food shops that only has delivery to customers’ place and etc... kinds of a restaurant as well? Interviewer: let’s assume that we only mean restaurants that people can go inside, order some food and eat. Let’s not consider bars and coffee shops and so"See full answer

Ushita S. - "A clarifying question: Is this question asking about when I met a tight deadline in a project or how did I manage a project that had a tight deadline? The answer uploaded to this question is good, I would also add 'creating a critical path from overall project schedule and then making sure that none of the deliverables in the critical path are sacrificed in order to meet the tight deadline' as an action taken."See full answer

Kat - "Clarification: What types of jobs are we targeting? Are we talking about a broad market (like Indeed) or more focused—white-collar (LinkedIn-style) or blue-collar (gigs and tasks)? Where are we launching the marketplace—U.S. or globally? Let’s assume U.S. for now. Is this a standalone product or integrated within one of Meta’s existing platforms (Facebook, WhatsApp, Instagram)? Let’s assume it’s integrated into Facebook. Overview: Meta’s Mission: Why would Meta want to launch a"See full answer

Ajay P. - "Designing an evaluation framework for ads ranking is crucial for optimizing the effectiveness and relevance of ads displayed to users. Here's a comprehensive framework that you can use: Define Objectives and Key Performance Indicators (KPIs):** \\Click-Through Rate (CTR):\\ The ratio of clicks to impressions, indicating the effectiveness of an ad in attracting user attention. \\Conversion Rate:\\ The ratio of conversions (e.g., sign-ups, purchases) to clicks, measuring how well"See full answer

Simran S. - "I recently led the development and implementation of a data analytics platform tailored for credit unions and mortgage companies, which was suffering from fragmented systems, inconsistent data fields across LOS platforms, and outdated reporting practices. Here's how I managed the full lifecycle: ✅ Initiation / Discovery Conducted executive interviews across five financial institutions to understand reporting and visibility gaps. Shadowed loan officers and underwriters"See full answer

Debajyoti B. - "First Clarify whether this is for FB general account or business account Why is removing the profile pic being considered in the first place? Declining conversion rates? TTV(signup to post creation) is perceived as too high wrt competing apps? Meta is considering a single signup for all its apps(FB, Insta, WA) & is looking to optimize the same? Do we have any supporting data for this? user feedback? Next Look at current FB signup flow(assuming these are the steps since its be"See full answer

Karthik M. - "Assumptions & Clarifications This is a platform based on YouTube, and it can use associated Google Products like Gmail, GDocs, GSheets etc along with Youtube as a base platform. Do you have any specific goals with the platform? For instance, should this be the de facto platform for Universities K12 schools etc? Assumption is that it can be used by anyone. Let us first discuss the target users, and then arrive at appropriate goals that we can use to measure the adoption of the produc"See full answer

Vince S. - "1. Requirements Analysis Functional Requirements Video streaming with multiple quality levels Content browsing and search Continue watching functionality Content recommendations Non-Functional Requirements Low latency video delivery (<2s startup time) High availability (99.99% uptime) Scalability to handle millions of concurrent streams API response time < 100ms 2. Microservices Architecture Core Microservices Content Service Content metadata mana"See full answer

Fahad K. - "Alright, let's think through this change of moving the 'like' button to a menu under three dots on photos I'll start by aligning this change with Facebook's mission, analyze key insights, define the product mission for this update, Identify the eco-system (n-sided marketplace) Look at the effects on the eco-systems, Effects on their needs and pain points. Identify the most important actors and most important actions Come up with some metrics that we may be using to"See full answer

Tiffany A. - "SELECT employees.first_name, managers.salary AS manager_salary FROM employees LEFT JOIN employees AS managers ON employees.manager_id = managers.id WHERE employees.salary > managers.salary `"See full answer

Javed S. - "One good reason for using the doubly linked list is that to remove an accessed item in the list from its existing position say in the middle of the list and move it to the head, you need to update the previous node's next pointer and the next node's previous pointer. A singly linked list only has next pointers, so removing from the middle would require traversing from the head to find the previous node which requires O(n) time. A doubly linked list allows O(1) removal from any position because w"See full answer

Maulik S. - "To build a product using Generative AI (Gen AI), the process would involve multiple steps, from conceptualization to deployment. Here's a structured approach : 1. Identify the Problem or Opportunity Start with the need or opportunity: What problem do you want to solve? Is it to automate tasks, generate content, enhance creativity, or improve user experience? Example products:A content creation tool that generates blog posts or articles. A personalized customer support chatbot"See full answer

Umang S. - "Just a bit of context on what could be a risk in Product or Software Development. We talk about the Scope, Quality, and Time Triangle. IMHO the only variables that can matter and can pose risk are these. Try to form an answer where you used the Effort, Value, Risk framework to quantify the risk. The answer can be similar to short term sacrifices for long term gains, as you do take in mind the risk the short term sacrifices pose. Situation - I was leading the team to complete an overhaul of the"See full answer

Sahil A. - "Clarifying questions: Open metrics - Number of times users open the google document on a given day 10% decline - is it a gradual decline or steep decline? (since when) Do we witness decline from a specific geography? Decline for consumers or enterprise customers? Decline from web or mobile app? Review logs or bug reports to check if there are customer issues reports Internal Determine if a particular release is causing the issue Review other metrics to check if fewer do"See full answer

Pankhuri T. - "Clarifying Questions - Who are we referring to "friends" and "non-friends"? (My assumption is people who we follow and they follow us back are our FRIENDS and people who we just follow, recommendations by Facebook and all other content falls under NON-FRIENDS category, is it right?) Are we doing it putting a certain success metric in our mind? (Assuming none, just to make people's lives easy) Let's use a combination of GAME & 4W1H Framework here to evaluate this question **G"See full answer

Palak A. - "Designing a system to deny services to requests from banned IPs involves integrating real-time IP checking with your service architecture. Here’s a detailed outline of how you can design such a system: System Design Overview The goal is to ensure that your service can efficiently check incoming requests against a list of banned IPs and deny access when necessary. The system will leverage an external API, security.gov.x, to determine if an IP address is blocked or allowed. **Key Compone"See full answer