Intermediate Data Warehousing test (Intermediate)
30 questions · 35 minutes · Free
Dimensional modelling, slowly changing dimensions and loading patterns.
Take the Intermediate Data Warehousing test
What it covers
- Kimball dimensional modelling
- Slowly changing dimensions (types 1, 2, 3)
- Surrogate keys
- Incremental and change data capture loads
- Aggregate tables
Interview format
- Questions: 30 questions — 18 multiple choice, 9 multi-answer, 3 predict-the-output
- Time: 35 minutes, timed from the first question
- Difficulty: Intermediate
- Skill area: Data
- Price: Free
Earn a certificate
The Intermediate Data Warehousing test is one of the 8 tests of the Data Engineer: Intermediate learning path. Pass it and the other 7 tests at 70% or more and readyforhires issues you a verifiable certificate in your name, with its own code and verify link to share or add to LinkedIn.
Frequently asked questions
- How many questions are in the Intermediate Data Warehousing test?
- 30 questions (18 multiple choice, 9 multi-answer, 3 predict-the-output), with 35 minutes to answer them.
- What does the Intermediate Data Warehousing test cover?
- Kimball dimensional modelling, Slowly changing dimensions (types 1, 2, 3), Surrogate keys, Incremental and change data capture loads, Aggregate tables.
- Is the Intermediate Data Warehousing test free?
- Yes. It is free to take with a readyforhires account.
- What level is the Intermediate Data Warehousing test?
- Intermediate, in Data.