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