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

Updated On: 17-Feb-2026

True or False: During data unloading, only JSON and CSV files can be compressed.

  1. True
  2. False

Answer(s): B


Reference:

https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html



Which of the following are options when creating a Virtual Warehouse? (Choose two.)

  1. Auto-suspend
  2. Auto-resume
  3. Local SSD size
  4. User count

Answer(s): A,B


Reference:

https://www.analytics.today/blog/what-is-a-snowflake-virtual-warehouse



Which formats are supported for unloading data from Snowflake? (Choose two.)

  1. Delimited (CSV, TSV, etc.)
  2. Avro
  3. JSON
  4. ORC

Answer(s): A,C


Reference:

https://docs.snowflake.com/en/user-guide/data-unload-prepare.html



True or False: Data Providers can share data with only the Data Consumer.

  1. True
  2. False

Answer(s): B



The fail-safe retention period is how many days?

  1. 1 day
  2. 7 days
  3. 45 days
  4. 90 days

Answer(s): B


Reference:

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






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

Join the COF-C02 Discussion