When a virtual warehouse in Snowflake is suspended, the cache is dropped and is no longer available upon restart. This means that all cached data, including results and temporary data, are cleared from memory. The purpose of this behavior is to conserve resources while the warehouse is not active. Upon restarting the warehouse, it will need to reload any data required for queries from storage, which may result in a slower initial performance until the cache is repopulated. This is a critical consideration for managing performance and cost in Snowflake.

Snowflake supports several official connectors and drivers, including:
* Go Snowflake Driver
* Snowflake Connector for Python
Perl, COBOL, and MongoDB drivers are not supported by Snowflake.
Reference:
Snowflake Docs: Client Drivers and Connectors

The Snowflake command to unload the result of a query to a single file is COPY INTO <internal stage> with SINGLE = TRUE followed by a GET command to download the file.This command unloads the query result into a single file in the specified internal stage

When a cloned table is replicated to a secondary database in Snowflake, the following occurs:
C . The physical data is replicated: The actual data of the cloned table is physically replicated to the secondary database.This ensures that the secondary database has its own copy of the data, which can be used for read-only purposes or failover scenarios1.
E . Metadata pointers to cloned tables are replicated: Along with the physical data, the metadata pointers that refer to the cloned tables are also replicated.This metadata includes information about the structure of the table and any associated properties2.
It's important to note that while the physical data and metadata are replicated, the secondary database is typically read-only and cannot be used for write operations. Additionally, while there may be additional storage costs associated with the secondary account, this is not a direct result of the replication process but rather a consequence of storing additional data.
References:
SnowPro Core Exam Prep - Answers to Snowflake's LEVEL UP: Backup and Recovery Snowflake SnowPro Core Certification Exam Questions Set 10