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

Updated On: 16-Feb-2026

Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:

  1. Micro-partitions
  2. Clustering keys
  3. Key partitions
  4. Clustered partitions

Answer(s): B


Reference:

https://community.snowflake.com/s/article/Snowflake-What-the-Cluster



Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

  1. Custom
  2. Economy
  3. Optimized
  4. Standard

Answer(s): B,D


Reference:

https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance



True or False: A single database can exist in more than one Snowflake account.

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/sql-reference/ddl-database.html



Which of the following roles is recommended to be used to create and manage users and roles?

  1. SYSADMIN
  2. SECURITYADMIN
  3. PUBLIC
  4. ACCOUNTADMIN

Answer(s): B



True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

  1. True
  2. False

Answer(s): A






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

Join the COF-C02 Discussion