Practice for the Dynetics interview with these recently asked interview questions.
| Question | Topic | Difficulty | ||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL | Medium | |||||||||||||||||||||||||||||||||||||||||||
Over budget on a project is defined when the salaries, prorated to the day, exceed the budget of the project. For example, if Alice and Bob both combined income make 200K and work on a project of a budget of 50K that takes half a year, then the project is over budget given 0.5 * 200K = 100K > 50K. Write a query to forecast the budget for all projects and return a label of Note: Assume that employees only work on one project at a time. Example: Input:
departments table
Output:
| ||||||||||||||||||||||||||||||||||||||||||||
Data Structures & Algorithms | Hard | |||||||||||||||||||||||||||||||||||||||||||
Behavioral | Medium | |||||||||||||||||||||||||||||||||||||||||||
SQL | Easy | |
Machine Learning | Medium | |
Statistics | Medium | |
SQL | Hard | |
Machine Learning | Medium | |
Python | Easy | |
Deep Learning | Hard | |
SQL | Medium | |
Statistics | Easy | |
Machine Learning | Hard |
Check your skills...
How prepared are you for working at Dynetics?
Discussion & Interview Experiences