Materialized views are recommended for all of the scenarios except

Materialized views are recommended for all of the scenarios except
A . Query results contain a small number of rows and/or columns relative to the base table
B. Query results contain results that require significant processing
C. The query is on an external table
D. The view’s base table changes frequently

View Answer

Answer: D

Explanation:

Materialized views are particularly useful when:

Query results contain a small number of rows and/or columns relative to the base table (the table on which the view is defined).

Query results contain results that require significant processing, including:

Analysis of semi-structured data.

Aggregates that take a long time to calculate.

The query is on an external table (i.e. data sets stored in files in an external stage), which might have slower performance compared to querying native database tables. The view’s base table does not change frequently.