Interview Question

There are two lists of dictionaries representing friendship beginnings and endings: friends_added and friends_removed. Each dictionary contains the user_ids and created_at time of the friendship beginning /ending .

Write a function to generate N samples from a normal distribution and plot the histogram.

We have a table called `song_plays` that tracks each time a user plays a song.Let's say we want to create an aggregate table called `lifetime_plays` that records the song count by date for each user.Write a SQL query that could make this ETL each ...

Let's say we have a table with an id and name field. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.Write a query to randomly sample a row from this table.

What is the ROC curve and the meaning of sensitivity, specificity, confusion matrix?

How would you explain what MapReduce does as concise as possible?

Find the maximum of sub sequence in an integer list?

How would you select a representative sample of search queries from six million?

How to explain a deep learning model to customers?

Given a time series dataset, how will you predict future value?