>
SQL
Programming
ETL knowledge
Evaluates concepts and terminology of ETL (extract, transform, load) in 20 questions and 30 minutes, from load types to the layers of a data warehouse.
Difficulty
Intermediate
20
questions
Time limit of
30
mins
English
About this test
Twenty multiple-choice questions on concepts. The candidate does not write code or configure a tool. Most questions are tool-neutral, but a few use terms from specific ETL tools, such as worklets, mapplets and connected lookups.
It checks the theory behind data integration work, not hands-on skill with a particular tool or with SQL. For SQL knowledge, pair it with the matching SQL test.
What it measures
Full loads compared with incremental loads
Snapshots, views and materialized views
Partitioning, including round-robin partitioning
Mappings, worklets and mapplets
The operational data store and the layers of a data warehouse: data sources, staging area, ETL layer and metadata layer
Factless fact schemas and connected lookups
Ideal for
ETL developers
Data engineers and data warehouse analysts
Business intelligence candidates who work with data integration
Details
Programming
Difficulty
Intermediate
Time limit of
30
mins
SQL
English
20
questions
Average duration:
0
min
36
times completed