Data Interview Questions

132,958 data interview questions shared by candidates

Python -Count distinct words in a sentence -Count the number of times a word appear in a sentence using a Hash Map -Return tuples of a list, matching each item to another item -Count the number of times a substring appear in a string SQL -Return min and max age of male/female who bought a product -Count the number of stores in a state with grand total ? 25000 sq feet
avatar

Data Engineering

Interviewed at Meta

3.6
Jun 2, 2017

Python -Count distinct words in a sentence -Count the number of times a word appear in a sentence using a Hash Map -Return tuples of a list, matching each item to another item -Count the number of times a substring appear in a string SQL -Return min and max age of male/female who bought a product -Count the number of stores in a state with grand total ? 25000 sq feet

Three ants are sitting at the three corners of an equilateral triangle. Each ant starts randomly picks a direction and starts to move along the edge of the triangle. The probability that none of the ants collide = [ ? / ? ] Follow-up: k ants are sitting at the k corners of an equilateral polygon. Each ant starts randomly picks a direction and starts to move along the edge of the triangle. The probability that none of the ants collide = [ ? / ? ] Count how many trailing 0 in (100!)
avatar

Data Scientist

Interviewed at Meta

3.6
Jun 4, 2015

Three ants are sitting at the three corners of an equilateral triangle. Each ant starts randomly picks a direction and starts to move along the edge of the triangle. The probability that none of the ants collide = [ ? / ? ] Follow-up: k ants are sitting at the k corners of an equilateral polygon. Each ant starts randomly picks a direction and starts to move along the edge of the triangle. The probability that none of the ants collide = [ ? / ? ] Count how many trailing 0 in (100!)

2) create daily revenue report between given start_date and end_date output schema: (order_date, number_of_customers, number_of_orders, daily_total_order_amount, mtd_order_amount) mtd_order_amount - total order_amt from the beginning of the month till order_date
avatar

Data Engineer - Business Intelligence

Interviewed at Amazon

3.5
Apr 6, 2018

2) create daily revenue report between given start_date and end_date output schema: (order_date, number_of_customers, number_of_orders, daily_total_order_amount, mtd_order_amount) mtd_order_amount - total order_amt from the beginning of the month till order_date

Viewing 501 - 510 interview questions

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