COF-C03 - Snowflake AI Data Cloud Features and Architecture - Section 1.7
Distinguish table types (permanent, transient, temporary, external, dynamic, and Apache Iceberg) and view types (standard, secure, and materialized).
Distinguish permanent, transient, and temporary tables by their Time Travel and Fail-safe behaviour and cost, and recognise external tables over data lake files, dynamic tables that refresh from a query, and Apache Iceberg tables in open table format. Compare standard, secure, and materialized views and when each is appropriate.
permanent transient temporary tablesexternal tablesdynamic tablesApache Iceberg tablessecure and materialized views
More in this domain
Back to all Snowflake AI Data Cloud Features and Architecture objectives, or the COF-C03 cert hub.
Examworthy is not affiliated with or endorsed by Snowflake. Original, blueprint-aligned practice material only.