MISSING VALUE Interview Questions

6,572,323 interview questions shared by candidates

Given a multi-step product feature, write SQL to see how well this feature is doing (loading times, step completion %). Then use Python to constantly update average step time as new values stream in, given that there are too many to store in memory.
avatar

Data Engineer

Interviewed at Meta

3.6
Apr 30, 2018

Given a multi-step product feature, write SQL to see how well this feature is doing (loading times, step completion %). Then use Python to constantly update average step time as new values stream in, given that there are too many to store in memory.

SQL: 1. Percentage increase in revenue compared to promoted and non-promoted products. 2. Products classes that has the highest transactions 3. Count of Customers who bought 2 items type (A,B) 4. Don't remember Python: 1. Average length of letters to words. 2. Parse an ip address (This is a favourite FB question) 3. [[A],[A,B],[A,C],[B,D],[C,A]] -- Find the alphabet with highest neighbors? -- (Wasnt able to solve because of time limit but the interviewer was like I get what I want to convey.. I gave her an algo of what I would I have done)
avatar

Data Engineer

Interviewed at Meta

3.6
Sep 21, 2018

SQL: 1. Percentage increase in revenue compared to promoted and non-promoted products. 2. Products classes that has the highest transactions 3. Count of Customers who bought 2 items type (A,B) 4. Don't remember Python: 1. Average length of letters to words. 2. Parse an ip address (This is a favourite FB question) 3. [[A],[A,B],[A,C],[B,D],[C,A]] -- Find the alphabet with highest neighbors? -- (Wasnt able to solve because of time limit but the interviewer was like I get what I want to convey.. I gave her an algo of what I would I have done)

business sense: There are two types of cars A and B. The number of people in US who use A and B are the same. They drive the same distances each month. Now there are two new technologies, X and Y (of equal cost). If apply X, mpg of A would increase from 50 mpg to 75 mpg; If apply Y, mpg of B would increase from 10 mpg to 11 mpg. The goal is to decrease the dependence on foreign oil, or to decrease the consumption of gasoline. Question: which technology would you apply? Follow up question: after applying the technology of your choice, assume there's money available for research on new technology, which car would you choose to conduct research on?
avatar

Data Scientist

Interviewed at Meta

3.6
Jan 7, 2015

business sense: There are two types of cars A and B. The number of people in US who use A and B are the same. They drive the same distances each month. Now there are two new technologies, X and Y (of equal cost). If apply X, mpg of A would increase from 50 mpg to 75 mpg; If apply Y, mpg of B would increase from 10 mpg to 11 mpg. The goal is to decrease the dependence on foreign oil, or to decrease the consumption of gasoline. Question: which technology would you apply? Follow up question: after applying the technology of your choice, assume there's money available for research on new technology, which car would you choose to conduct research on?

Viewing 2171 - 2180 interview questions

Glassdoor has 6,572,323 interview questions. Prepare for your interview. Get hired. Love your job.