Which term describes the storage of a view as a table on disk?

Which term describes the storage of a view as a table on disk?

• A. Backup
• B. Authentication
• C. View Materialized
• D. Catalog

Answer: (C)

Materialized view is the idea of taking the result of a query and storing it as a physical table on disk. This means the data is materialized, not computed on every access, which gives fast reads and the ability to index the stored results. It’s what you use when you want to precompute and cache complex queries for performance, with a refresh mechanism to keep the cached data up to date. In contrast, a backup is simply a copy of data for recovery purposes, authentication deals with verifying who you are, and a catalog is a metadata repository about database objects. None of those describe storing a view’s results as an actual table on disk the way a materialized view does.

Materialized view is the idea of taking the result of a query and storing it as a physical table on disk. This means the data is materialized, not computed on every access, which gives fast reads and the ability to index the stored results. It’s what you use when you want to precompute and cache complex queries for performance, with a refresh mechanism to keep the cached data up to date.

In contrast, a backup is simply a copy of data for recovery purposes, authentication deals with verifying who you are, and a catalog is a metadata repository about database objects. None of those describe storing a view’s results as an actual table on disk the way a materialized view does.