Snowflake COF-C02 Exam Questions
SnowPro Core (Page 10 )

Updated On: 16-Feb-2026

Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

  1. Scaling rhythmically
  2. Scaling max
  3. Scaling out
  4. Scaling up

Answer(s): C



Which statement best describes Snowflake tables?

  1. Snowflake tables are logical representations of underlying physical data
  2. Snowflake tables are the physical instantiation of data loaded into Snowflake
  3. Snowflake tables require that clustering keys be defined to perform optimally
  4. Snowflake tables are owned by a user

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/tables-micro-partitions.html



Which item in the Data Warehouse migration process does not apply in Snowflake?

  1. Migrate Users
  2. Migrate Schemas
  3. Migrate Indexes
  4. Build the Data Pipeline

Answer(s): C



Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: (Choose two.)

  1. Temporary Tables
  2. Transient Tables
  3. Provisional Tables
  4. Permanent Tables

Answer(s): A,B


Reference:

https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html



What is the maximum compressed row size in Snowflake?

  1. 8KB
  2. 16MB
  3. 50MB
  4. 4000GB

Answer(s): B






Post your Comments and Discuss Snowflake COF-C02 exam dumps with other Community members:

Join the COF-C02 Discussion