The LIST and PUT commands are specific to SnowSQL and cannot be executed in the web interface or other SQL clients. LIST is used to display the contents of a stage, and PUT is used to upload files to a stage.
References: [COF-C02] SnowPro Core Certification Exam Study Guide

Network policies in Snowflake can be set at the user level and at the account level2.
Reference: https://docs.snowflake.com/en/user-guide/network-policies.html#creating-network-policies

The ACCESS_HISTORY view in the SNOWFLAKE.ACCOUNT_USAGE schema contains information about the access history of Snowflake objects, such as tables and views, within the last 365 days1.

The command to list all the file formats for which a user has access privileges in Snowflake isSHOW FILE FORMATS. This command provides a list of all file formats defined in the user's current session or specified database/schema, along with details such as the name, type, and creation time of each file format. It is a valuable tool for users to understand and manage the file formats available for data loading and unloading operations.
References:
* Snowflake Documentation: SHOW FILE FORMATS

To minimize Continuous Data Protection (CDP) costs when dealing with large, high-churn dimension tables in Snowflake, using transient tables is a recommended approach.
Transient Tables: These are designed for data that does not require fail-safe protection. They provide the benefit of reducing costs associated with continuous data protection since they do not have the seven-day Fail- safe period that is mandatory for permanent tables.
Periodic Copying to Permanent Tables: By periodically copying data from transient tables to permanent tables, you can achieve a balance between data protection and cost-efficiency. Permanent tables offer the extended data protection features, including Time Travel and Fail-safe, butthese features can be applied selectively rather than continuously, reducing the overall CDP costs.
Snowflake Documentation on Transient Tables
Snowflake Documentation on Time Travel & Fail-safe