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 are columnar storage formats efficient for analytical queries?

  1. A Only the columns referenced are read, and similar values compress well together
  2. B They store fewer rows
  3. C They avoid indexing
  4. D They are always smaller
Answer

Only the columns referenced are read, and similar values compress well together

An analytical query touching three columns of a fifty-column table reads a fraction of the data a row store would.

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