Snowflake streams are objects that enable users to track changes (inserts, updates, and deletes) to the data in tables, facilitating real-time data processing and integration workflows. Streams can be created on standard tables, capturing DML changes made to these tables so that downstream processes can consume the changes incrementally. This feature supports efficient data ETL, replication, and real-time analytics by providing a mechanism to process only the data that has changed. Note: The correct options should likely include a distinction between "Standard tables" and another object type such as "External tables" rather than repeating
"Standard tables" twice.
References: Snowflake Documentation on Streams

The COPY INTO < location > command is used to unload data from Snowflake tables to external locations
, typically cloud storage or a Snowflake stage. Supported destinations include:
* External stages : e.g., S3, Azure Blob Storage, Google Cloud Storage
* Internal named stages : Snowflake-managed storage
Local file systems are not supported as unload targets.
Reference:
Snowflake Docs: COPY INTO < location > (unloading)
"You can unload data to: Internal Named Stages and External Stages (S3, Azure, GCS)"

Snowflake recommends file sizes between 100-250 MB compressed when loading data to optimize parallel processing. Smaller, compressed files can be loaded in parallel, which maximizes the efficiency of the virtual warehouses and speeds up the data loading process

Clustering keys in Snowflake work by sorting the designated columns over time. This process is done in the background and does not block data manipulation language (DML) operations, allowing for normal database operations to continue without interruption. The purpose of clustering keys is to organize the data within micro-partitions to optimize query performance1.
References:
* [COF-C02] SnowPro Core Certification Exam Study Guide
* Snowflake Documentation on Clustering1

When a database is cloned in Snowflake, it does not retain any privileges that were granted on the source object. The clone will need to have privileges reassigned as necessary for users to access it. References:
[COF-C02] SnowPro Core Certification Exam Study Guide