MongoDB
SENIOR

Fill sparse table

Test for Senior Data Engineer | SQL, MongoDB

Overall seniority level

Senior

Test duration

56 minutes

Evaluation

Automatic

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 | 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.