Skip to content
Skills
Problems
Questions
Roles
Skills
Interview
Contest
Leaderboard
More
Problems
Questions
Roles
Skills
Interview
Contest
Leaderboard
More
Home
/
Data Engineer
/
Questions
/
Data modelling
Data Engineer
Data modelling questions
13 questions on Data modelling for data engineers, easiest first.
Easy
8
Fact and dimension tables
easy
Purpose of a primary key
easy
Partitioning a big table
easy
Star vs snowflake schema
easy
Grain of a fact table
easy
Why use surrogate keys
easy
SCD type that overwrites
easy
Goal of normalisation
easy
Medium
4
Tracking customer address history
medium
Revenue doubled after a join
medium
Keeping just the previous value
medium
Data Vault building blocks
medium
Hard
1
Double counting in an SCD2 join
hard
