Quiz · 4 questions

🗺️ Modeling — How Analytics Tables Are Designed

Star schemas, slowly changing dimensions, dbt, and lineage.

Level 0Curious Reader

0 XP0/47 lessons0/11 achievements

0/120 XP to next level120 XP to go0% complete

Quiz

01What does the grain of a fact table mean?

02When should you reach for a snowflake schema instead of a star schema?

03A customer's tier changes from silver to gold. Past orders should remain attributed to the customer's tier at the time of the order. Which SCD type fits?

04What does dbt's {{ ref('stg_orders') }} macro do that hard-coding the table name doesn't?

← PreviousLineage — Knowing Where Every Number Came From 🏭 Production — The Real World →Monitoring Pipelines That Run at Night

Spotted a bug or have feedback on this page?Report an Issue

Comments 0

🔔 Reply notifications (sign in)

No comments yet — be the first.