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