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

What is an aggregate table used for?

  1. A Pre-summarising fact data at a coarser grain to speed common queries
  2. B Storing raw transactions
  3. C Holding dimension attributes
  4. D Logging pipeline runs
Answer

Pre-summarising fact data at a coarser grain to speed common queries

The trade-off is maintenance: every aggregate must be kept consistent with the underlying facts as they change.

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