Fill sparse table Test for Senior Data Engineer | SQL, MongoDB
- Overall seniority level
- Senior
- Test duration
- 56 minutes
- Evaluation
- Automatic
- Tested skills:
Test overview
Test is combined from various tasks. SQL task, Choice questions and Code gaps. All evaluated automatically.
Task types
Code gaps
NoSQL | Mongo | Update records meeting the criteria code gap assessing knowledge of Mongo, MongoDB, NoSQL
Level: Hard
Tested skills: Mongo, MongoDB, NoSQL
SQL task
SQL | MySQL | Fill sparse table - Write a query that will return the list of all users with the creation date and return the date from the previous not-null row for the entries affected with the bug.
Level: Hard
Tested skills: HSQLDB, MySQL, SQL
Code gaps
NoSQL | Mongo | Return specified products code gap assessing knowledge of Mongo, MongoDB, NoSQL
Level: Hard
Tested skills: Mongo, MongoDB, NoSQL
Choice questions
6 choice questions assessing knowledge of MongoDB, NoSQL, SQL
Level: Hard
Tested skills: MongoDB, NoSQL, SQL
Automatic evaluation
We automatically score multi-choice tests and programming tasks and evaluate candidate code for logical correctness, time efficiency and code quality.