A materialized view should be created when which of the following occurs? (Choose two.)
A materialized view should be created when which of the following occurs? (Choose two.)
A materialized view should be created when the query consumes many compute resources every time it runs and the results of the query do not change often and are used frequently. This is because materialized views store the results of the query, which reduces the need to recompute those results frequently, saving on compute resources. Additionally, materialized views are most beneficial when the result set doesn't change often, so the stored results remain relevant for a longer period of time.
B&E https://docs.snowflake.com/en/user-guide/views-materialized.html#deciding-when-to-create-a-materialized-view
"The query consumes a lot of resources. Typically, this means that the query consumes a lot of processing time or credits, but it could also mean that the query consumes a lot of storage space for intermediate results." This is why it is not D
B&E Correct
B and D is the right answer Create a materialized view when all of the following are true: The query results from the view don’t change often. This almost always means that the underlying/base table for the view doesn’t change often, or at least that the subset of base table rows used in the materialized view don’t change often. The results of the view are used often (typically significantly more often than the query results change). The query consumes a lot of resources. Typically, this means that the query consumes a lot of processing time or credits, but it could also mean that the query consumes a lot of storage space for intermediate results.
BE are correct
correct
BE correct