Given the following tables how would you know who has the most friends REQUESTS date | sender_id | accepter_id ACCEPTED accepted_at | accepter_id | sender_id
Data Interview Questions
132,688 data interview questions shared by candidates
1) Provided a table with user_id and dates they visited platform, find the top 100 users with the longest continuous streak of visiting the platform as of yesterday. 2) Provided a table with page_id, event timestamp and a flag for a state (which is on/off), find the number of pages that are currently on.
""" # Question 2: # Fill in the blanks # # Given an array containing None values fill in the None values # with most recent non None value in the array # # For example: # - input array: [1,None,2,3,None,None,5,None] # # - output array: [1,1,2,3,3,3,5,5] #
There is a table that tracks every time a user turns a feature on or off, with columns user_id, action ("on" or "off), date, and time. How many users turned the feature on today? How many users have ever turned the feature on? In a table that tracks the status of every user every day, how would you add today's data to it?
given a list of tuples of movie watched times, find how many unique minutes of the movie did the viewer watch e.g. [(0,15),(10,25)]. The viewer watched 25 minutes of the movie.
Where you from?
Pretty much in line with what other people have been asked.
No questions were difficult
Behavioral questions probing about fit
Design patterns questions
Viewing 31 - 40 interview questions
See Interview Questions for Similar Jobs
Computer OperatorDatacenter TechnicianNoc OperatorConfiguration Management AnalystCirculation ManagerMedical ClerkManager AnalyticsMailroom ClerkMail SorterMedical Office ReceptionistMedical Office ClerkMail Room ClerkMedical Record Retrieval SpecialistManual Software TesterMedical Office SpecialistManager Marketing AnalyticsMedical Claims ProcessorMedical Billing ClerkMarketing Analytics Manager