Data Interview Questions

132,905 data interview questions shared by candidates

Given three tables, user_dimension (user_id and account_id), account_dimension (account_id and paying_customer), and download_facts (date, user_id, and downloads), find the average number of downloads for free vs paying customers broken out by day.
avatar

Data Analyst

Interviewed at Uber

3.7
Jun 2, 2017

Given three tables, user_dimension (user_id and account_id), account_dimension (account_id and paying_customer), and download_facts (date, user_id, and downloads), find the average number of downloads for free vs paying customers broken out by day.

SQL part1 Question # 1 : you have the following table - User_id , action (post, edit, cancel) , date == > what is the post rate Question # 2 : you have also the following table (active users) - User_id , country , active , date == > What is the average post rate for yesterday for all active users by country
avatar

Data Scientist

Interviewed at Meta

3.6
Aug 7, 2019

SQL part1 Question # 1 : you have the following table - User_id , action (post, edit, cancel) , date == > what is the post rate Question # 2 : you have also the following table (active users) - User_id , country , active , date == > What is the average post rate for yesterday for all active users by country

SQL Select the value of a column based on the max of a different column from each grouping of yet a third column. Column A, Column B, Column C. For each group based on Column A, give value of Column B, where Column C is max for that group.
avatar

Data Engineer

Interviewed at Amazon

3.5
Apr 29, 2020

SQL Select the value of a column based on the max of a different column from each grouping of yet a third column. Column A, Column B, Column C. For each group based on Column A, give value of Column B, where Column C is max for that group.

Lets say the population on Facebook clicks ads with a click-through-rate of P. We select a sample of size N and examine the sample's conversion rate, denoted by hat{P}, what is the minimum sample size N such that Probability( ABS(hat{P} - P) < DELTA ) = 95%. In other words (this is my translation), find the minimum sample size N such that our sample estimate hat{P} is within DELTA of the true click through rate P, with 95% confidence.
avatar

Data Scientist, Analytics

Interviewed at Meta

3.6
Mar 6, 2015

Lets say the population on Facebook clicks ads with a click-through-rate of P. We select a sample of size N and examine the sample's conversion rate, denoted by hat{P}, what is the minimum sample size N such that Probability( ABS(hat{P} - P) < DELTA ) = 95%. In other words (this is my translation), find the minimum sample size N such that our sample estimate hat{P} is within DELTA of the true click through rate P, with 95% confidence.

Viewing 71 - 80 interview questions

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