Skip to contentSkip to footer

Data Interview Questions

Salaries
Interviews

132,990 data interview questions shared by candidates

Two tables: User actions: date|sessio_id|userid|event session details: date|Sessionid|timespent_Sec|userid 1. Identify avg time spent per user per day 2. Create a histogram of duration on x axis, no of users on y axis which is populated by volume in each bucket Product questions: 1. Wants to add a new banner on FB Market place which suggests to sell something on facebook , should they do it, what should be done to evaluate it ? 2. Market place transactions happen through messages - these messages went down by 10% in a month, should they be worried ? How would you go about analyzing it?
avatar

Data Scientist

Interviewed at Meta

3.5★
Apr 15, 2019

Two tables: User actions: date|sessio_id|userid|event session details: date|Sessionid|timespent_Sec|userid 1. Identify avg time spent per user per day 2. Create a histogram of duration on x axis, no of users on y axis which is populated by volume in each bucket Product questions: 1. Wants to add a new banner on FB Market place which suggests to sell something on facebook , should they do it, what should be done to evaluate it ? 2. Market place transactions happen through messages - these messages went down by 10% in a month, should they be worried ? How would you go about analyzing it?

1. the ORDER BY command in SQL is automatically set in what format if you didn't set it? Ascending or Descending? Answer: Ascending 2. When you want to delete or add a column of a table in a database, what command you will use? Answer: ALTER 3. this question about about LEFT JOIN, they ask what command you want to use if you want to keep all the info of the left table? Answer: left join 4. You want to combine two column after removing two duplicates, use UNION or UNION ALL? Answer: UNION
avatar

Data Engineer

Interviewed at Meta

3.5★
Oct 26, 2018

1. the ORDER BY command in SQL is automatically set in what format if you didn't set it? Ascending or Descending? Answer: Ascending 2. When you want to delete or add a column of a table in a database, what command you will use? Answer: ALTER 3. this question about about LEFT JOIN, they ask what command you want to use if you want to keep all the info of the left table? Answer: left join 4. You want to combine two column after removing two duplicates, use UNION or UNION ALL? Answer: UNION

Viewing 981 - 990 interview questions

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