Hotels – hotels page optimization Test for Middle Data Engineer | SQL, PostgreSQL
- Overall seniority level
- Middle
- Test duration
- 44 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
SQL | No duplicate without distinct code gap assessing knowledge of SQL
Level: Medium
Tested skills: SQL
Code gaps
SQL | Self join code gap assessing knowledge of SQL
Level: Medium
Tested skills: SQL
Code gaps
SQL | Add a calculated column code gap assessing knowledge of SQL
Level: Medium
Tested skills: SQL
SQL task
SQL | PostgreSQL | Hotels - hotels page optimization - Improve the performance of the the hotels listing page which currently uses ORM.
Level: Medium
Tested skills: PostgreSQL, SQL
Choice questions
3 choice questions assessing knowledge of MySQL, SQL
Level: Medium
Tested skills: MySQL, SQL
Automatic evaluation
We automatically score multi-choice tests and programming tasks and evaluate candidate code for logical correctness, time efficiency and code quality.