Meta Interview Questions
Practice the exact questions companies are asking right now.
Compute ads revenue by geography in SQL
You have ad delivery logs for a shop-ads system. Tables ad_impressions - impression_id STRING (PK) - ts TIMESTAMP (UTC) - user_id STRING - shop_id STR...
How to evaluate similar-listing notifications feature
Case study (Marketplace product analytics) Context: Circle is a US marketplace app for buying and selling second‑hand products. On a product listing p...
Compute probability an account is fake
A platform uses an automated classifier to flag potentially fake accounts. Assume: - Base rate: 2% of accounts are fake. - The classifier flags a fake...
Evaluate new shop-ads ranking algorithm
You work on a marketplace with shop ads. A new ranking/recommendation algorithm is proposed to promote shop ads more aggressively, but stakeholders ar...
Handle conflict and urgent shifting priorities
Answer the following behavioral questions with concrete examples from your experience: 1. Describe a conflict you had with a partner or teammate. What...
Describe failures, self-reflection, and conflict resolution
Answer the following behavioral prompts with recent examples: 1. Self-reflection / improvement - “In a recent project, where could you have done be...
Answer four array/time/grid query questions
You are given four independent coding questions. Q1) Best value-for-money item You are given two arrays of equal length prices and ratings (each ratin...
Design metrics and experiment for stolen-post detection
You work on Stolen Post Detection for a social platform (detecting content that is copied/reposted without permission). A new detection algorithm is p...
Identify User Interest in Group Video Calls Using Data
Group Video-Calling Feature Analysis Context You are asked to design, launch, and analyze a new group video-calling feature for a large social/messagi...
Solve SQL and Python coding tasks
You are given a small library system with the following relational schema and several Python data-processing tasks. Answer the SQL questions and imple...
Validate parentheses and find k-th largest
Problem A — Validate parentheses Given a string s containing only the characters '(', ')', '[', ']', '{', '}', determine whether the input string is v...
Compute reply-based user metrics in 7 days
You are analyzing discussions on a social platform. Tables all_post - post_id (BIGINT, PK) - post_author_id (BIGINT, FK → user.user_id) - post_creatio...
Write SQL for car rental utilization by city
SQL / Data Query Prompt (Car Rental) You are given four tables: user - user_id location - location_id - city car - car_id - car_size (e.g., compact, m...
Evaluate impact of short videos in feed
Scenario You work on a social app’s main News Feed. The team wants to introduce a short-form video module ("Reels") into the feed. Prompt 1. How would...
Write SQL for video-call recipients and FR activity
Given the schema and samples below, write ANSI‑SQL to answer both questions. Assume dates are stored in UTC. Today is 2025-09-01, so “yesterday” is 20...
Calculate Response Rate and Compare User Survey Ratings
USERS user_id | signup_date 10 | 2024-03-20 11 | 2024-04-01 12 | 2024-04-05 SURVEYS survey_id | user_id | sent_at 1 | 10 ...
Fake Accounts [AE]
Detecting and Managing Bad Accounts on a Social Platform 1) Probability of a Bad Account Sending Friend Requests Context: 1% of accounts are bad. Bad ...
Design and evaluate a new group call feature
Product / DS Case: Group Calls for Messenger Groups Messenger has Groups but does not currently support group calls. You are evaluating whether to bui...
Compute active ad revenue by creation source
You work on an ads platform and need to report active ad revenue broken down by the ad’s creation source. Tables ads - ad_id BIGINT PK - advertiser_id...
Model entities for feed content and shares
Scenario You are designing the data model for a social app’s News Feed that shows multiple content types (text, image, short video). Users can interac...