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

How does a snowflake schema differ from a star schema?

  1. A Its dimension tables are normalised into further sub-dimensions
  2. B It has no fact table
  3. C It uses only one table
  4. D It stores data in columns
Answer

Its dimension tables are normalised into further sub-dimensions

Snowflaking saves some storage but adds joins, which usually costs more in query performance than it saves in space.

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