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

Updated On: 16-Feb-2026

Which of the following are main sections of the top navigation of the Snowflake Web Interface (UI)? (Choose three.)

  1. Databases
  2. Tables
  3. Warehouses
  4. Worksheets

Answer(s): A,C,D


Reference:

https://docs.snowflake.com/en/user-guide/snowflake-manager.html



What is the recommended Snowflake data type to store semi-structured data like JSON?

  1. VARCHAR
  2. RAW
  3. LOB
  4. VARIANT

Answer(s): D


Reference:

https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html



Which of the following statements are true of Snowflake releases: (Choose two.)

  1. They happen approximately weekly
  2. They roll up and release approximately monthly, but customers can request early release application
  3. During a release, new customer requests/queries/connections transparently move over to the newer version
  4. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

Answer(s): A,C



Which of the following are common use cases for zero-copy cloning? (Choose three.)

  1. Quick provisioning of Dev and Test/QA environments
  2. Data backups
  3. Point in time snapshots
  4. Performance optimization

Answer(s): A,B,C


Reference:

https://community.snowflake.com/s/question/0D50Z00009C3VlMSAV/zero-copy-cloning



If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

  1. 4
  2. 16
  3. 32
  4. 128

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html






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

Join the COF-C02 Discussion