Exam4Training

How do you refresh a materialized view?

How do you refresh a materialized view?
A . ALTER VIEW <MV_NAME> REFRESH
B . REFRESH MATERIALIZED VIEW <MV_NAME>
C . Materialized views are automatically refreshed by snowflake and does not require manual intervention

Answer: C

Explanation:

Materialized views are automatically and transparently maintained by Snowflake. A background service updates the materialized view after changes are made to the base table. This is more efficient and less error-prone than manually maintaining the equivalent of a materialized view at the application level. https://docs.snowflake.com/en/user-guide/views-materialized.html#when-to-use-materialized-views

Latest ARA-C01 Dumps Valid Version with 156 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version