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 clustering or sort keys used for in a warehouse table?

  1. A Physically ordering data so related rows sit together and scans are reduced
  2. B Grouping users by role
  3. C Balancing server load
  4. D Compressing the schema
Answer

Physically ordering data so related rows sit together and scans are reduced

Combined with partitioning, good clustering can reduce the data scanned by orders of magnitude on selective queries.

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