Software Engineer Data Interview Questions

439,075 software engineer data interview questions shared by candidates

Q: how do you query tune? if a query is taking more time then it initially did, what may be the checkpoints and order of things to check to look at the cause Q: [python] find non duplicate numbers in first list and preserve the order of list [1,1,3,2,5,6,5] --> [1,3,2,5,6] Q: [python]flatten a nested list Q: [sql] Rank, row_number, dense rank questions
avatar

Data Engineer

Interviewed at Amazon

3.5
May 25, 2021

Q: how do you query tune? if a query is taking more time then it initially did, what may be the checkpoints and order of things to check to look at the cause Q: [python] find non duplicate numbers in first list and preserve the order of list [1,1,3,2,5,6,5] --> [1,3,2,5,6] Q: [python]flatten a nested list Q: [sql] Rank, row_number, dense rank questions

You are given 1000 containers of water with exactly one container containing poison. You can use pigs to test which container contains poison. The conditions are that: A pig drinking the poisoned water woudl die exactly after 1 hour and that a pig could be used for sampling multiple containers. Assume that the pig takes 0 time to drink water from any number of containers. What is the minimum number of pigs would you use to identify the poisoned container within 1 hour.
avatar

Software Development Engineer

Interviewed at Amazon

3.5
Mar 16, 2011

You are given 1000 containers of water with exactly one container containing poison. You can use pigs to test which container contains poison. The conditions are that: A pig drinking the poisoned water woudl die exactly after 1 hour and that a pig could be used for sampling multiple containers. Assume that the pig takes 0 time to drink water from any number of containers. What is the minimum number of pigs would you use to identify the poisoned container within 1 hour.

Viewing 1321 - 1330 interview questions

Glassdoor has 439,075 interview questions and reports from Software engineer data interviews. Prepare for your interview. Get hired. Love your job.