Customer Data Test for Middle Data Engineer | SQL, MongoDB
- Overall seniority level
- Middle
- Test duration
- 51 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
SQL task
SQL | MySQL | 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.