Data Modeling
15 practice items · needed by 2 roles
Easy 9Medium 5Hard 1
Practice questions
- What a primary key guaranteeseasy
- Shaping a Power BI modelmedium
- Fact and dimension tableseasy
- Purpose of a primary keyeasy
- Partitioning a big tableeasy
- Star vs snowflake schemaeasy
- Grain of a fact tableeasy
- Why use surrogate keyseasy
- SCD type that overwriteseasy
- Goal of normalisationeasy
- Tracking customer address historymedium
- Revenue doubled after a joinmedium
- Keeping just the previous valuemedium
- Data Vault building blocksmedium
- Double counting in an SCD2 joinhard