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 a materialised view?

  1. A A stored, precomputed query result that is refreshed periodically
  2. B A virtual table evaluated at query time
  3. C A backup of a table
  4. D An index on multiple columns
Answer

A stored, precomputed query result that is refreshed periodically

It trades storage and refresh cost for query speed, which suits expensive aggregations queried far more often than the data changes.

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