Interview Question

Given a database of posts and a database of comments on those posts, how do you determine how many conversations are happening in the comments per post on average?

Provided a table with page_id, event timestamp, and an on/off status flag, find the number of pages that are currently on.

Provided a table with user_id and the dates they visited the platform, find the top 100 users with the longest continuous streak of visiting the platform as of yesterday.

The Events team wants to up-rank Events such that they show up higher in Search. How would you determine if this is a good idea or not?

You notice that the number of users that clicked on a search result about a Facebook Event increased 10% week-over-week. How would you investigate? How do you decide if this is a good thing or a bad thing?

Columns: date STRING date of the search, search_id INT the unique identifier of each search, user_id INT the unique identifier of the searcher, age_group STRING ('<30', '30-50', '50+'), search_query STRING the text of the search query   Sample Rows: date | search_id | user_id | age_group | search_query -------------------------------------------------------------------- '2020-01-01' ...

What kind of workplace do you imagine yourself working in?

Do you know the main motto of our company?

You have such a good academic record. Why don’t you want to pursue a PhD?

Where do you wish to see yourself in 5 years from now?