Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Why should surrogate keys be used rather than natural keys in a dimensional model?

  1. A They remain stable when source systems change and support Type 2 history
  2. B They are shorter to type
  3. C They are required by SQL
  4. D They improve encryption
Answer

They remain stable when source systems change and support Type 2 history

With Type 2 dimensions the natural key repeats across versions, so only a surrogate key can uniquely identify a specific version.

All Data Warehousing MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as