Arena · Data Engineering · Pipeline Engineering · intermediate

Surrogate vs natural keys

When would you use a surrogate key versus a natural key as the primary key in a data warehouse dimension table? What are the practical trade-offs?

Sign in to see what a strong answer covers and to get AI feedback on your own.

Practice this question on PrepGraph