MongoDB
MIDDLE

Customer Data Test for Middle Data Engineer | SQL, MongoDB

Overall seniority level
Middle
Test duration
51 minutes
Evaluation
Automatic

Test overview

Test is combined from various tasks. SQL task, Choice questions and Code gaps. All evaluated automatically.

Task types

SQL task

SQL | Customer Data - Find all the customers whose first and last names are not unique in this database, as well as the number of times each first and last name pair appears in the database.

Level: Medium

Tested skills: HSQLDB, MSSQL, MySQL, oracle, PostgreSQL, SQL

Code gaps

NoSQL | Mongo | Query | Update with the Lowest Value code gap assessing knowledge of Mongo, MongoDB, NoSQL

Level: Medium

Tested skills: Mongo, MongoDB, NoSQL

Code gaps

NoSQL | Mongo | Query | Number of Elements in Array code gap assessing knowledge of Mongo, MongoDB, NoSQL

Level: Medium

Tested skills: Mongo, MongoDB, NoSQL

Code gaps

NoSQL | Mongo | Query | Multiply Values code gap assessing knowledge of Mongo, MongoDB, NoSQL

Level: Medium

Tested skills: Mongo, MongoDB, NoSQL

Choice questions

5 choice questions assessing knowledge of MongoDB, NoSQL, SQL

Level: Medium

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.