Data Interview Questions

132,929 data interview questions shared by candidates

Imagine you have N pieces of rope in a bucket. You reach in and grab one end-piece, then reach in and grab another end-piece, and tie those two together. What is the expected value of the number of loops in the bucket?
avatar

Senior Data Scientist

Interviewed at Natera

3.8
May 19, 2015

Imagine you have N pieces of rope in a bucket. You reach in and grab one end-piece, then reach in and grab another end-piece, and tie those two together. What is the expected value of the number of loops in the bucket?

Originally asked: If the ratio of green to red is 2 to 7 and there are 70 total marbles, how many green are there? Amended question after email: If the ratio of green to red is 2 to 7 and there are 70 red marbles, how many green are there?
avatar

Data Analyst

Interviewed at Capital One

3
Nov 8, 2016

Originally asked: If the ratio of green to red is 2 to 7 and there are 70 total marbles, how many green are there? Amended question after email: If the ratio of green to red is 2 to 7 and there are 70 red marbles, how many green are there?

SQL: 1. given table products(product_id, brand_name,product_name, product_price), find brand_names with avg price > 3 and having more then 5 products 2.given table sales (sale_id, promotion_id, sale_amount, other columns), find % of how sales with promotions ( promotion_id is null) are doing in comparison to all sales. Coding(Java): 1. find avg word length in a sentence 2. ip address validation 3. Friends problem [[A,B], [B,D],[E]...] ( List of lists);
avatar

Data Engineer

Interviewed at Meta

3.6
Jun 2, 2019

SQL: 1. given table products(product_id, brand_name,product_name, product_price), find brand_names with avg price > 3 and having more then 5 products 2.given table sales (sale_id, promotion_id, sale_amount, other columns), find % of how sales with promotions ( promotion_id is null) are doing in comparison to all sales. Coding(Java): 1. find avg word length in a sentence 2. ip address validation 3. Friends problem [[A,B], [B,D],[E]...] ( List of lists);

Given two tables with the following columns: USERS user id date time stamp post id user action action details POST_REMOVED_BY_REVIEWER post id date time stamp report the daily ratio of posts removed by reviewers out of the user reported posts (user action = report)
avatar

Data Scientist

Interviewed at Meta

3.6
Apr 18, 2020

Given two tables with the following columns: USERS user id date time stamp post id user action action details POST_REMOVED_BY_REVIEWER post id date time stamp report the daily ratio of posts removed by reviewers out of the user reported posts (user action = report)

Viewing 391 - 400 interview questions

Glassdoor has 132,929 interview questions and reports from Data interviews. Prepare for your interview. Get hired. Love your job.