Data Interview Questions

132,711 data interview questions shared by candidates

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.6
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 401 - 410 interview questions

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