Snowflake COF-R02 - Questions & Answers

All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema.
https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks

References:
https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html

References:
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history
"When a pipe is recreated, the load history is dropped."

References:
https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html

References:
https://docs.snowflake.com/en/user-guide/intro-editions.html

References:
https://docs.snowflake.com/en/user-guide/intro-editions.html

Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.

https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remainder%20of%20the%20session.