Snowflake COF-R02 Practice Test - Questions Answers, Page 8

Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html

By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. To unload data to a single output file (at the potential cost of decreased performance), specify the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the path.

Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-asuspended-warehouse

Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html

Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html

Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature cannot be enabled or disabled from the user end .

Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.

https://docs.snowflake.com/en/user-guide/warehousesoverview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters%20in%20the%20warehouse.