Dynetics Interview Questions

Dynetics Interview Guides

Click or hover over a slice to explore questions for that topic.
Data Structures & Algorithms
(10)
Behavioral
(6)
Machine Learning
(4)
SQL
(3)
Concurrent & Distributed Systems
(2)

Dynetics Interview Questions

Practice for the Dynetics interview with these recently asked interview questions.

QuestionTopicDifficulty
SQL
Medium

Let’s say you work at a file-hosting website. You have information on user’s daily downloads in the download_facts table

Use the window function RANK to display the top three users by downloads each day. Order your data by date, and then by daily_rank

Example:

Input:

download_facts table

Column Type
user_id INTEGER
date DATE
downloads INTEGER

Output:

Column Type
daily_rank INTEGER
user_id INTEGER
date DATE
downloads INTEGER
SQL
Medium
Behavioral
Medium
Loading pricing options

View all Dynetics questions

Challenge

Check your skills...
How prepared are you for working at Dynetics?

Discussion & Interview Experiences

?
There are no comments yet. Start the conversation by leaving a comment.

Discussion & Interview Experiences

There are no comments yet. Start the conversation by leaving a comment.

Jump to Discussion